IIS to MS-Access with link tables to Oracle

By Sze Wong ·

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_<machine name> account.

Let me know if you have any insight.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Hope this helps you....

Two additional software packages must be installed on the PC in addition to Office 2000.
The software required includes SQL*Net (an Oracle product) and an ODBC driver
(supplied by many software vendors). These additional software packages are already
installed on Round 12 corporate PC?s as part of the software image. To get the software
for earlier round PC?s, you must have your System Administrator schedule your PC for a
software distribution from Missoula OSE (contact your System Admin). ODBC drivers
for Oracle are included with the Office 2000 installation as well as from the Oracle
package distributed by Missoula OSE.

Please post back if you have any more problems or questions.

Collapse -

Already have them

by Sze Wong In reply to Hope this helps you....

Hi Thanks for your reply. However I think I already have SQL*NET and the correct ODBC dirver as I installed the Oracle client. Again, I can open the mdb files and click on the link tables. The link tables are fine from within the mdb file. Still, IIS is giving me an ODBC connection error....

Related Discussions

Related Forums