Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Database is not connecting with ASP...

Author  Topic 

huge
Starting Member

31 Posts

Posted - 2001-07-31 : 11:15:01
I have an asp site which I am constructing and I have finished the database design and such. Now I want to start connecting to the DB using ASP. This is my first time doing this with SQL server. I keep getting this error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'AdultMatch'. Login fails.
/Match/sessionid.asp, line 10


Her is the script that runs this database (its asp):

set conn = Server.CreateObject("ADODB.CONNECTION")
conn.Open "dsn=AdultMatch"
dim UserIP
UserIP= request.servervariables("REMOTE_ADDR")
dim MySQL
MySQL = "Execute sproc_getSID '" & UserIP & "'"
SET ORS = conn.Execute (MySQL) ' creates and executes the recordset
SID = ORS("SID") 'Gets the SID value from the recordset
ORS.Close 'close the recordset
set conn = nothing 'close the connection

I have no idea what is wrong. I have registered the DNS on the system. There is no uname and pwd as far as I am concerned. Does this mean I have to setup a new user in SQL Server? The setting on the systems ODBC is that it connects with "Windows NT authentication using network login ID"

I have no idea on the security issues with SQL and how to set them.

Thanks for any help
Mike M

   

- Advertisement -