Connecting Tech Pros Worldwide Forums | Help | Site Map

ODBC connection to a DB on another computer?

Jack
Guest
 
Posts: n/a
#1: Feb 8 '08
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.

Rob
Guest
 
Posts: n/a
#2: Feb 11 '08

re: ODBC connection to a DB on another computer?


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.
Captain Paralytic
Guest
 
Posts: n/a
#3: Feb 11 '08

re: ODBC connection to a DB on another computer?


On 11 Feb, 13:06, Rob <ratkin...@tbs-ltd.co.ukwrote:
Quote:
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:
>
Quote:
$DBConn = 'Driver={Microsoft Access Driver (*.mdb)};
DBQ=c:\path\to\MyDatabase.MDB';
$conn = odbc_connect($DBConn,'','');
>
Quote:
This works fine - no problems.
>
Quote:
Now, I want to connect to an Access database that is on another
computer (on a LAN). Using a similar statement:
>
Quote:
$DBConn = 'Driver={Microsoft Access Driver (*.mdb)};
DBQ=\\ComputerName\c\path\to\MyDatabase.MDB';
$conn = odbc_connect($DBConn,'','');
>
Quote:
But this results in an error:
>
Quote:
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'...
>
Quote:
Is it possible to do this? Can anyone tell me how to get past this?
>
Quote:
Thanks.
>
Try
>
http://www.xlinesoft.com/asprunner/d..._open_registry...
>
.... or .....
>
http://support.microsoft.com/kb/295297
>
Rob.
Let me guess, you put
Unable to open registry key
into google and pressed "I'm feeling lucky"

I guessed Google must have been having problems when the OP tried this
before posting here!
Rob
Guest
 
Posts: n/a
#4: Feb 11 '08

re: ODBC connection to a DB on another computer?


On Feb 11, 1:46*pm, Captain Paralytic <paul_laut...@yahoo.comwrote:
Quote:
On 11 Feb, 13:06, Rob <ratkin...@tbs-ltd.co.ukwrote:
>
>
>
>
>
Quote:
On Feb 8, 9:05 pm, Jack <ironwoodcan...@gmail.comwrote:
>
Quote:
Quote:
In a PHP script, I'm using a DSN-less ODBC connection to connect to an
MS Access database. Like so:
>
Quote:
Quote:
$DBConn = 'Driver={Microsoft Access Driver (*.mdb)};
DBQ=c:\path\to\MyDatabase.MDB';
$conn = odbc_connect($DBConn,'','');
>
Quote:
Quote:
This works fine - no problems.
>
Quote:
Quote:
Now, I want to connect to an Access database that is on another
computer (on a LAN). Using a similar statement:
>
Quote:
Quote:
$DBConn = 'Driver={Microsoft Access Driver (*.mdb)};
DBQ=\\ComputerName\c\path\to\MyDatabase.MDB';
$conn = odbc_connect($DBConn,'','');
>
Quote:
Quote:
But this results in an error:
>
Quote:
Quote:
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'...
>
Quote:
Quote:
Is it possible to do this? Can anyone tell me how to get past this?
>
Quote:
Quote:
Thanks.
>
Quote:
Try
>>
Quote:
.... or .....
>>
Quote:
Rob.
>
Let me guess, you put
Unable to open registry key
into google and pressed "I'm feeling lucky"
>
I guessed Google must have been having problems when the OP tried this
before posting here!- Hide quoted text -
>
- Show quoted text -
Not far wrong - I did make sure the sites actually seemed appropriate.

Surely there must be a forums equivilent for RTFM - what about STFW :)
Closed Thread