Is there a way to have the connection within the project access the ODBC connection properties. So if the ODBC connection changes the connection in the project would update?
Jim
>Hi Jim
>
>1) How to create user DSN on machine: MSKB#
Q142216>
>2) VFP connection you can will create:
>2a) SQLCONNECT("DSN","USER","PWD")
>2b) SQLSTRINGCONNECT("DSN|driver name; other_atributes")
>2c) create temporary DBC with connections (
DBSETPROP())
>
>3) Information about connections can be stored in:
>3a) external DBF/INI/XML
>3b) DBC on network with default connection (
DBGETPROP())
>
>
>MartinJ
>
>>All
>>
>>I have an application that connects to a SQL Server Database on a remote server through an ODBC connection. For each work station that the application will run on the connection will be different. I need to know how to either get the connection in the project to read the ODBC connection information. So if the connection information within the ODBC connection changes the application connects using the new information. What is the best way to do this, or is there a better technique?
Thanks
Jim