ODBC connection to a DB on another computer?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jack
    #1

    ODBC connection to a DB on another computer?

    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.
    Tags: None
    • Rob
      #2
      Re: ODBC connection to a DB on another computer?

      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.

        Comment

        • Captain Paralytic
          #3
          Re: ODBC connection to a DB on another computer?

          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!

            Comment

            • Rob
              #4
              Re: ODBC connection to a DB on another computer?

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

                Comment

                Previous template Next
                Working...