ODBC connection error

sthevoz
01-15-2004, 08:28 AM
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

00100b
01-15-2004, 11:20 AM
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.

Tzuten
01-15-2004, 01:52 PM
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

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum