>>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?>>
Im using connections stored on a VFP Database(I create DSN and save on my application data directory) and here is my connection:
DRIVER=SQL Server;SERVER=DPS;UID=username;
APP=Microsoft (R) Visual FoxPro;WSID=DPS;DATABASE=DPSCRM;
Network=DBMSLPCN;Trusted_Connection=Yes
If you can notice the server & the workstationID are same it works well on my experience :) I have only Sql client installed from my pc when accessing server data stored remotely (Local Area Network).
Then I just use/invoked the connection name everytime I want to connect to the server from my application..
STORE SQLCONNECT("dps_crm") TO lnConnHandle
Not necessary to go to every client user to configure ODBC..