(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.
![install mysql driver windows install mysql driver windows](https://mydrivers.online/wp-content/uploads/2022/01/MySQL-Driver.png)
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.
#INSTALL MYSQL DRIVER WINDOWS 64 BIT#
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.
![install mysql driver windows install mysql driver windows](http://doc.docs.sk/mysql-refman-5.5/images/myodbc-win-install-step3.png)
On the System Variables, click New and then enter the following details: Right-click My Computer > Advanced System Settings > Environment Variables
![install mysql driver windows install mysql driver windows](http://support.codecharge.com/files/kb/mysql/myodbc.gif)
Now we need to add our Oracle Client directory to the Windows PATH environment.