buykillo.blogg.se - Tns service name oracle odbc driver configuration

#TNS SERVICE NAME ORACLE ODBC DRIVER CONFIGURATION HOW TO#
#TNS SERVICE NAME ORACLE ODBC DRIVER CONFIGURATION INSTALL#

I have trouble with install ODBC driver /client on Windows 10 64 bit machine.

#TNS SERVICE NAME ORACLE ODBC DRIVER CONFIGURATION HOW TO#

Thanks for reading this how to install Oracle ODBC driver on Windows 10. Now you should be able to pick or select the TNS service. Open the Environment Variable again and add a new entry with the following value:ĭon’t forget to change the variable value with your Oracle Client Directory. (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.51)(PORT = 1521))Īfter that, we need to tell the system to use this tnsnames.ora config file. (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) This is the content of my tnsnames.ora which is works well LISTENER_ORCL = Save the file in the Oracle Client directory ( C:\Oracle\Product\client\instantclient_12_2). Open Notepad and then copy and paste these lines and then save it as tnsname.ora. To solve this, we need to copy or create the tnsnames.ora in the Oracle Client Directory. 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.