Hi. I'm using a PHP script to pull data out of an access database which is
located on a remote windows 98SE machine. The file is on
D:\shared\share\test.mdb.
My configuration on Linux (Redhat 9.0)
odbc.ini
This is my odbc.ini
[test]
Description = Microsoft Access Database
Driver = MDBToolsODBC
Database = /home/nvs/test.mdb
Servername = 127.0.0.1
UserName =
Password =
port = 5432
[test2]
Description = Microsoft Access Database
Driver = MDBToolsODBC
Database =D:\shared\share\test.mdb
Servername = (ip of win machine)
UserName =
Password =
port = 5432
The first database works, the PHP script returns the data. However, the second
one produces the following error:
Warning: SQL error: UODB4²ó@¸Îÿ¿›Êñ@ € , 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 same
issue, but no sollution. I am rather confused on how to set the database 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? Any help would be
appreciated.
Greetings,
Niki Van Strydonck
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click
|
