On my first attempt, I cannot get the list of the TNS Service when creating a new ODBC Connection. Click Test Connection to validate the connection to the Oracle Database Server. Give the new Data Source Name, select TNS Service Name and User ID. Next, enter the Oracle ODBC Driver Configuration. Select “Oracle in instantclient_12_2” from the list. If you are using 64 bit version, choose the ODBC Data Sources (64bit).Ĭlick Add to add a new DSN. To create a new Oracle ODBC Data Source, open Control Panel > Administrative Tools > ODBC Data Sources (32bit). Create a new ODBC Data Source on Windows 10 Please note that there is no GUI installation wizard when you open this file. Now open the folder instantclient_12_2, in your Oracle Client folder created on the Step 1 and double click the file odbc_install. Double click the path and create a new entry as follow Step 3. Next step is to add the Oracle Client directory to system path. Variable Value: C:\Oracle\Product\client\instantclient_12_2Ĭhange C:\Oracle\Product\client\instantclient_12_2 with your actual Oracle Client folder.On the System Variables, click New and then enter the following details: Right-click My Computer > Advanced System Settings > Environment Variables Now we need to add our Oracle Client directory to the Windows PATH environment.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |