How To Enable Gaming Mode on Android 12

Back in Februry, folks at XDA had spotted an unreleased Gaming Dashboard in the works for Android 12. But up until now, there were no clear...

Monday

How to install Oracle ODBC driver in Windows 10

Posted by   on





Matthew Adams

by Matthew Adams

Windows & Software Expert




Matthew is a freelancer who has produced a variety of articles on various topics related to technology. His main focus is the Windows OS and all the things surrounding it. He is passionate about… Read more






  • When you install an Oracle ODBC driver in Windows 10, you can connect to an Oracle database with Access and other ODBC-compliant database applications.

  • Users can download and install an ODBC driver for Oracle 19c, which is the current release with a high level of stability.

  • You can establish an Oracle ODBC connection in Windows 10 by setting up an ODBC data source after installing the ODBC driver.

  • You’ll also need to have installed certain Visual C++ packages for the Oracle setup.


Oracle ODBC driver in Windows 10



To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:


  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).

  2. Click Start Scan to find Windows issues that could be causing PC problems.

  3. Click Repair All to fix issues affecting your computer’s security and performance



  • Restoro has been downloaded by 0 readers this month.




Oracle Database is one of the foremost DBMS (Database Management Systems) for Windows. However, Windows 10 doesn’t include any built-in Oracle ODBC connection tool.


So, you’ll need to install an Oracle ODBC driver to connect to an Oracle database with an ODBC-compliant application.


You basically have to do a bit more than simply download and install an ODBC package to connect to an Oracle database with an application.


On top of that, you’ll also need to add new environment variables and set up a DSN for the driver before you can connect with the Oracle database.


How can I install an Oracle ODBC driver in Windows 10?


1. Download and extract the Oracle packages 



  1. First, open the Oracle Instant Client page in your browser.
    The Oracle package download page install oracle odbc driver windows 10

  2. Next, click the Instant Client for Microsoft Windows 32 or 64-bit link (or an alternative one that matches your PC’s platform).

  3. Click the Basic package download link.

  4. Scroll down and click the SDK package hyperlink to download that archive.

  5. In addition, click the download link for the ODBC package.

  6. Open the File Explorer window by clicking the folder taskbar button for it.

  7. Click the C: root drive in File Explorer.

  8. Then right-click a space within the C: drive and select New > Folder.
    The Folder option install oracle odbc driver windows 10

  9. Enter Oracle as the new folder name. Then you should have a new folder with this path: C:\Oracle

  10. Move all three of the downloaded Oracle ZIP archives into the Oracle folder. You can do that by selecting the ZIP files, clicking the Move to button, and selecting Choose location within File Explorer.

  11. Next, extract all three of the ZIP archives into the Oracle folder. To extract a ZIP, select it and click the Extract all button on File Explorer’s Compressed Folder Tools tab.
    The Extract Compressed folders window install oracle odbc driver windows 10

  12. Then you can click the Browse button in the Extract Compressed window to select the Oracle folder. Click the Extract button.

  13. Open the extracted instantclient-basic-windows.x64-19.11.0.0.0dbru folder.

  14. Move the instantclient_19_11 subfolder from there into the Oracle folder.

  15. Then erase the now empty instantclient-basic-windows.x64-19.11.0.0.0dbru folder that previously included the instantclient_19_11 subfolder by right-clicking it and selecting Delete. Thereafter, you’ll have a single instantclient_19_11 folder within the Oracle directory.


The ODBC and basic ZIP archives must be unzipped to exactly the same folder. Select to extract the ODBC ZIP to the path of your unzipped Basic package.


Delete instantclient_19_11 at the end of the path in the Extract Compressed window so that an additional subfolder isn’t included. 


The SDK package is a non-essential optional one. However, it’s recommended you download that package too.


The SDK ZIP archive should also be extracted to the same instantclient_19_11 folder that includes the Basic and ODBC package files. 


2. Add an Oracle Client directory environment variable



  1. Press the Windows and S keys simultaneously to open a search box.

  2. Type the keyword system environment variables with the search text box.

  3. Click Edit the system environment variables to open the window in the screenshot directly below.
    System Properties window install oracle odbc driver windows 10

  4. Press the Environment Variables button.
    Environment Variables window install oracle odbc driver windows 10

  5. Click the New button for system variables.

  6. Next, input OCI_LIB32 within the Variable name box.

  7. Input your Oracle folder path in the Variable value box. If you followed the guidelines above, that folder path would be this: C:\Oracle\instantclient_19_11.
    New System Variable window install oracle odbc driver windows 10

  8. Next, Double-click Path in system variables to open the window in the snapshot directly below.
    Edit environment variable window install oracle odbc driver windows 10

  9. Click the New button, and enter the same folder path you input within the Variable value box.

  10. Press the OK button.



Note icon

To get the list of TNS services when establishing ODBC connections, you’ll also need to set up a TNS_NAMES system environment variable that points to the directory that includes the tnsnames.ora file.



3. Install your ODBC Oracle client package





Run a System Scan to discover potential errors




Restoro Scan

Click Start Scan to find Windows issues.




Restoro Fix

Click Repair All to fix issues with Patented Technologies.




Run a PC Scan with Restoro Repair Tool to find errors causing security problems and slowdowns. After the scan is complete, the repair process will replace damaged files with fresh Windows files and components.





To install the ODBC client, open the instantclient_19_11 folder you extracted the ODBC package to in File Explorer. Then right-click odbc_install.exe and select the Run as administrator option.


Note that there isn’t any kind of GUI installation wizard for that file. So, that’s all you need to do here.


The Run as administrator option install oracle odbc driver windows 10

4. Set up the DSN for Oracle driver



  1. Bring up the search tool within Windows.

  2. Enter ODBC Data Sources in the search box.

  3. Click ODBC Data Sources to open the window in the screenshot directly below.
    ODBC Data Source Administrator window install oracle odbc driver windows 10

  4. Next, click the Add button on the User DSN (or System) tab to open the Create New Data Source window.
    Create New Data Source window install oracle odbc driver windows 10

  5. Select your Oracle ODBC driver, and press the Finish button.

  6. Fill out the required details on the ODBC configuration window.

  7. Click Test Connection to check your Oracle Database Server connection.

  8. Press the OK button to exit.


5. Install missing Visual C++ libraries


You can’t set up data sources for an Oracle driver with the ODBC Data Source Administration if a required Visual C++ package for it is not installed on your PC.


If an error message pops up when your try to set up an Oracle driver data source, you might be missing a required Visual C++ package.


You’ll need to have Visual Studio 17 installed for the current Oracle 19 client. You can download Visual Studio 2017, and older redistributable packages, via the C++ downloads page.


Then click the VC EXE file you downloaded to the install Visual Studio package. So, that’s how you can install the Oracle ODBC driver on Windows 10.


When you’ve installed the current Oracle ODBC driver, you’ll be able to connect to Oracle Database DBMS versions from 11.2 up to 19.1 with the 19c client.


Moreover, if you need to fix Windows 10 ODBC issues, just check out our dedicated article. As for your opinion, the comments area is waiting for you.





idee restoro Still having issues? Fix them with this tool:


  1. Download this PC Repair Tool rated Great on TrustPilot.com (download starts on this page).

  2. Click Start Scan to find Windows issues that could be causing PC problems.

  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).


Restoro has been downloaded by 0 readers this month.







No comments:
Write Comments

Hello Friends, welcome to autobloginc.blogspot.com we Hope You'll like it - COntact US
!!THANK YOU FOR YOUR SUPPORT!!