ASP Accessing database on another machine 1

[bigfoot]

I have an ASP page that needs to access a MS Access database. When I put the database on the IIS machine, ASP reads it fine, but when I copy the database to another machine, the ASP error reads that I do not have permissions or the database is open by another user. Both of my machines have the same logon and password. It is not open by another user. I have tried passing the username & pwd in the DSN connection string, but it still will not work.
I tried DSN and DSNless (path) connections.
I even tried mapping a drive from 1 server to another.

Can someone please tell me what I am doing wrong?

Access2000, Windows2000 Server, Windows98 desktop reading the asp browser.

Thanks
Gary

 

[xor]

Have you tried creating an ODBC connection to the database (create the ODBC connection on the server where this asp pages are sitting)? Be sure to test the connection when you set it up (one of the options at the end of the ODBC setup), if the ODBC connection works, try connecting your asp pages to the ODBC connection rather than the database itself. I find it works best to set the ODBC connection up as a 'System DSN' for this as I encounter fewer problems this way. The New Zealand Site

http://www.thenewzealandsite.com

 

[rewebb]

Here lies madness! We've had all sorts of fun and games with this (and similar) and it's all to do with security permissions.

If you are using Anonymous access then you need to ensure that the IUSR_machineName user that IIS uses has network permissions and has permission to access the Access database. If you cannot get this to work then set the ASP security to "High" (Isolated process) and go into Component Services (via Control Panel / Admin Tools). Locate "My Computer" in Component Services and expand the COM+ Applications tab. You will see your application listed.

Right-click it, select Properties & Identitiy tab. And you will be able to specify the account that this application will impersonate. Use an account that has permission to use the Acess database.

Best of luck!

Rob W

(If this post has been helpful
then give me a star dammit!)