ODBC DSN problems for Access DB

Hi all,

I've been searching and searching and haven't found a solution to this problem yet.

I have a windows 2k3 server with and access database resident on it. I want to access this database from another computer. Initially this computer will be on the same sub-net, but eventually they will be on different sub-nets.

I have setup a System DSN for the mdb file, using the access odbc driver, and called it 'CallMaster'

Now, I've tried using php's odbc connect to connect to the DSN, I've tried PEARs odbc, I've tried using Access on a second computer, and I've tried ODBC socket server. All of them give me the error : ADO Error. Description: Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
in some form or another.

I think this narrows the problem down to the odbc implimentation on the server. Can anyone suggest my course from here?

Statik

Assuming you have proper permissions, you should be able to specify a UNC path in your ODBC DSN.

Make sure you can use the mdb file if it's on the same computer you're running your program on first, then move the db file to the 2nd computer.

You may have additional problems if the computers are not in the same subnet.

totally different subnet actually. Local DB server, remotely hosted website. Currently using ODBC Socket Server to parse XML responses from the DB. Seems ok so far.

Statik