Error

stacy · March 31st, 2004, 11:37 PM

Can someone please help me figure out why I get this code???

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 0x1aec Thread 0x1e38 DBC 0x157b024 Jet'.

/mercysch/temp/managementarea/Admin/Adminconnect.asp, line 6

is the error I get. On that adminconnect.asp, here is the code:


<%
Dim objConn
set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../temp/database/mercy.mdb")
  If Session("blnValidUser") = True and Session("AdminID") = "" Then
    Dim rsAdminIDCheck
    Set rsAdminIDCheck = Server.CreateObject("ADODB.Recordset")
    Dim strSQL
    strSQL = "SELECT AdminID FROM tblAdmin " & _
             "WHERE Username = '" & Session("Username") & "';"
    rsAdminIDCheck.Open strSQL, objConn
    If rsAdminIDCheck.EOF Then
      Session("blnValidUser") = False
    Else
      Session("AdminID") = rsAdminIDCheck("AdminID")
    End If
    rsAdminIDCheck.Close
    Set rsAdminIDCheck = Nothing
  End If
%>

Imar · April 1st, 2004, 03:06 AM

Hi Stacy,

Try upgrading the connection string you're using. You're using an "old skool" driver that is no longer recommended. Try this instead:

Code:

Dim ConnectionString
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
   "Data Source=" & Server.MapPath("../temp/database/mercy.mdb") &  _ 
   "User Id=admin;" & _
   "Password="
objConn.Open ConnectionString

Do you still get the same error?

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

stacy · April 8th, 2004, 09:55 PM

What do i put if there are alot of different usernames?

Imar · April 9th, 2004, 01:38 AM

Not sure what you mean by that. What user names are you referring to?

If you have stored your users in an ordinary table, there is no need to use specific user names to connect to the database. You can use the Admin account as in my example.

Are you talking about application users (your users) or user accounts as defined in the Access UI?

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Eurochild by Massive Attack (Track 7 from the album: Protection)