ODBC connection to a DB on another computer?

[Jack]

In a PHP script, I'm using a DSN-less ODBC connection to connect to an
MS Access database. Like so:

$DBConn = 'Driver={Micros oft Access Driver (*.mdb)};
DBQ=c:\path\to\ MyDatabase.MDB' ;
$conn = odbc_connect($D BConn,'','');

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={Micros oft Access Driver (*.mdb)};
DBQ=\\ComputerN ame\c\path\to\M yDatabase.MDB';
$conn = odbc_connect($D BConn,'','');

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]

On Feb 8, 9:05*pm, Jack <ironwoodcan... @gmail.comwrote :

In a PHP script, I'm using a DSN-less ODBC connection to connect to an
MS Access database. Like so:

$DBConn = 'Driver={Micros oft Access Driver (*.mdb)};
DBQ=c:\path\to\ MyDatabase.MDB' ;
$conn = odbc_connect($D BConn,'','');

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={Micros oft Access Driver (*.mdb)};
DBQ=\\ComputerN ame\c\path\to\M yDatabase.MDB';
$conn = odbc_connect($D BConn,'','');

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.c om/asprunner/docs/error_unable_to _open_registry_ key_'temporary_ (volatile)_jet_ dsn_for_process _..._.htm

.... or .....

http://support.microsoft.com/kb/295297

Rob.

[Captain Paralytic]

On 11 Feb, 13:06, Rob <ratkin...@tb s-ltd.co.ukwrote:

On Feb 8, 9:05 pm, Jack <ironwoodcan... @gmail.comwrote :

In a PHP script, I'm using a DSN-less ODBC connection to connect to an
MS Access database. Like so:

$DBConn = 'Driver={Micros oft Access Driver (*.mdb)};
DBQ=c:\path\to\ MyDatabase.MDB' ;
$conn = odbc_connect($D BConn,'','');

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={Micros oft Access Driver (*.mdb)};
DBQ=\\ComputerN ame\c\path\to\M yDatabase.MDB';
$conn = odbc_connect($D BConn,'','');

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/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]

On Feb 11, 1:46*pm, Captain Paralytic <paul_laut...@y ahoo.comwrote:

On 11 Feb, 13:06, Rob <ratkin...@tb s-ltd.co.ukwrote:

On Feb 8, 9:05 pm, Jack <ironwoodcan... @gmail.comwrote :

In a PHP script, I'm using a DSN-less ODBC connection to connect to an
MS Access database. Like so:

$DBConn = 'Driver={Micros oft Access Driver (*.mdb)};
DBQ=c:\path\to\ MyDatabase.MDB' ;
$conn = odbc_connect($D BConn,'','');

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={Micros oft Access Driver (*.mdb)};
DBQ=\\ComputerN ame\c\path\to\M yDatabase.MDB';
$conn = odbc_connect($D BConn,'','');

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/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!- 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 :)