On Feb 8, 9:05*pm, Jack <ironwoodcan...@gmail.comwrote:
Quote:
In a PHP script, I'm using a DSN-less ODBC connection to connect to an
MS Access database. Like so:
>
$DBConn = 'Driver={Microsoft Access Driver (*.mdb)};
DBQ=c:\path\to\MyDatabase.MDB';
$conn = odbc_connect($DBConn,'','');
>
This works fine - no problems.
>
Now, I want to connect to an Access database that is on another
computer (on a LAN). Using a similar statement:
>
$DBConn = 'Driver={Microsoft Access Driver (*.mdb)};
DBQ=\\ComputerName\c\path\to\MyDatabase.MDB';
$conn = odbc_connect($DBConn,'','');
>
But this results in an error:
>
SQL error: [Microsoft][ODBC Microsoft Access Driver]General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process
0xe80 Thread 0x8a8 DBC 0xf8e024'...
>
Is it possible to do this? Can anyone tell me how to get past this?
>
Thanks.
Try
http://www.xlinesoft.com/asprunner/docs/error_unable_to_open_registry_key_'temporary_(vola tile)_jet_dsn_for_process_..._.htm
.... or .....
http://support.microsoft.com/kb/295297
Rob.