[mdb-dev] Using mdbtools odbc to connect to an mdb on a windows box?

[<nv...@pa...>]

Hi. I'm using a PHP script to pull data out of an access database which i=
s located on a remote windows 98SE machine. The file is on D:\shared\shar=
e\test.mdb. 

My configuration on Linux (Redhat 9.0)
odbc.ini

This is my odbc.ini

[test]
Description =3D Microsoft Access Database
Driver =3D MDBToolsODBC
Database =3D /home/nvs/test.mdb
Servername =3D 127.0.0.1
UserName =3D
Password =3D
port =3D 5432
[test2]
Description =3D Microsoft Access Database
Driver =3D MDBToolsODBC
Database =3DD:\shared\share\test.mdb
Servername =3D (ip of win machine)
UserName =3D
Password =3D
port =3D 5432


The first database works, the PHP script returns the data. However, the s=
econd one produces the following error: 
Warning: SQL error: UODB4=C2=B2=C3=B3@=C2=B8=C3=8E=C3=BF=C2=BF=E2=80=BA=C3=
=8A=C3=B1@ =E2=82=AC , SQL state 00000 in SQLConnect in /var/www/html/mdb=
.php on line 3


Looking for this problem on the net has found me a few people with the sa=
me issue, but no sollution. I am rather confused on how to set the databa=
se option for the second database. Do I use the entire path, like above, =
or do start from the shared directory? Do I need to escape backslashes? A=
ny help would be appreciated.

Greetings,
Niki Van Strydonck