Click to See Complete Forum and Search --> : asp connection to sql server


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

edborva
11-16-2007, 06:45 PM
this error generally indicates that the db has been removed or that the db is off limits. contact your admin

Ed