Cannot open database....requested by the login.
I am using VWD, SQL Server Management Express, and an ODBC connection to
create a simple ASP page.
I am getting the following error on my machine.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "ogame"
requested by the login. The login failed.
The relevant code (I believe) is this:
set cn = Server.CreateObject("ADODB.Connection")
cn.open "ogee","ogeez", "ogeez"
response.write "<P> Connection Created!"
planet_id = request.form("plid")
strSelPlanet = strSelPlanet + "SELECT * FROM USERPLANETS WHERE PLANET_ID =
" + cstr(planet_id)
response.write "Opening the following recordset" + strSelPlanet
rs.open strSelPlanet, "DSN=ogee;UID=ogeez;PWD=ogeez"
response.write "<P>Recordset opened!"
Pertinent ODBC Settings Are
Driver: SQL Native client
I seem to be able to connect to the database through everything but the .asp
I am pretty much at wit's end about this whole thing. Any suggestions?