Oracle

Installing the connector

There are three different providers to choose from when connecting to an Oracle database from AutoTag or the .NET engine: ODP.NET, OleDB, or ODBC.  We strongly suggest using the ODP.NET provider since it provides more functionality.

There are two separate installers, depending on where you are connecting to Oracle from (these are the newest installers as of 10/19/2010):

• AutoTag (2000 to 2007; 2010 x86) or .NET engine on a 32-bit OS:
  • Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit)
  • win32_11gR2_client.zip (684,581,290 bytes)
  • Download link on Oracle.com
• AutoTag (2010 x64) or .NET engine on a 64-bit OS:
  • Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64)
  • win64_11gR2_client.zip (615,698,264 bytes) (cksum - 2947608743)
  • Download link on Oracle.com

If you have problems with either of the above links, a copy of the installers can also be found here

• ​win32_11gR2_client.zip (652 MB)
• win64_11gR1_client.zip (457 MB)​

Installtion for 32-Bit OS:

1. Unzip the file and double-click on setup.exe to begin the install.
2. You will be greeted by the Welcome screen.  Click the Next button.
   
3. Choose where you want the installer files to go.  You can leave it as the default in most cases.
   
4. Choose 'Custom' for the type of install.
   
5. Set the install location.  You can leave it as the default in most cases.
   
6. The installer checks for pre-requisites.  You may get two errors here if you are running a newer operating system, such as Windows 7.  If so, manually place a checkmark in the first two rows to continue the install.  This will still install correctly.
   
7. You will now be prompted for which components to install.  Check the "Oracle Windows Interfaces" box and make sure the ODBC, OLE DB, and .NET data providers are checked.
   
8. Select a service port.  You can leave it as the default in most cases.
   
9. Review the summary.  Click Install to begin the installation.
   
10. When it as finished installing, you will be met with an End screen.
    

Connecting to your Oracle database

Installing the connector (JDBC)

You can find the links for the Oracle thin client JAR at: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.

The Java 1.5 jar is located at http://download.oracle.com/otn/utilities_drivers/jdbc/11202/ojdbc5.jar.

You will then want to add the JAR to your classpath.

Connecting to your Oracle database (JDBC)

To use an Oracle datasource in RunReport, you will need the following in the command:

    -oracle "hr/hr@oracle.windward.net:1521"

where whatever is in the quotes is your connection string to the Oracle database.  (Note: if your datasource has a name you set in AutoTag, you will want to replace '-oracle' with '-oracle:myDataSourceName').