Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

IIS to MS-Access with link tables to Oracle

Locked

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

Topic

Clarifications

In reply to IIS to MS-Access with link tables to Oracle

Clarifications

Hope this helps you….

In reply to IIS to MS-Access with link tables to Oracle

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.

More from this link..PDF file…

In reply to Hope this helps you….

http://www.google.com/search?hl=en&q=IIS%20to%20MS-Access%20with%20link%20tables%20to%20Oracle

Already have them

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….

[Author]

Replies