Configuring Oracle ODBC DSN

Before you configure the data source, you must configure Net8 database services, so there is an entry for each Service Name.
To do this start the Oracle Net8 Assistant:

Using the Oracle Net8 Assistant, you can create, modify, or delete a Service Name or its associated network protocol information, and view configuration information.
For example, to create a Service Name:

Click on the Oracle Net8 Assistant help button for more information.
To update configuration information for an existing service name: Once you have created or updated the configuration information, Net8 is configured and you are ready to configure each data source.

After Configuring Net8 database services , and before using the Oracle8 ODBC Driver, you must configure the data source.
Before an application can communicate with the data source, you must provide configuration information. The configuration information informs the Oracle8 ODBC Driver as to which information you want to access.
The data source consists of the data that you want to access, and its associated operating system, database management system, and network platform used to access the database management system. The data source for requests submitted by the Oracle8 ODBC Driver is an Oracle database and supports transports available under Net8.
Use the ODBC Administrator to perform the configuration.

Select the Oracle8 ODBC Driver in the list of installed drivers and click on OK. The Oracle8 ODBC Driver Setup dialog box is displayed.

You must enter the Data Source Name and Service Name. You can provide the other information requested in the dialog box, or you can leave the fields blank and provide the information when you run the application.

The Oracle8 ODBC Setup dialog box has the following options:


Main Setup Options


Database Options
Note: The Oracle database from which your application is fetching rows must be release 8.0.3 or higher.

WorkAround Options

Note: This feature could exhaust a PC of memory if the data in the long column is too big. This feature degrades performance because the data for all long columns must be copied twice, once to internal buffers and once to the applications buffer.

Application Options Enable

Translation Options

  • Translation Option - a numeric value that is passed to the translation library when it is called by the Oracle8 ODBC Driver.
  • Translation Library - the name of a translation library that is to be called by the Oracle8 ODBC Driver.