Please enable JavaScript to view this site.

Navigation: Advanced topics

Working with Oracle databases

Scroll Prev Next More

 

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 ASPRunner.NET version installed on your computer.

 

If you are using MS Internet Information Services and the ASPRunner.NET 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 ASPRunner.NET, use TestOracle.server.gov:1521/AAINST

See also:

Connecting to the database

Quick start guide