Read data from Access MDB file?

[Martin]

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.

[Richard]

"Martin" <ir************@gmail.comwrote in message
news:gn********************************@4ax.com...

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.

[Richard]

"Richard" <root@localhostwrote in message
news:47**********************@news.euronet.nl...

>
"Martin" <ir************@gmail.comwrote in message
news:gn********************************@4ax.com...

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

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

R.