Read data from Access MDB file?

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

    Read data from Access MDB file?

    From a PHP script, is there any way to retrieve data from an MS Access
    database that's located on another computer (on a LAN) other than by
    using ODBC?

    I posted a question here a couple of weeks ago about the problems I
    was having trying to do this via ODBC. I stated then that I was giving
    up trying to get it to work but I didn't. I foolishly have spent quite
    a few more hours in a futile attempt to get this to work. Now I'm to a
    point where I don't know anything further to try.

    No, I don't have the option of switching to a different database
    format. The data I need to read is in MS Access MDB files and that's
    not going to change.

    I don't have a problem reading an MDB file when it's on the same
    computer that my PHP script is running on but the whole idea of what
    I'm trying to do is to read from a file that's located on a different
    computer.

    Are there any alternatives?

    Thanks.
    Tags: None
    • Richard
      #2
      Re: Read data from Access MDB file?


      "Martin" <ironwoodcanyon @gmail.comwrote in message
      news:gn8dv3t74h ss7473kt1kf6clo aqkkhjbfq@4ax.c om...
      From a PHP script, is there any way to retrieve data from an MS
      Access
      database that's located on another computer (on a LAN) other than by
      using ODBC?
      >
      I posted a question here a couple of weeks ago about the problems I
      was having trying to do this via ODBC. I stated then that I was
      giving
      up trying to get it to work but I didn't. I foolishly have spent
      quite
      a few more hours in a futile attempt to get this to work. Now I'm to
      a
      point where I don't know anything further to try.
      >
      No, I don't have the option of switching to a different database
      format. The data I need to read is in MS Access MDB files and that's
      not going to change.
      >
      I don't have a problem reading an MDB file when it's on the same
      computer that my PHP script is running on but the whole idea of what
      I'm trying to do is to read from a file that's located on a
      different
      computer.
      >
      Are there any alternatives?
      >
      Thanks.
      Hello again,

      I just got back to checking how my setup was.... and after some
      fiddling I got it to work again.
      My mdb file is on a remote share, and I use an UNC path.

      The trick is this:
      Your webserver / PHP combo need access to the file.
      That means it needs a valid local user account on the remote computer.

      Check what the user account of your webserver is, and create that
      account on the remote computer.
      Or: change the user the webserver is running under.
      Whatever is easiest.

      I found a nice doc about it here, it wasnt hard to find though....
      surprised me you missed it.

      http://support.microsoft.com/kb/253580/EN-US/


      Richard.


        Comment

        • Richard
          #3
          Re: Read data from Access MDB file?


          "Richard" <root@localhost wrote in message
          news:47f6c534$0 $3038$dbd43001@ news.euronet.nl ...
          >
          "Martin" <ironwoodcanyon @gmail.comwrote in message
          news:gn8dv3t74h ss7473kt1kf6clo aqkkhjbfq@4ax.c om...
          >From a PHP script, is there any way to retrieve data from an MS
          >Access
          >database that's located on another computer (on a LAN) other than
          >by
          >using ODBC?
          >>
          >I posted a question here a couple of weeks ago about the problems I
          >was having trying to do this via ODBC. I stated then that I was
          >giving
          >up trying to get it to work but I didn't. I foolishly have spent
          >quite
          >a few more hours in a futile attempt to get this to work. Now I'm
          >to a
          >point where I don't know anything further to try.
          >>
          >No, I don't have the option of switching to a different database
          >format. The data I need to read is in MS Access MDB files and
          >that's
          >not going to change.
          >>
          >I don't have a problem reading an MDB file when it's on the same
          >computer that my PHP script is running on but the whole idea of
          >what
          >I'm trying to do is to read from a file that's located on a
          >different
          >computer.
          >>
          >Are there any alternatives?
          >>
          >Thanks.
          >
          Hello again,
          >
          I just got back to checking how my setup was.... and after some
          fiddling I got it to work again.
          My mdb file is on a remote share, and I use an UNC path.
          >
          The trick is this:
          Your webserver / PHP combo need access to the file.
          That means it needs a valid local user account on the remote
          computer.
          >
          Check what the user account of your webserver is, and create that
          account on the remote computer.
          Or: change the user the webserver is running under.
          Whatever is easiest.
          >
          I found a nice doc about it here, it wasnt hard to find though....
          surprised me you missed it.
          >
          http://support.microsoft.com/kb/253580/EN-US/

          >
          Richard.
          >
          >
          Oops....
          the link should have been:

          Error - Office.com - Microsoft Support
          http://support.microsoft.com/kb/166029/


          R.


            Comment

            Previous template Next
            Working...