Post reply

ACESS connection with ASP error - temp regisrty key

  • June 27, 2006 at 4:36 am

    #67600

    Hi ,

    When opening the website on local machine it works fine. It pulls data from access database.

    But when I open the DB and refresh the page I get an error.

    Microsoft OLE DB provider for ODBC Drivers (0x800004005)

    [Microsoft][ODBC Microsoft Access Driver] General error

    Unable to open registry key 'Temporary (Volatile) Jet DSN for

    process 0xd48 Thread 0xf08 DBC 0x1f99054 jet'.

    /Connection.inc, Line 13

     

    Can anyone help . Please

    Regards

    Ritesh

  • June 28, 2006 at 2:25 am

    #646300

    Could you post the connection.inc??

    I am very interrested to see line 13.

    Greets,

    Erik

  • June 28, 2006 at 11:27 am

    #646429

    This is a common security issue with ASP and Jet. It and its solution is documented in two articles on Microsoft's support site:

    http://support.microsoft.com/kb/295297/en-us

    and

    http://support.microsoft.com/kb/315456/en-us

    Basically, the NT account used by IIS (usually IUSR_machinename) doesn't have permission to read an ODBC registry key.

    Hope this helps.

  • June 29, 2006 at 1:30 am

    #646561

    I was using this on the laptop. But when copied onto my local machine (desktop) it worked fine.

    The desktop uses office 2000 and my laptop(where it doesn't work) uses office 2003.

    Could it be due to different versions of office or the laptop settings.

    Below is the conncection string

    <%

    'Create an ADO connection odject

    Set adoCon = Server.CreateObject("ADODB.Connection")

    adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; pwd=; DBQ=" & Server.MapPath("Person.mdb") %>

     

    Regards

    Ritesh

  • June 30, 2006 at 1:09 am

    #646889

    Usually I get this message when I don't have write permission on the folder, in your case the root. I think that you have to move your database and change the odbc connection, try public for instance of check with your internet provider.

    Claudia

  • June 30, 2006 at 1:27 am

    #646897

    what do you mean by try public?

    I'm wondering its something to with the office 2003

     

  • June 30, 2006 at 10:30 am

    #647030

    It means that usually providers creates a folder named PUBLIC, this folder usually has write permissions.

    Do you see a folder named PUBLIC in your website?

    Or, do you host your website? If so, check write permissions.

     

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply