Configuring the Data Source

sqora00000000.gifConfiguring the Data Source

After installing the Oracle8 ODBC Driver and 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, 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.

After you have installed the Oracle8 ODBC Driver, use the 32-bit Administrator (which is installed when you install the Oracle8 ODBC Driver) to perform the configuration. Follow these steps:

  1. Either double click on the 32-bit Administrator icon or from the start menu, select Programs, then depending on the platform select either Oracle for Windows 95, Oracle for Windows 98, Oracle for Windows 2000, Oracle for Windows NT, or Oracle - OraHome81 and select the 32-bit Administrator. A list of installed drivers is displayed.

  2. Click on the Add button in the Data Sources window and then click on the Oracle8 ODBC Driver in the list of installed drivers.

  3. Click on OK. The Oracle8 ODBC Driver Setup dialog box is displayed. You must enter the Data Source Name and TNS 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.

  4. After you have entered the data, click on OK or press Return.

See Also: For All Users

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy