Oracle odbc driver 32 bit install windows 10

Hello everyone, welcome to my blog. In this article, I am going to show you how to install Oracle ODBC Driver on Windows 10. I have a working Oracle Database 12c on another computer on my home network. I am trying to connect to my Oracle database from Microsoft Access using ODBC connection. By default, Windows 10 does not shipped with Oracle ODBC connection utility. In other word, I was unable to connect to my Oracle database from MS Access.

Installing Oracle ODBC Driver on Windows 10 is a bit tricky. It’s not as simple as installing PostgreSQL ODBC driver or MySQL ODBC Driver. I was struggling to get it works. The following method works very well on my home network. So let’s dig inside.

My Setup

• I have a Windows 10 running Oracle Database 12.2
• I am going to connect to my Oracle Database via ODBC from another computer, running Windows 10 as well.

Step 1. Install Oracle Instant Client Basic

Oracle ODBC Driver needs this Instant Client package to run. So, we need to download this package from the official download website of Oracle.

https://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

Select the correct architecture of your system either 32 bit or 64 bit. In this example I am going to install the 32 bit version since I have MS Office 32 bit version.

Next, download the Instant Client Basic package as shown on the picture above. Also, you will need to download the Instant Client SDK and Instant Client ODBC as shown below

So now we have three packages:

• instantclient-basic-nt-12.2.0.1.0.zip
• instantclient-sdk-nt-12.2.0.1.0.zip
• instantclient-odbc-nt-12.2.0.1.0-2.zip

Now Create a new folder for the Oracle client. For example, in this case I created a new folder : C:OracleProductclient. Put all those three zip packages in that new directory. Next, extract them all. It will produce a new directory called: instantclient_12_2. If you download the different version, for example version 18.3, it will create new directory instantclient_18_3.

Step 2. Add the Oracle Client directory to the PATH environment

Now we need to add our Oracle Client directory to the Windows PATH environment. Right-click My Computer >> Advanced System Settings >> Environment Variables

On the System Variables, click New and then enter the following details:

• Variable name: OCI_LIB32
• Variable Value: C:OracleProductclientinstantclient_12_2

Change C:OracleProductclientinstantclient_12_2 with your actual Oracle Client folder.

Next step is to add the Oracle Client directory to system path. Double click the path and create a new entry as follow

Step 3. Install the Oracle ODBC Client

Now open the folder instantclient_12_2, in your Oracle Client folder created on the Step 1 and double click the file odbc_install.

Please note that there is no GUI installation wizard when you open this file.

Step 4. Create a new ODBC Data Source on Windows 10

To create a new Oracle ODBC Data Source, open Control Panel >> Administrative Tools >> ODBC Data Sources (32bit). If you are using 64 bit version, choose the ODBC Data Sources (64bit).

Click Add to add a new DSN. Select “Oracle in instantclient_12_2” from the list. Click Finish. Next, enter the Oracle ODBC Driver Configuration. Give the new Data Source Name, select TNS Service Name and User ID. Click Test Connection to validate the connection to the Oracle Database Server.

Troubleshooting

On my first attempt, I cannot get the list of the TNS Service when creating a new ODBC Connection. To solve this, we need to copy or create the tnsnames.ora in the Oracle Client Directory. Open Notepad and then copy and paste these lines and then save it as tnsname.ora. Save the file in the Oracle Client directory (C:OracleProductclientinstantclient_12_2).

This is the content of my tnsnames.ora which is works well

LISTENER_ORCL =
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
     )
     (CONNECT_DATA =
       (SID = CLRExtProc)
       (PRESENTATION = RO)
     )
   )
ORCL =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.51)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = orcl)
     )
   )
MYDB01 =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.51)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = mydb01)
     )
   )

After that, we need to tell the system to use this tnsnames.ora config file. Open the Environment Variable again and add a new entry with the following value:

• Variable Name: TNS_ADMIN
• Variable Value: C:OracleProductclientinstantclient_12_2

Don’t forget to change the variable value with your Oracle Client Directory.

Now you should be able to pick or select the TNS service. Thanks for reading this how to install Oracle ODBC driver on Windows 10. Cheers

<- Windows

Overview

Configuration of ODBC on Oracle systems can be very confusing. The following is designed to navigate you quickly through this maze. In many cases that means using the 32-bit driver on a 64 bit system. There are two separate Microsoft ODBC Administrators on a 64-bit Windows OS. While the location of the ODBC Administrators are different, the names of the executables are exactly the same!

• 64-bit Microsoft ODBC Administrator (C:WindowsSystem32odbcad32.exe)
• 32-bit Microsoft ODBC Administrator (C:WindowsSysWOW64odbcad32.exe)

Configure ODBC Session 🠈 Quick and dirty steps.

The Oracle MS ODBC Administrator (under the Oracle menu) runs the 64-bit version on a 64-bit OS.

 Start | Oracle | Configuration and Migration Tools | MS ODBC Administrator

The Microsoft OS Data Sources (ODBC) runs the 64-bit version:

 Start | All Programs | Control Panel | Administrative Tools | Data Sources (ODBC)

Installing Oracle 32-bit ODBC Driver (11g)

Seeing all the ODBC issues that have existed, Oracle has embraced the installation of the 32-bit client along side your 64-bit database or client software. Download and install the Oracle 11g 32-bit client with these options:

1. (x) Custom
2. (x) Skip software updates
3. Language: <Use Default>
4. Software Location
   Name: OraClient3211g_home1 (if prompted)
   Path: c:apporacleproduct11.2.0.3client32 (for 32-bit)
   Path: c:apporacleproduct11.2.0.3client64 (for 64-bit)

   It is important is to make these different from other Oracle software on this system so as not to conflict. Thus the client32 etc.

5. Components

    
     [x] Oracle ODBC Driver
     [x] Oracle Provider for OLE DB 
     [x] Oracle Provider for .NET (if used) 
   * Install
   

• Close

Post Install Comments

• Make sure to set the environment variable TNS_ADMIN to the directory where your tnsnames.ora file is.
• If you use the 32-bit Oracle recommends that you create a shortcut on your desktop and label it «32-Bit ODBC Admin»
  for future use. Target: C:WindowsSysWOW64odbcad32.exe
• In some environments «Add» does not work right in the ODBC Administrator. The work around is to use «Add» to create a bogus
  entry (with say the DSN name «X») then use «Configure» to create one with the DSN name you need. This fixes the dreaded
  ORA-12557 «protocol adapter not loadable» error.
• If you are still having Oracle ODBC issues this Oracle support page document is useful: 741033.1

APPENDIX

Configure ODBC Session

1. Download and install an Oracle client (ex: winx64_12102_client.zip) with ODBC.
   • This will install the corresponding Oracle ODBC driver.
   • Make sure to set the install path to use oracle not current user you are logged in as!
   • Install using the Administrator option will give you useful debugging tools.
2. Create a tnsnames.ora file and entry for your database.
   Example: C:apporacleproduct12.1.0.2client_1networkadmintnsnames.ora
3. Set the TNS_ADMIN environment variable.
   • Run Env Var Editor (Win10): rundll32.exe sysdm.cpl,EditEnvironmentVariables
   • Select New.
   • Variable Name: TNS_ADMIN
   • Variable value: C:apporacleproduct12.1.0.2client_1networkadmin
   • Select: OK
4. Launch the ODBC Admin tool and create an entry for your database.
   • Run: C:WindowsSystem32odbcad32.exe (this is the 64-bit ODBC)
   • Select System DSN tab then Add.
   • Select Oracle driver: Oracle in OraClient12Home1 then Finish.
   • Data Source Name: <Name Your Application Will Use for ODBC Database>
   • Description: Leave Blank
   • TNS Service Name: <Your tnsnames.ora Service Name>
   • UserID: <Your Oracle Database UserName>
   • Select OK to save.
5. In many ODBC Oracle drivers you can also Test Connection from here too.

Are you planning to install the Oracle ODBC Driver on Windows 10?

Open Database Connectivity (ODBC) is a standard interface that gives one application access to several different data sources. As a result, the Oracle ODBC can be used to access Oracle databases.

This is a great advantage for advanced users and programmers, who need access to the Oracle ODBC for running online transaction processing, data warehousing, and mixed database workloads — which Oracle is widely used for.

However, it is not as easy as installing a program, as it requires downloading and compiling files together. You may also need to input additional data the application will need to run properly. Luckily, we’re here to help.

In this article, we’ll introduce you to a structured process behind procuring and installing the Oracle ODBC Driver in Windows 10. 

1. Download the Oracle Instant Client Package From the Website. 

Before installing and setting up your driver, you’ll need to download three separate files from the Oracle website and place them into the appropriate folder location. These files are essential in making the software function as it should, enabling your ODBC applications to work by providing additional libraries and resources.

Additionally, you need to download the right files; they must be compatible with each other, as well as your operating system. Downloading or otherwise using the wrong version of each file may cause errors for your driver and your system.

Here’s where you can find and download the Oracle packages:

1. Begin by going to the Oracle Instant Client page on your browser.
2. Next, click the Instant Client for Microsoft Windows. Look for the link that matches your PC’s platform.
3. Follow by choosing the Basic package download link.

1. Once it’s finished downloading, scroll down and press the SDK package hyperlink to download that archive.
2. Then, click the download link for the ODBC package.
3. Now that it’s on your PC, go to your File Explorer window.
4. Check the C: root drive in File Explorer.
5. Then, right-click a space within the C: drive and make a new folder.

1. Name your new folder Oracle and make sure that it has this path: C:Oracle. 
2. After that, move the three downloaded Oracle ZIP archives into the Oracle folder and extract them there.
3. Look for the extracted instantclient-basic-windows.x64-19.11.0.0.0dbru folder and open it.
4. Inside, find a subfolder entitled instantclient_19_11 and move it into the Oracle folder.
5. Finally, erase the instantclient-basic-windows.x64-19.11.0.0.0dbru folder.

2. Add an Oracle Client Directory to PATH Environment. 

An environment variable is an editable value that other programs and applications can access within your computer. This lets the Oracle driver know where to install files, store them, and find user settings.

After extracting and setting up the necessary files for your driver to work, you’ll need to add the Oracle Client directory as an environment variable. This lets other applications and programs access your ODBC driver, allowing you to access the Oracle Database.

Here’s how to properly add the Oracle Client as an environment variable:

1. Press the Windows+S keys. This will open the search bar.

1. Type in the phrase system environment variables into the search bar.
2. Next, select the Edit the system environment variables option. This should open the System Properties window.

1. Select the Environment Variables... under the Advanced tab.

1. Next, select New… under the system variables list.

1. Input OCI_LIB32 into the Variable Name box.
2. Under the Variable Value box, input the directory path of your Oracle folder.
3. Considering you properly formatted the folders previously, your directory path should be: C:Oracleinstantclient_19_11.
4. Within the system variables list, double-click the Path variable.
5. Once opened, click the New button and input the same directory path you added under the Variable Value box. (This would be C:Oracleinstantclient_19_11).
6. Click OK and exit the window.

3. Install the Oracle ODBC Client.

This step is fairly straightforward. We’ll be installing the Oracle client itself, which can be done in just a few moves.

Here’s how you can install the Oracle ODBC client:

1. First, start by opening the instantclient_19_11 folder. 
2. Next, right-click the odbc_install.exe file. 
3. Finally, select Run as Administrator.

4. Create New ODBC Data Source.

Finally, we’ll be setting up the DSN (Data Source Name) for your newly installed Oracle driver. Note that the information you’ll be adding will be specific to the database you’re trying to connect to. Hence, this information will be different.

Your DSN will contain information that your ODBC driver will need to connect to a specific database. This will include information like the name, directory, and driver of the database. Depending on the type of DSN, it may also include the ID and password of the user.

Here is how to set up your DSN:

1. Press both the Windows and S keys to open up the search bar.
2. Enter ODBC Data Sources into the search box.
3. Select the ODBC Data Sources to open a window.

1. Click the Add button to open the Create New Data Sources 
2. Select your Oracle driver and click Finish.
3. Open the Oracle ODBC Driver Configuration window and enter your information; such as the Data Source Name, TNS Service Name, and User ID.
4. Press the OK button to exit.

After setting this up, your driver should be able to connect to the Oracle Database server directly.

That wraps it up for this tutorial on how you can install the Oracle ODBC driver in Windows 10. We hope this article has helped you in setting up your own ODBC driver. If you have concerns or inquiries, don’t hesitate to leave a comment don’t below.

If this guide helped you, please share it. 🙂

Join 50,000+ subscribers

Stay updated on the latest discounts, exclusive promos, and news articles from Saint.

Драйвер Oracle ODBC или Open Database Connectivity помогает подключать системы Windows к другим сетям Oracle. В этом отношении настройка не встроена в Windows 10 или любую другую версию операционной системы. Поэтому вам необходимо установить эту настройку отдельно, а затем подключить ее к другим сторонним сетям.

Кроме того, Oracle является ведущей системой управления данными для Windows. Установка драйвера сложна, особенно если вы считаете себя технически сложным. Но это возможно.

В этом сообщении блога я подробно обсудил методы, разработанные непосредственно экспертами в этой области. Кроме того, я также попытался добавить советы и ответил на общие вопросы, которые могут возникнуть в процессе.

Пошаговый метод загрузки и установки драйвера ODBC

Часть 1. Установка и извлечение пакетов Oracle

Шаг 1.  В интернет-браузере перейдите на веб-сайт Oracle Instant Client .

Шаг 2.  В зависимости от платформы вашего ПК выберите и щелкните ссылку Мгновенный клиент для 32-разрядной или 64-разрядной версии Microsoft Windows.

Шаг 3:  Перейдите к базовому пакету и щелкните ссылку для загрузки.

Шаг 4:  В появившемся окне опустите курсор вниз и нажмите на гиперссылку пакета SDK . Это поможет вам в загрузке файла.

Шаг 5:  Кроме того, вам также необходимо скачать ссылку на пакет ODBC.

Шаг 6: Запустите проводник и нажмите кнопку на панели задач папки.

Шаг 7: В проводнике щелкните корневой диск C:

Кроме того, выполните следующие действия

Шаг 8: На диске C: найдите место и щелкните его правой кнопкой мыши. Затем в раскрывающемся меню выберите « Создать » и « Папка » .

Шаг 9:  Переименуйте новую папку в Oracle , что даст вам путь C:Oracle .

Шаг 10:  Отправьте ZIP-файлы Oracle в эту новую папку, выбрав их и нажав «Переместить в». В разделе « Проводник » выберите « Выбрать местоположение » .

Шаг 11:  Кроме того, вам необходимо извлечь все папки Oracle Zip. Для этого выберите все файлы и нажмите кнопку « Извлечь все » . Вы можете сделать это на вкладке «Инструменты для сжатых папок» Проводника.

Шаг 12:  Чтобы выбрать папку Oracle, перейдите в окно «Извлечь сжатое» и нажмите кнопку « Обзор » . Нажмите «Извлечь » .

Шаг 13:  Кроме того, вы можете открыть папку Instant client-basic-windows.x64-19.11.0.0.0 dbru и отправить подпапку Instantclient_19_11 в папку Oracle.

Шаг 14:  Кроме того, удалите старую папку мгновенного клиента, чтобы у вас осталась только одна из них.

Извлеките все папки мгновенного клиента из ZIP-папок и, наконец, удалите папку мгновенного клиента. Это позволит убедиться, что у вас нет лишних ненужных подпапок. Более того, специалисты рекомендуют скачать пакет SDK и сохранить его в файле Instant_client .

Часть 2. Как добавить переменную среды Oracle Client Directory

Теперь, когда вы загрузили пакет Oracle, вам нужно добавить его в каталог клиента. И если у вас возникли проблемы с выполнением всего этого самостоятельно, следуйте нашим шагам один за другим.

Шаг 1:  Одновременно нажмите кнопку Windows + S на клавиатуре, чтобы открыть окно поиска.

Шаг 2: В поле «Текст поиска» введите « Ключевое слово системные переменные среды » .

Шаг 3:  Далее нажмите « Редактировать переменные системной среды », автоматически открыв окно, показанное ниже.

Шаг 4:  Кроме того, нажмите на опцию « Переменные среды » . Затем нажмите на окно « Создать в системной переменной» .

Шаг 5: Введите OCI_LIB32 в поле имени переменной. Вам также необходимо ввести путь к папке Oracle, который будет выглядеть так: C:OracleInstantclient_19_11 .

Шаг 6: Чтобы открыть окно в моментальном снимке, дважды щелкните « Путь» в «Системных переменных» .

Шаг 7:  Нажмите « Создать » и введите путь к папке в поле «Значение переменной». И нажмите «Ок » .

Часть 3: Установка клиентского пакета ODBC Oracle

Следующая часть — установить клиент ODBC, открыв папку Instant_client_19_11 из пакета ODBC в проводнике. Кроме того, щелкните правой кнопкой мыши параметр odbc_install.exe и нажмите «Запуск от имени администратора».

Часть 4: Настройка сети источника данных

Четвертая часть — настроить сеть источника данных или DSN. Сделать это:

Шаг 1: Запустите средство поиска в Windows и введите источники данных ODBC .

Шаг 2:  Нажмите на источники данных ODBC , чтобы открыть новое окно. Кроме того, нажмите «Добавить» в пользовательской системе DSN и откройте параметр «Создать новый источник данных».

Шаг 3:  Кроме того, выберите драйвер Oracle ODBC и нажмите «Готово». В окне конфигурации заполните необходимые данные.

Шаг 4:  Проверьте подключение к серверу базы данных Oracle , нажав « Проверить подключение» . Чтобы выйти, нажмите « Выход » .

Часть 5. Установка отсутствующих библиотек Visual C++

Теперь мы находимся в последней части, которая проста. Для начала вы можете настроить источники данных с источником данных ODBC для драйвера Oracle. Однако вы можете сделать это только в том случае, если у вас еще не установлен визуальный C++. Обычно выскакивает сообщение об ошибке. В этом случае вы можете загрузить Visual Audio 2017 и другие пакеты распространения.

Нажмите на загруженный файл VC EXE , и это способ установить драйвер Oracle ODBC в Windows 10.

Как установить Oracle Instant Client ODBC в Linux и UNIX?

Шаг 1:  В операционных системах Linux и UNIX загрузите и установите клиентский пакет Oracle . И еще раз разархивируйте его в каталог. Если вы используете пакет RPM в Unix, вы можете установить его с помощью yum.

Шаг 2:  Если драйвер UnixODBC недоступен, установите его.

Шаг 3:  Перейдите в Instant Client Directory и запустите odbc_update_ini.sh .

Шаг 4:  В зависимости от вашей локали установите переменную Oracle Globalization, которая будет выглядеть как export NLS_LANG=JAPANESE_JAPAN.JA16EUC для JA16EUC на японском языке.

Для использования: odbc_update_ini.sh <ODBCDM_HOME> [<Install_Location><Driver_Name><DSN><ODBCINI>]

Чтобы лучше понять это, см. этот список параметров и описание.

• ODBCDM_Home : путь к домашнему каталогу диспетчера драйверов unixODBC.
• Install_Location : Текущий каталог мгновенного клиента Oracle является путем по умолчанию.
• Driver_Name : идентифицирует драйвер Oracle ODBC в текущем домашнем каталоге Oracle Instant Client. Имя может быть чем-то вроде Oracle 19c ODBC Driver.
• DSN : имя по умолчанию для DSN — Oracle ODBC-19c.
• ODBCINI:  это путь к файлу .odbc.ini, который является домашним каталогом пользователя по умолчанию.

Как удалить Oracle Client ODBC в Windows 10?

Шаг 1:  В Windows 10 вы можете удалить ODBC клиента Oracle, удалив сеть источника данных. Он связан с драйвером Oracle ODBC, присутствующим в консоли администратора источника данных ODBC.

Шаг 2.  В каталоге Instant client запустите odbc_uninstall.exe .

Шаг 3:  Кроме того, вы можете удалить все файлы и каталоги один за другим из каталога Client ODBC.

Вывод

Выполните действия, описанные в этой статье, чтобы загрузить клиентский пакет Oracle и удалить его, когда он вам не нужен. Если есть какой-либо другой способ, который проще сделать в Windows 10, сообщите нам об этом в комментариях ниже.

Oracle ODBC or Open Database Connectivity driver helps in connecting Windows systems to other oracle networks. The set-up is not in-built in Windows 10 or any other version of the operating system, for that matter. Therefore, you need to install this set up separately and then connect it to other third-party networks.

Moreover, Oracle is a premier data management system for Windows. Installing the driver is complicated, especially if you consider yourself technically challenged. But it’s not impossible.

In this blog post, I have extensively discussed the methods that have come directly from experts in the field. In addition, I have also tried to add tips and answered the common questions that may arise in the process.

Also Read: How To Fix Bluetooth Mouse Not Working In Windows 10?

Step-By-Step Method To Download & Install ODBC Driver

Part 1: Install & Extract The Oracle Packages

Step 1: From your internet browser, go to the Oracle Instant Client website.

Step 2: Depending on your PCs platform, select and click on Instant Client For Microsoft Windows 32-bit or 64-bit link.

Step 3: Go to Basic Package and click on the downloadable link.

Step 4: In the Window that appears, go down with your cursor and tap on the SDK package hyperlink. This will help you in downloading the file.

Step 5: Besides, you will also need to download the link for the ODBC package.

Step 6: Launch File Explorer and tap on the folder taskbar button for it.

Step 7: In File Explorer, click on C: root drive

Furthermore, Follow These Steps

Step 8: Within the C: drive, find a space and right-click on it. Then from the drop-down menu, select New and Folder.

Step 9: Rename the new folder as Oracle, which will give you the path C:Oracle.

Step 10: Send the Oracle ZIP files into this new folder by selecting them and tapping on Move To. Within the File Explorer section, select Choose Location.

Step 11: Furthermore, you have to extract all the Oracle Zip folders. And to do that, choose all the files, and tap on the Extract All button. You can do this on File Explorer’s Compressed Folder Tools tab.

Step 12: To select the Oracle Folder, go to the Extract Compressed Window and click on the Browse button. Tap on Extract.

Step 13: Moreover, you can open instant client-basic-windows.x64-19.11.0.0.0 dbru folder and send instantclient_19_11 subfolder to the Oracle one.

Step 14: In addition, Delete the old instant client folder so that you end up with only one of them.

Extract all the instant client folders from ZIP folders and finally delete the instant client folder. This will make sure you do not have extra unnecessary subfolders. Moreover, experts recommend that you download the SDK package and save it in the instant_client.

Also Read: How To Review And Delete Your Alexa History And Recordings

Part 2: How To Add Oracle Client Directory Environment Variable

Now that you have downloaded the Oracle Package, you have to add it to the client directory. And if you have trouble doing that all on your own, follow our steps one by one.

Step 1: Simultaneously press the Windows button + S on your keyboard, which will prompt a search box to open.

Step 2: In the Search Text box, type Keyword System Environment Variables.

Step 3: Further, tap on Edit The System Environment Variables, automatically opening the Window we have shown below.

Step 4: Moreover, click on the option that says Environment Variables. Next, tap on the New in System Variable window.

Step 5: Enter OCI_LIB32 in the variable name box. You also have to enter the Oracle folder path, which will look like this: C:OracleInstantclient_19_11.

Step 6: To open the Window in the snapshot, double click on Path in System Variables.

Step 7: Tap on New and type the folder path in the Variable Value box. And click on Okay.

Part 3: Installation Of ODBC Oracle Client Package

The next part is to install the ODBC client by opening the instant_client_19_11 folder from the ODBC package in File Explorer. Moreover, right-click on the option odbc_install.exe and tap Run as Administrator.

Part 4: Setting Up Data Source Network

The fourth part is to set up a data source network or a DSN. To do this:

Step 1: Launch the Search Tool in Windows and type ODBC data sources.

Step 2: Click on ODBC data sources that will open a new window. Moreover, tap on Add from the User DSN system and open the Create New Data Source option.

Step 3: Furthermore, choose your Oracle ODBC driver and click on Finish. On the configuration window, fill out the details necessary.

Step 4: Check the Oracle Database Server Connection by clicking on Test Connection. To leave, click on Exit.

Also Read: How To Set Up 3 Monitors In Windows 10?

Part 5: Installing Visual C++ Libraries That Are Missing

Now we are in the last part, which is simple. To begin with, you can set up data sources with the ODBC data source for an Oracle Driver. However, you can only do this if you have not installed the visual C++ yet. Usually, an error message pops up. In this case, you can download Visual Audio 2017 and other redistribution packages.

Tap on the VC EXE file you downloaded, and this is the way to install the Oracle ODBC driver on Windows 10.

How To Install Oracle Instant Client ODBC On Linux And UNIX?

Step 1: On your Linux and UNIX operating systems, download and install the Oracle Client Package. And once again, unzip it in the directory. If you are using the RPM package on Unix, you can install it with yum.

Step 2: If the UnixODBC driver is not available, install it.

Step 3: Go to the Instant Client Directory and execute odbc_update_ini.sh.

Step 4: Depending on your locale, set an Oracle Globalization variable which will look like export NLS_LANG=JAPANESE_JAPAN.JA16EUC for the JA16EUC in Japanese.

For usage: odbc_update_ini.sh <ODBCDM_HOME> [<Install_Location><Driver_Name><DSN><ODBCINI>]

To understand this further, see this list of parameters and description.

• ODBCDM_Home: unixODBC driver manager home directory path
• Install_Location: The current Oracle instant client directory is the default path
• Driver_Name: It identifies the Oracle ODBC driver in the current residing Oracle Instant Client home. The name can be something like Oracle 19c ODBC Driver.
• DSN: Default name for DSN is Oracle ODBC-19c
• ODBCINI: This is the directory path .odbc.ini file which is the default users home directory.

How To Uninstall Oracle Client ODBC On Windows 10?

Step 1: In Windows 10, you can uninstall Oracle client ODBC by removing the Data source network. It is associated with the Oracle ODBC Driver, present in the ODBC data source administrator console.

Step 2: From the Instant client directory, execute odbc_uninstall.exe.

Step 3: Furthermore, you can remove all the files and directories one by one from the Client ODBC director.

Conclusion

Follow the steps in this article to download the Oracle Client Package and uninstall it when you don’t need it. If there’s any other way that’s easier to do in Windows 10, let us know in the comments below.

2011-03-15 19:55:52

Oracle

Windows