If you need to work with Oracle databases, you need to download and install the Oracle Instant Client from this page:
https://www.oracle.com/database/technologies/instant-client/downloads.html
You need to choose a 32 or 64-bit client version depending on ASPRunnerPro version installed on your computer.
If you are using MS Internet Information Services and the ASPRunnerPro wizard has successfully connected to the database, but when you run the generated app, it fails to connect to Oracle, the possible reason might be that an IIS user doesn't have access to the tnsnames.ora file.
The suggestion is to use the server:port/instance format when connecting to Oracle. Here is a sample tnsnames.ora file:
AADEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TestOracle.server.gov)(PORT = 1521))
)
(CONNECT_DATA =
(SID = AAINST)
(SERVER = DEDICATED)
)
)
Instead of using AADEV in ASPRunnerPro, use TestOracle.server.gov:1521/AAINST
See also:
