esthera
11-13-2007, 12:35 PM
I am trying to open a connection to an sql server db.
i'm getting an error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "db" requested by the login. The login failed.
my code is
strcon="Driver={SQL Server};Server=111.111.1.222;Database=db;UID=myuser;PWD=abc1"
objconn.commandtimeout=0
objconn.Open strCon
i'm getting an error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "db" requested by the login. The login failed.
my code is
strcon="Driver={SQL Server};Server=111.111.1.222;Database=db;UID=myuser;PWD=abc1"
objconn.commandtimeout=0
objconn.Open strCon