Access 2000 Database on different server

[cruford]

I don't know very much at all about IIS. We are running Win 2k Server and IIS 5 on a box. I wrote an ASP page that connects to a database. This works fine if the database is somewhere in

http://wwwroot

on the web server, but I need the database to reside on a completely different server where all are databases are maintained. Any suggestions?

 

[webgs]

Try using a "File" DSN for DB's located off of the web server. Go to the ODBC Data Source Administrator. Click on the "File DSN" tab. Click "Add" and select "Microsoft Access Driver (*.mdb) and click "Next". Click "Browse", find the DB server (preferably through a mapped drive on the web server) find the DB you want to connect to. You will need to use the "filedsn" method in your connection string.

 

[ITProfessional]

One thing is very important. If your database is a different server then from your webserver, then you have to use a domain user account as an annonymous user. As by default IIS use IUER account, which a local accout on the webserver. This account has no NTFS permission on database server. So you have to create a domain account, and use it as Anonymous user on your web server and also it should have access to the database home.
Also you shuold have latest ODBC driver installed on your webserver which is connecting to the database server.