This is an old revision of the document!


SQLines OCI Compatibility Driver - Configuration

SQLines OCI driver has the same file name as the original Oracle OCI library oci.dll, and it has to be located in the application directory, so applications can automatically load SQLines OCI DLL instead of Oracle OCI DLL.

Configuration File - sqlines_oci.ini

sqlines_oci.ini is the configuration file for SQLines OCI that must be located in the same directory as the SQLines OCI DLL oci.dll (the application directory).

Configuration File Syntax

In the configuration file sqlines_oci.ini, you can specify one option and its value per line in the following format:

option_name = value

All options are case-insensitive, and you can specify them in any order.

The configuration file supports 2 types of comments: single-line comments specified by -- or //, and multi-line comments enclosed by /* */

Options

The following options are available in sqlines_oci.ini file:

oracle_oci_path

oracle_oci_path specifies the full path and file name of the original Oracle OCI DLL.

On Windows, this is typically %ORACLE_HOME%\bin\oci.dll. Replace %ORACLE_HOME% with the directory where the Oracle software is installed.

For example, for Oracle Express Edition 11g Release 2, the oracle_oci_path value can be C:\oraclexe\app\oracle\product\11.2.0\server\bin\oci.dll

log_directory

log_directory specifies the directory for SQLines OCI library log files.

By the default, SQLines OCI writes logs to %APPDATA%\SQLines directory.

On Windows XP and 2003, by default, the log files are located at C:\Documents and Settings\%Username%\Application Data\SQLines\

On Windows 7, by default, the logs are located at C:\Users\%Username%\Appdata\Roaming\SQLines\

messagebox_onload

If messagebox_onload is set to yes, a message box is shown when the SQLines OCI driver is loaded.

This is the easiest way to check whether your application started using SQLines OCI instead of Oracle OCI.

Default value is no (no message box is shown).