PHP / odbc connect error
Posted on 2006-06-01
Do you know if Microsoft's ODBC driver supports using remote datafiles?
We setup two DSNs on our server. One pointed to a datafile directory on the harddrive (C:/Datafile) and another pointed to a remote computer's datafile directory (\\pebbles\C\Datafile which was mapped by the ODBC configuration utility to Z: so it ended up pointing to Z:\Datafile).
When we tried to do a simple odbc_connect() in our php script we get a PHP warning: odbc_connect(): SQL error: [Microsoft][ODBC dBase Driver] '(unknown)' is not a valid path.
When we use the exact same code, but with the DSN that points to our harddrive's datafile, the script works.
Any assistance would be appreciated greatly.