Before you create the DSN entry, collaborate with your database administrator and get all information you will be required to provide during the configuration.
To configure TSS Oracle Driver
-
From the Windows Start menu, click Settings > Control Panel > Administrative Tools > Data Sources (ODBC). The ODBC Data Source Administrator opens.
-
Click the System DSN tab.
-
Click Add to open the Create New Data Source window.
-
Scroll down and select the TSS 17 Oracle Driver option.
-
Click Finish. The ODBC Oracle Wire Protocol configuration page opens.
-
Enter information in the following fields: Data Source Name, Description, Host, Port Number, and Service Name. In this example, the name of the Data Source you are creating is ORACLE_1. The name of system hosting the Oracle database is orasys-1, its port number is 1500 and the Service Name is oracle.yourcompany.com.
Note: The information you provide in the Standard Connection section is defined in the tnsnames.ora file. You can get this information from the Oracle database administrator. -
Click Apply to save your changes.
-
Click OK to close the window.