1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Microsoft][ODBC Microsoft Access Driver

Discussion in 'Plesk for Windows - 8.x and Older' started by ErikdeEngerd, Apr 11, 2004.

  1. ErikdeEngerd

    ErikdeEngerd Guest

    0
     
    Hi

    How fix i this

    [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xd00 Thread 0xd90 DBC 0x15de76c Jet'.

    Thanks ERic
     
  2. MattR@

    MattR@ Guest

    0
     
    I ran into this once, I changed to a DNSless connection and it solved the problem, although I'm not sure what caused it yet.
     
  3. ErikdeEngerd

    ErikdeEngerd Guest

    0
     
    Hi

    Thanks for your reply , but can you tel , how you do this , step by step.


    Thanks
     
  4. MattR@

    MattR@ Guest

    0
     
    Hmm, I'm trying to think back, can you post your connection string right now?
     
  5. ErikdeEngerd

    ErikdeEngerd Guest

    0
     
    Hi

    %>

    <%
    Dim ConnectString, conn
    On Error Resume Next

    '** CHANGE THE BELOW LINE

    ConnectString ="Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Inetpub\vhosts\domainname.com\httpdocs\mailerfree\mailerfree.mdb;"


    Set conn = Server.CreateObject("ADODB.Connection")
    conn.open ConnectString
    If err <> "0" Then error() End If
    %>

    But is there another way to connect the database is it also oke , mayby there is an easyer way to do it!!

    Thanks Eric
     
  6. maarten

    maarten Guest

    0
     
    DSN server path

    When you want to know the real path to the database file. Run this script in the directory of the database:

    Just put it in a example.asp (or something like that)
    <%
    Response.Write Server.MapPath(Request.ServerVariables("PATH_INFO"))
    %>
    this line shows the real path to the databasefile.

    View this example on: http://mappath.denit.net

    You can add this path it in the plesk control panel under odbc. Test the connection et voila.

    Do not forget to set write permissions on the database file.
     
Loading...