How to install an oracle odbc driver

Next step is to add the Oracle Client directory to system path. Double click the path and create a new entry as follow. Click Add to add a new DSN. Click Finish. To solve this, we need to copy or create the tnsnames. Open Notepad and then copy and paste these lines and then save it as tnsname. After that, we need to tell the system to use this tnsnames.

Open the Environment Variable again and add a new entry with the following value:. Now you should be able to pick or select the TNS service. EXE, Thread: 1 Windows 8 I tryedl everything, and no solution. DLL and not release it, or I do not know something stay blocked and cannot connect again.

Interesting is that test connection from ODBC driver assistent still work,only my app cannot connect more than once, sometimes after some delay I connect but again still blocked. Oracle seems to keep its Windows audience in mind with their programs, as they always tend to run smoothly and have few issues in the long run. As long as you follow along with this guide, you should have no problem getting things all set up. You can do that by going to File Explorer and clicking on your C: drive in the left column.

Then, right-click an open space and navigate to New and Folder , and click. Simply name the folder Oracle and hit enter. Now, move all of the Oracle ZIP files that you downloaded into the Oracle folder, and extract them there. Open the instantclient-basic-windows folder that was extracted.

It will have a Windows bit type and a version number following it. Inside should be a subfolder. Move that subfolder into the Oracle folder, and delete the now-empty folder that it was inside. Now, click your Start button to open the Windows search box. Type System Environment Variables and press enter.

You should be brought to a control panel menu that says System Properties. Click the Environment Variables… button at the bottom, and then click New. Next, double-click Path to open the environment variable table. Click New and enter the same folder path again into the Variable Value box. Then click OK. Now you can install the ODBC client. Click Run As Administrator.

Was this page helpful? Thank you! Start a conversation. Copy link. Software deals Friday round-up. I agree with the Privacy Policy regarding my personal data. More on this Topic December 18, How to reinstall the audio driver in Windows 11 Learn how to easily reinstall the audio driver in Windows 11 from either the Device Manager or the Control Panel, based on your convenience.

Read More. December 2, You may try to update your drivers or run the BSoD Troubleshooter.