ODBC Error

[InsertCoin]

Having an issue with an ODBC. The customer was transitioned to a new Plesk 10 model and then the website stopped working. Checking the ODBC from within Plesk it firstly had a green tick next to it, then testing the connection it gave the error:

Error: Unable to connect to the data source using the defined settings. Server has returned the following error:
ODBCError HY000: [Microsoft][ODBC Microsoft Access Driver] Not a valid file name.

Looking directly on the server the ODBC is there and doesn't give any errors.

It seems in the transition to a Plesk 10 model it altered the permissions for the directories, I changed the permissions for the private directory and the website started to work, but the ODBC from within Plesk is still giving the above error.

Any ideas?

 

[IgorG]

Look at this thread - http://forum.parallels.com/showthread.php?t=109451

 

[InsertCoin]

Thanks for the very fast reply, that fix helped.

To fix this problem please change in the 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>
...
====================================