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
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

ODBC connection problem

Discussion in 'Plesk for Windows - 8.x and Older' started by JeanieW, Jan 26, 2010.

  1. JeanieW

    JeanieW Guest

    0
     
    Our customer wants to put their database file in the web space, and setup ODBC connection to connect the microsoft access file.

    Below are information entered in control panel:

    Drive: "Microsoft Access Driver (*.mdb)
    [DBQ] DB File Path: "C:\Inetpub\vhosts\domainname.com\httpdocs\foldername\databasename.mdb"

    Below are customer's script

    Set strConn = Server.CreateObject("ADODB.Connection")
    strConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("
    C:\Inetpub\vhosts\domainname.com\httpdocs\foldername\databasename.mdb"))


    They found the path is totally not work. Why ?
    Please help. Thanks.
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,543
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
  3. girardan

    girardan Guest

    0
     
    hi jeanie

    do you have solve your pbe, i've same pbe in plesk 10 on win2008 64bits; sql 2008 connection works well, but when i try to create odbc dsn, when i enter database path, i've this error :

    Erreur: Impossible de se connecter à la source des données à l'aide des paramètres définis. Le serveur a renvoyé l'erreur suivante :
    ODBCError HY000: [Microsoft][Pilote ODBC Microsoft Access] Nom de fichier incorrect.

    thanks in advance for your answer
    Antoine
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,543
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    To fix this problem please change in file:
    "%plesk_bin%\odbc.conf.xml"
    value of property 'curly' for parameter 'DBQ' from 'true to 'false' for driver
    'Microsoft Access Driver (*.mdb)'.

    ====================================
    ...
    <cstring driver="Microsoft Access Driver (*.mdb)">
    <param>
    <key>DRIVER</key>
    <key_human></key_human>
    <required>true</required>
    <curly>true</curly>
    <type>string</type>
    <value>Microsoft Access Driver (*.mdb)</value>
    </param>
    <param>
    <key>DBQ</key>
    <key_human>DB File Path</key_human>
    <required>true</required>
    <curly>false</curly> <<<<<<<<<<<<<<<---------------
    <type>string</type>
    <value></value>
    </param>
    ...
    ====================================
     
Loading...