Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Minneapolis
    Posts
    2

    Unanswered: Jet DSN Database Error

    Hi,

    When I tried to execute the following code, it gives the following error message.

    # Code:
    -----------

    <%
    Dim Conn
    Dim name,email,how,feedback

    name=Request.Form("name")
    email=Request.Form("email")
    how=Request.Form("how")
    feedback=Request.Form("feedback")

    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" &
    Server.MapPath("/database/feedbackdb.mdb")
    Conn.Execute "INSERT INTO feedbacktable (name,email,how,feedback) VALUES ('"&name&"','"&email&"','"&how&"','"&feedback&"' )"

    Response.Write "<center><b>Dear "&name&", Your Feedback Submitted to Webmsater</b></center>"
    Conn.Close
    %>

    # Error Message:
    --------------------
    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 0x64c Thread 0xba8 DBC 0x5303004 Jet'.

    /freeconsult/addquery.asp, line 116


    I am using DSN-Less Connection with MS Access Version 7.0 for Windows 95.

    Please help me to correct the problem.
    Thank you in advance.

    Thanks,
    Vengy

  2. #2
    Join Date
    Mar 2003
    Location
    Atlanta, GA
    Posts
    191
    I've gotten this problem once before... and if my memory serves me correctly, there is likely a problem with the Access driver you are using.

    Make sure you have the latest MDAC drivers installed. You may need to restart IIS to clear this error from repeating.

    Tim
    Tim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •