I am new to ASP and am trying to get this connection string to work. I would thankful to any one that might be able to help me. Thanks in advance
<%
Dim adoCon 'Database Connection Variable
Dim rsCommon 'Holds the configuartion recordset
Dim strCon 'Holds the Database driver and the path and name of the database
Dim strSQL 'Holds the SQL query for the database
Dim strDbPathAndName 'Holds the path and name of the database
Set adoCon = Server.CreateObject("ADODB.Connection")
strDbPathAndName = Server.MapPath("admin/database/player.mdb")
strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & strDbPathAndName
adoCon.connectionstring = strCon
adoCon.Open
Set rsCommon = Server.CreateObject("ADODB.Recordset")
rsCommon.Open strSQL, adoCon
rsCommon.Close
%>
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x4f4 Thread 0x9a0 DBC 0xc633f64 Jet'.
/profile manager/connection2.asp, line 17
Edited by choshour