ODBC connection problem

[JeanieW]

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.

 

[IgorG]

What sort of error there? Maybe it will help - http://kb.odin.com/en/2097 ?

 

[girardan]

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

 

[IgorG]

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