Looking for SQL Server examples

[Liska Station]

Howdy everyone!

I'm working on a program for a client, and I need to query for data on an
existig SQL server(s) at several of their locations, and am wondering if
there are any good examples of code for getting data off of them on a
deployed app (they won't be running VFP on any of their machines, and I'm not
sure if the connection designer settings will work with a distriuted app.)

Thanks y'all!

-LS

[Fred Taylor]

I wouldn't use the connection designer at all, I'd use SQLSTRINGCONNECT().
You can build up the connection string in code, or you can retrieve it from
a file or a VFP table.

See www.connectionstrings.com for your connection strings.
--
Fred
Microsoft Visual FoxPro MVP

Post by Liska Station
Howdy everyone!
I'm working on a program for a client, and I need to query for data on an
existig SQL server(s) at several of their locations, and am wondering if
there are any good examples of code for getting data off of them on a
deployed app (they won't be running VFP on any of their machines, and I'm not
sure if the connection designer settings will work with a distriuted app.)
Thanks y'all!
-LS

[Liska Station]

Thanks! I was thinking that might be the case, but this is really a big
push in the right direction.

Thanks again!

Post by Fred Taylor
I wouldn't use the connection designer at all, I'd use SQLSTRINGCONNECT

().

Post by Fred Taylor
You can build up the connection string in code, or you can retrieve it from
a file or a VFP table.
See www.connectionstrings.com for your connection strings.