ALL,

Ok, I've been sitting at work looking at this ODBC issue for the past 4 hours. I need to know if there is a way to have a connection in a project and set the properties, such as userid and password, BEFORE connecting.

Thanks

Jim

>Hi Jim,
>
>I'm sorry for later reply, but I forgot your question.
>
>No, simply. U can use ODBC API for reading DSN(user/system) or File DSN and writing into your files.
>
>MartinJ
>
>
>>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?