Question

  • Creator
    Topic
  • #2146535

    IIS to MS-Access with link tables to Oracle

    Locked

    by sze wong ·

    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

All Answers

  • Author
    Replies
    • #2460785

      Clarifications

      by sze wong ·

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

      Clarifications

    • #2460782

      Hope this helps you….

      by Anonymous ·

      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.

Viewing 1 reply thread