1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice

Adding a new DSN Connection (.mdb)

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

  1. martha

    martha Guest

    0
     
    Hi all,

    for the life of me, I can't get the db file path correct for this. Do I put in the full path to the database? I've tried different methods, but test connection always fails.

    Hoping someone has an answer to this.

    Thx.
     
  2. sonics

    sonics Regular Pleskian

    26
    23%
    Joined:
    Jan 4, 2004
    Messages:
    168
    Likes Received:
    1
    Location:
    Switzerland
    Hello

    We did it this mornig and had to enter the whole path to the database. in our case was that:

    e:\www\vhosts\yourdomain.ch\httpdocs\test.mdb

    and the test fas sucessfull.
     
  3. martha

    martha Guest

    0
     
    Thanks for the reply sonics,

    I did try that, but here's the error i'm getting:

    unable to connect to datasource with specified settings. server returned: odbcerror hy000: [microsoft][odbc microsoft access driver] not a valid filename.


    But i've double and triple checked to ensure that the file name was correct, even using sample.mdb and testing.mdb, but result is the same.

    any ideas?
     
  4. sonics

    sonics Regular Pleskian

    26
    23%
    Joined:
    Jan 4, 2004
    Messages:
    168
    Likes Received:
    1
    Location:
    Switzerland
    you need to enter the real path to the database and also the name of the db.

    it should work.
     
  5. maarten

    maarten Guest

    0
     
    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...