ODBC Connection

I have front-end visual basic program that use an ODBC connection to connect with SQL server, and my questions is there any automated procedure to configure this ODBC connection instead of configure it manually specially of the user profiles was changed I have to configure it again.

Please advise

YOu either could use a connection string for connecting instead of using a dsn, or you use an UDL file which is already configured for the appropiate parameters.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

As Jens said, you could use a DSN. An example of using this via SQLConnect( ) is on:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlconnect.asp.

Regardless of your connection method, you won't be able to store your user ID and password in the DSN. This would be a great security risk anyway. You could make the connection use a trusted connection, and rely on NT authentication to validate the user.

|||

Mohamed Hussein Kotat wrote:

I have front-end visual basic program that use an ODBC connection to connect with SQL server, and my questions is there any automated procedure to configure this ODBC connection instead of configure it manually specially of the user profiles was changed I have to configure it again.

Please advise

Try with string "ODBC; DSN=name_dsn; UID=sa; PWD=password_sa; DATABASE=database_name"