5.1.5.Oracle 8, 9, and 10
SQL*NET tab
Figure5.25.SQL*NET tab
Enter details here for the SQL*NET.
-
Connection String. This needs to be a valid SQL*Net connect string. Typically this will only need to be the TNS Name as defined using the Oracle Easy Net configuration utility.
-
SQL*net Interface. This lets you select the SQL*Net DLL to be used. AutoScan is the default and best option. If this does not work then try and pick the option that seems to best suite your version of Oracle. If you are using Oracle 8i then use 'oci.dll'.
-
XA Info. In the case of an OpenLink driver, this parameter is an ODBC Datasource Name (DSN): see the XA documentation for more about this.
Oracle tab
Figure5.26.Oracle tab
contains the options:
-
Custom Catalog Views
You must run the ODBCCATx.SQL script against your database as user internal before this option can be checked! Enabling this gives best functionality and support especially for ODBC catalog calls.
These scripts exist for each version of Oracle supported, the files "odbccat6.sql", "odbccat7.sql", and "odbccat8.sql" representing Oracle versions 6 up to version 8 respectively. These scripts are to be applied to your Oracle instance to enable efficient and extended functionality between OpenLink and Oracle when handling ODBC, JDBC, UDBC, and OLE-DB catalog calls such as SQLForeignKeys() and SQLPrimaryKeys() functions. These functions have significant impact on the performance of your OpenLink clients.
To run these scripts you need to start the Oracle server manager (svrmgr or sqldba if you do this from the command line). Connect as internal and run the script by locating the relevant script file as you would any other Oracle SQL script file.
-
Count Stored Procedure Parameters in SQLProcedures. Enable 'strict' parameter use.
Transparent Application Failover (TAF) tab
Figure5.27.Oracle tab
When OpenLink's TAF support is enabled, in the event that a failover attempt fails, the Lite driver or Multi-Tier agent will instruct Oracle to retry. By default, the maximum number of failover attempts is 10 and the interval between retry attempts is 10 seconds. The default values can be overridden.
See the Oracle RAC/TAF documentation for more.
