Connecting to Access mdb on another serv

[Anon]

hi there,

i have a problem connecting to an MS Access mdb file that is on another server.
the first idea was, to setup a odbc system dsn that points to the network path of the file. unfortunately, i get an error message SQL state S1000 in SQLExecDirect

do you have any suggestions or ideas? how to i connect to an odbc system dsn that is not on the same server as the PHP/Webserver?

thanks,
mat

[Anon]

This DOES work; I'm using it right now. However, you have to have 100% permissions on the remote machine, i.e. no security. Also, your computer / username has to have local login rights on the remote machine.

$.02
randal

[Anon]

it won't work with two windows 2000 systems, even if we give all permissions to access the file on the remote win2k server.
under which user do we have to configure IIS and ODBC DSN?

thx,
mat

[Anon]

Summary:
On db machine:
1) create user IUSR_name-of-other-computer-goes-here
2) Using the policy editor, set IUSR_name-of-other-computer to have local logon.
3) Set "full control" privileges on the .mdb file for IUSR_name-of-other-computer

On the IIS machine
1) create a DSN for the db, point it to the file on the db machine.

That will make it work :: my situation was in a windows 2000 advanced server-only environment; I know it works here, my site used to run exclusively off it [only partially now] .. http://rand0m.org.

There are a couple FAQs on the web detailing this, but they are rough to find. I'll see what I can do.