ODBC connection error

Hello,

I'm using ODBC to connect my VB6 application to a MS SQL database.
I have created a new System DSN and it works well.

The code is OK but the connection doesn't work. the message is: "Cannot open database requested in login "....". Login fails.

Could you help me?

Thanks
Sylvain

My guess would be that either an invalid username/password are being provided in the ConnectionString property of the connection or there is some other value in the ConnectionString property that is invalid.

Hello,

I'm using ODBC to connect my VB6 application to a MS SQL database.
I have created a new System DSN and it works well.

The code is OK but the connection doesn't work. the message is: "Cannot open database requested in login "....". Login fails.

Could you help me?

Thanks
Sylvain

http://www.able-consulting.com./MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer