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.

Error Type:
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
set rs=Server.CreateObject("ADODB.Recordset")
rs.open strSelPlanet, "DSN=ogee;UID=ogeez;PWD=ogeez"
response.write "<P>Recordset opened!"

Pertinent ODBC Settings Are
Driver: SQL Native client
Name: ogee
Server: (local)
DefaultDB: ogee

I seem to be able to connect to the database through everything but the .asp
page.
I am pretty much at wit's end about this whole thing. Any suggestions?