RE: Twin Process for 4D SQL Data Source

2017-12-13 Thread Timothy Penner via 4D_Tech 
Following the links I provided should provide a price;
It should be listed next to the checkbox for the expansion.

Pricing could be different depending on your level of partnership;
so the best way to get accurate pricing is to call your account/sales rep.

-Tim





From: Alan Tilson [mailto:alantil...@gmail.com]
Sent: Wednesday, December 13, 2017 1:25 PM
To: Timothy Penner <tpen...@4d.com>
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 Penner 
<tpen...@4d.com<mailto:tpen...@4d.com>> 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 
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 an existing server via the 
'Extend your configuration' on the store:
https://store.4d.com/us/extendConfigurator.shtml

In case you wanted to see it, here is the product page for ODBC Pro:
http://www.4d.com/products/4dv16/4dodbcpro.html

Hope that helps!

-Tim





Timothy Penner
Senior Technical Services Engineer

4D Inc
95 S. Market Street, Suite #240
CA 95113 San Jose
United States

Telephone : +1-408-557-4600<tel:%2B1-408-557-4600>
Standard :  +1-408-557-4600<tel:%2B1-408-557-4600>
Fax :   +1-408-271-5080<tel:%2B1-408-271-5080>
Email : tpen...@4d.com<mailto:tpen...@4d.com>
Web :   www.4D.com<http://www.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
**

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 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 an existing server via the
> 'Extend your configuration' on the store:
> https://store.4d.com/us/extendConfigurator.shtml
>
> In case you wanted to see it, here is the product page for ODBC Pro:
> http://www.4d.com/products/4dv16/4dodbcpro.html
>
> Hope that helps!
>
> -Tim
>
>
>
>
>
> Timothy Penner
> Senior Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
>
> Telephone : +1-408-557-4600
> Standard :  +1-408-557-4600
> Fax :   +1-408-271-5080
> Email : tpen...@4d.com
> Web :   www.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
**

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 an existing server via the 
'Extend your configuration' on the store:
https://store.4d.com/us/extendConfigurator.shtml

In case you wanted to see it, here is the product page for ODBC Pro:
http://www.4d.com/products/4dv16/4dodbcpro.html

Hope that helps!

-Tim






**
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
**

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 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:cjmillerinformed-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

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 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:cjmillerinformed-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:

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 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:cjmillerinformed-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
**

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 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!

Thanks,
Alan Tilson
**
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
**