RE: Twin Process for 4D SQL Data Source

2017-12-13 Thread Timothy Penner via 4D_Tech
[mailto:alantil...@gmail.com] Sent: Wednesday, December 13, 2017 1:25 PM To: Timothy Penner Cc: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: Twin Process for 4D SQL Data Source Hello Tim, Thanks for the info. Where do I find pricing for ODBC Pro? Alan On Wed, Dec 13, 2017 at 4:20 PM, Timothy

Re: Twin Process for 4D SQL Data Source

2017-12-13 Thread Alan Tilson via 4D_Tech
Hello Tim, Thanks for the info. Where do I find pricing for ODBC Pro? Alan On Wed, Dec 13, 2017 at 4:20 PM, Timothy Penner wrote: > Hi Alan, > > > but I couldn't find a place where it is sold for 4d server. > > ODBC Pro can be purchased as an expansion when configuring a new server on > the stor

RE: Twin Process for 4D SQL Data Source

2017-12-13 Thread Timothy Penner via 4D_Tech
Hi Alan, > but I couldn't find a place where it is sold for 4d server. ODBC Pro can be purchased as an expansion when configuring a new server on the store: https://store.4d.com/us/article/4USE16.shtml https://store.4d.com/us/article/4USD16.shtml ODBC Pro can also be purchased as an addon for a

Re: Twin Process for 4D SQL Data Source

2017-12-13 Thread Alan Tilson via 4D_Tech
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 inte

Re: Twin Process for 4D SQL Data Source

2017-12-13 Thread Charles Miller via 4D_Tech
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

Re: Twin Process for 4D SQL Data Source

2017-12-13 Thread Alan Tilson via 4D_Tech
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 rat

Re: Twin Process for 4D SQL Data Source

2017-12-13 Thread Chuck Miller via 4D_Tech
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 --

Twin Process for 4D SQL Data Source

2017-12-13 Thread Alan Tilson via 4D_Tech
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