Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Hi, I have a Microsoft Access database (Park.mdb). Now I want to read its records and display them. To do so, I write the following ASP code(test.asp):
-----------------------------------------------------------------------
[code]
<%@ Language=VBScript %>
<%
DIM ObjConn
Set ObjConn=Server.CreateObject("ADODB.Connection")
ObjConn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};"& "DBQ=Park.mdb"
ObjConn.Open
DIM objRs
Set ObjRs=Server.CreateObject("ADODB.RecordSet")
ObjRs.Open "AcceptForm",objConn, , ,2

Do While Not ObjRs.EOF
Response.Write ObjRs("Name")
ObjRs.MoveNext
Loop

ObjRs.Close
Set ObjRs=Nothing
ObjConn.Close
Set ObjConn=Nothing
%>
[/code]
-----------------------------------------------------------------------Please note that this asp file (test.asp) is located on the same directory of Park.mdb .
When I run this asp file (www.mysite.com/test.asp) I got the following error:
***********************************************************************
[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 0x6e4 Thread 0xb14 DBC 0xa1cd2ac Jet'.
/test.asp, line 6
[/code]
line 6 is : ObjConn.Open
Now, could you please tell me what is the wrong?
Thanks

Comments

  • FlakesFlakes Member Posts: 642
    : Hi, I have a Microsoft Access database (Park.mdb). Now I want to read its records and display them. To do so, I write the following ASP code(test.asp):
    : -----------------------------------------------------------------------
    : [code]
    : <%@ Language=VBScript %>
    : <%
    : DIM ObjConn
    : Set ObjConn=Server.CreateObject("ADODB.Connection")
    : ObjConn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};"& "DBQ=Park.mdb"
    : ObjConn.Open
    : DIM objRs
    : Set ObjRs=Server.CreateObject("ADODB.RecordSet")
    : ObjRs.Open "AcceptForm",objConn, , ,2
    :
    : Do While Not ObjRs.EOF
    : Response.Write ObjRs("Name")
    : ObjRs.MoveNext
    : Loop
    :
    : ObjRs.Close
    : Set ObjRs=Nothing
    : ObjConn.Close
    : Set ObjConn=Nothing
    : %>
    : [/code]
    : -----------------------------------------------------------------------Please note that this asp file (test.asp) is located on the same directory of Park.mdb .
    : When I run this asp file (www.mysite.com/test.asp) I got the following error:
    : ***********************************************************************
    : [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 0x6e4 Thread 0xb14 DBC 0xa1cd2ac Jet'.
    : /test.asp, line 6
    : [/code]
    : line 6 is : ObjConn.Open
    : Now, could you please tell me what is the wrong?
    : Thanks
    :
    :


    Use the Jet OleDB Provider instead of the Access Driver.


    ObjConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source="&Server.MapPath("Park.mdb")&";"





Sign In or Register to comment.