Configure Oracle 7 ODBC Driver

The Oracle 7 driver is supported in the Windows 95 and Windows NT environments.

System Requirements
The system requirements are:

Configuring Data Sources
Windows 95 and Windows NT can host multiple users; data sources must be configured for each user. To configure an Oracle data source:

  1. Start the ODBC Administrator by double-clicking the ODBC icon in the Windows Control Panel. A list of data sources appears.
  2. If you are configuring a new data source, click Add. A list of installed drivers appears. Select the Oracle 7 driver and click OK.
    If you are configuring an existing data source, select the data source name and click Setup. The setup dialog box appears.

    Specify values as follows:

    Data Source Name A string that identifies this Oracle data source configuration in ODBC.INI. Examples include "Accounting" or "Oracle- Serv1."
    Description An optional long description of a data source name. For example, "My Accounting Database" or "Oracle on Server number 1."
    Server Name The SQL*Net connection string designating the server and database to be accessed. The information required varies depending on the SQL*Net driver you are using. The section "Connecting to a Data Source Using a Connection String" gives the format of the SQL*Net connection string.

    Optionally specify these settings:

    Server List The list of SQL*Net connection strings that will appear in the logon dialog box. Separate the strings with commas. If the SQL*Net connection string contains a comma, enclose it in quotation marks; for example, "Serv,1", "Serv,2", "Serv,3."
    Default User Name The default user name used to connect to your Oracle database. A default user name is required only if security is enabled on your database. Your ODBC application may override this value or you may override this value in the logon dialog box or connection string.
    Lock Time Out A value of 0 or -1 that specifies whether Oracle should wait for a lock to be freed before raising an error when processing a Select...For Update statement. Values can be -1 (wait forever) or 0 (don't wait). The default is -1.
    Array Size The number of bytes the driver uses for fetching multiple rows. Values can be an integer from 0 to 65536; the default is 60000. Larger values increase throughput by reducing the number of times the driver fetches data across the network. Smaller values increase response time, as there is less of a delay waiting for the server to transmit data.
    Catalog Comments Check this box if you want to retrieve the contents of the COMMENTS column for catalog functions. Retrieving the COMMENTS column may reduce the performance of your data catalog operations.
  3. Click Translate to perform a translation of your data from one character set to another. The Select Translator dialog box appears in which you select a translator to perform the translation. Click OK to leave this dialog box and perform the translation. The translators that are listed in this dialog box are determined by the values listed in the ODBC Translators section of your odbcinst.ini file.
  4. Click OK to write these values to ODBC.INI. These values are now the defaults when you connect to the data source. Change the defaults by configuring your data source again. Override the defaults by connecting to the data source using a connection string with alternate values.


Install ODBC Drivers


ODBC Drivers
Oracle 7 Data Types
Sybase System 10 Data Types
Isolation and Locking
ODBC Driver Error Messages