Chuck, 4D ODBC Pro is still listed on the 4D website for v16 and it says that it comes with 4D Developer Professional and with Team Developer Professional, but I couldn't find a place where it is sold for 4d server. I prefer using the native core 4D functionalities wherever possible, but it is interesting that ODBC Pro offers cloning of 4D tables as ODBC tables and vice versa. One of the things I do regularly is to load data from 4d and theoretically the same data from the SQL Server system and compare it using arrays to find records that have changed. If this could be done within one SQL statement that would be great! I did see the expression *ConnectionID* in the ODBC Pro docs which implies that several connections could be open. Thanks, Alan
On Wed, Dec 13, 2017 at 1:51 PM, Charles Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Alan, > > Is there not a command that allows you to switch. I seem to remember > somethingt like Use Local but could not find it > > Regards > > > Chuck > > On Wed, Dec 13, 2017 at 1:12 PM, Alan Tilson via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > Hello Chuck, > > You are probably right. I just counted 14 logins to the SQL Server in 1 > min > > 50 sec so I ran a test logging in and out 20 times and this took 2.03 > > seconds. > > There would have to be some overhead associated with using a separate > > process so I doubt there would be any gain. > > It just seems rather clunky to have to login in and out and to not just > be > > able to specify which source to use or even to be able to use both > > simultaneously like Access can do! > > Thanks, > > Alan > > > > > > On Wed, Dec 13, 2017 at 12:46 PM, Chuck Miller via 4D_Tech < > > 4d_tech@lists.4d.com> wrote: > > > > > I have not but it seems to me to be a lot of work as you will have to > get > > > data/orrays/variables between processes and it would also seem to me > that > > > you could choose only one to put in a new process > > > > > > Regards > > > > > > Chuck > > > > > > ------------------------------------------------------------ > > > ------------------------------------ > > > Chuck Miller Voice: (617) 739-0306 > > > Informed Solutions, Inc. Fax: (617) 232-1064 > > > mailto:cjmiller<AT SIGN>informed-solutions.com > > > Brookline, MA 02446 USA Registered 4D Developer > > > Providers of 4D and Sybase connectivity > > > http://www.informed-solutions.com > > > ------------------------------------------------------------ > > > ------------------------------------ > > > This message and any attached documents contain information which may > be > > > confidential, subject to privilege or exempt from disclosure under > > > applicable law. These materials are intended only for the use of the > > > intended recipient. If you are not the intended recipient of this > > > transmission, you are hereby notified that any distribution, > disclosure, > > > printing, copying, storage, modification or the taking of any action in > > > reliance upon this transmission is strictly prohibited. Delivery of > this > > > message to any person other than the intended recipient shall not > > > compromise or waive such confidentiality, privilege or exemption from > > > disclosure as to this communication. > > > > > > > On Dec 13, 2017, at 12:28 PM, Alan Tilson via 4D_Tech < > > > 4d_tech@lists.4d.com> wrote: > > > > > > > > Hello everyone, > > > > > > > > I find myself switching data sources frequently (20 or more times in > a > > > few > > > > minutes-I'll count the number...) back and forth between 4D and my > > > client's > > > > MS SQL Server based system. So today I've been contemplating the idea > > > that > > > > I might put all my 4D SQL code in a separate process so that my each > > > > process could stay logged into either 4D/Local or the SQL Server. > > > > > > > > Has anyone tried this? If so, please share your thoughts on the > > benefits > > > > and complications and even solutions that this approach offers! > > > > > > ********************************************************************** > > > 4D Internet Users Group (4D iNUG) > > > FAQ: http://lists.4d.com/faqnug.html > > > Archive: http://lists.4d.com/archives.html > > > Options: http://lists.4d.com/mailman/options/4d_tech > > > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > > > ********************************************************************** > > ********************************************************************** > > 4D Internet Users Group (4D iNUG) > > FAQ: http://lists.4d.com/faqnug.html > > Archive: http://lists.4d.com/archives.html > > Options: http://lists.4d.com/mailman/options/4d_tech > > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > > ********************************************************************** > > > > > > -- > ------------------------------------------------------------ > ----------------------------- > Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 > Informed Solutions, Inc. > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D, Sybase & SQL Server connectivity > http://www.informed-solutions.com > ------------------------------------------------------------ > ----------------------------- > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, disclosure, > printing, copying, storage, modification or the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption > from disclosure as to this communication. > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** > ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
