Re: Read data from Access MDB file?

On Sat, 5 Apr 2008 02:17:51 +0200, "Richard" <root@localhost> wrote:


"Martin" <ironwoodcanyon@xxxxxxxxx> wrote in message
news:gn8dv3t74hss7473kt1kf6cloaqkkhjbfq@xxxxxxxxxx
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.


Hi, Richard - Thanks for the response.

I had not come across the specific document you referenced but I did
find many similar ones. Also, your links are specifically saying
they're for ASP users. I don't know if such resolutions are applicable
to ODBC situations. In my Googling, I've tended to skip over
ASP-oriented stuff.

Basically, what I been trying to do, is establish permissions and
accounts on both computers. And have been totally un-successful.

The 2nd link you gave actually doesn't give any resolution to the
problem that I can see; but it does reference your 1st link. So, I
have printed that out (article id 253580) and am trying to interpret
what it says. But, as I read it, it's telling me to do what I've
already been trying to do.

The article (253580) starts off in a typically confusing manner
talking about "IIS Anonymous Authentication" and concludes the
paragraph by stating that it is "... for Domains under Microsoft
Windows NT 4.0." Well, I'm not dealing with Windows NT 4 - both
computers are Windows XP Pro. So, does this explanation apply to XP? I
can't tell from the way it's written.

I think that I have the "permissions" issues resolved. I have the
"temp" folder on both machines set such that "Everybody" has full
control. I have the folder where the MDB file is on the remote machine
configured similarly.

Where I think the problem is, is with the user account on the remote
machine.

One of the main things that I tried to do over the last several days
was to set up a "User" on the remote machine that ODBC could use when
it tries to connect to the MDB file. One of the things I read said to
set-up a IUSR_MachineName account on the remote machine with all the
needed rights to access the MDB file (where IUSR_MachineName is the
same as the one on the IIS server). I did this (I think) and was
totally unsuccessful in getting anything to work any differently.

Now, it is quite probable that I have not done this correctly. But, I
have been unable to find any step-by-step instructions on how to do
this. Is there any possibility that you (or someone) could provide
some specific instructions (that apply in a Windows XP Pro / IIS /
ODBC environment)?

Again, thanks for the response and for having the patience to continue
trying to help me on this issue. It's greatly appreciated.


.

Relevant Pages

  • Re: Read data from Access MDB file?
    ... was having trying to do this via ODBC. ... I don't have the option of switching to a different database ... My mdb file is on a remote share, and I use an UNC path. ... That means it needs a valid local user account on the remote ...
    (comp.lang.php)
  • Re: Read data from Access MDB file?
    ... was having trying to do this via ODBC. ... I don't have the option of switching to a different database ... My mdb file is on a remote share, and I use an UNC path. ... That means it needs a valid local user account on the remote computer. ...
    (comp.lang.php)
  • Re: ODBC connection to mdb for MacIntosh
    ... As long as the computer has ODBC drivers for an Access database, it does NOT have to have Access installed. ... Office 98 and 2001 it was possible to control several different types of databases directly on a single Mac without having the application on the computer. ... No, you can not put the mdb file on a mac and connect to MS Access via ODBC because MS Access only runs in windows, not on a Mac. ... If you search Google on this topic about 2 years ago there was a complete thread in the Excel for Mac newsgroup about ODBC drivers. ...
    (microsoft.public.mac.otherproducts)
  • Re: DBI and DBD::ODBC and MS Access
    ... <ignoring questions I don't know the answers to> ... http or ftp) and apparently you can access a remote mdb file in this ... The server software doesn't matter for ODBC, ... the Access driver is freely available and distributable. ...
    (comp.lang.perl.modules)
  • Re: Converting from ADP to MDB/ODBC linked tables
    ... abandon Access when it's still perfectly usable. ... I don't like what I read about the limits of ODBC queries. ... Import Form1 into the newly created mdb file from my existing adp ... Bind the Form1 in the new mdb file to the linked View1 ...
    (microsoft.public.access.adp.sqlserver)
Loading