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.
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 10Her 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 connectionI 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 helpMike M |
|
|
|
|