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.