IIS to MS-Access with link tables to Oracle

Hi,

I am having a issues setting up an ASP application. Hope someone can help me out.

Here is the issue:
ASP is pointing to an MS-Access database via ODBC. All is fine but when the ASP tries to access the link table to Oracle, I receive an ODBC Connection error.

I have verified that the local ODBC DSN to Oracle is correct. In fact, I can open the mdb file on the web server machine and click on the link tables with no problems.

The only thing I can think of is something with the IUSR_ account.

Let me know if you have any insight.

Sze