Adding, Modifying, and Deleting Oracle Data Sources
Adding, Modifying, and Deleting Oracle Data Sources
Before you can access data with the Oracle8 ODBC Driver, you must add a data source for each of your Oracle databases. The Oracle8 ODBC Driver uses the
information you enter when you add the data source to access the data. You can change
or delete a data source at any time.
To add an Oracle data source:
In the Oracle for Windows NT/95/98/2000 folder, select 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,
or Oracle for Windows NT, and select the 32-bit Administrator.
In the Data Sources dialog box, click on the Add button. The Add Data Source
dialog box is displayed.
In the Installed ODBC Drivers list, select Oracle8ODBC Driver and click on the OK button. The Oracle8 ODBC Setup dialog box is
displayed.
In the Oracle8 ODBC Setup dialog box, set the option values as necessary and click on the OK button. 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.
To modify an Oracle data source
In the Oracle for Windows NT/95/98/2000 folder, select 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, or Oracle for Windows NT, and select the 32-bit Administrator.
In the Data Sources dialog box, select the data source from the Data Sources
list and click on the Configure button. The Oracle8 ODBC Setup dialog box is
displayed.
In the Oracle Windows NT/95/98/2000 folder, select 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, or
Oracle for Windows NT, and select the 32-bit Administrator.
In the Data Sources dialog box, select the data source you want to delete from
the Data Sources list.
Click on the Remove button, and then click on the Yes button to confirm the
deletion.
Bookmark
Adding, Modifying, and Deleting Oracle Data Sources
