Источники данных ODBC 32 и 64 разрядная версия Windows 10

Продолжаем разбор функций операционной системы Windows 10. Сегодня речь пойдёт об источнике данных ODBC на 32 разрядной версии компьютера Windows 10. ODBS – это программный интерфейс, позволяющий приложениям получать доступ к данным в системах управления базами данных (СУБД), основанных на языке SQL. Чтобы открыть окно администратора источника данных ODBC, в нижнем левом углу экрана нажмите на кнопку Пуск. В открывшемся окне нажмите на вкладку – Все приложения .

Далее, в списке всех приложений, в самом низу, нажмите на вкладку Средства администрирования . В открывшемся списке нажмите на вкладку – Источники данных ODBC (32 разрядная версия) . Обратите внимание, что здесь есть ODBC и для 64 разрядной версии Windows 10. Как узнать версию своего ПК на Windows 10.

Далее, у вас откроется окно администратора ODBC. Здесь вы сможете работать со следующими функциями:

– Пользовательский DSN, пользовательский источник данных ODBC сохраняет сведения о том, как подключиться к указанному поставщику данных. Пользовательский источник данных является видимым только для вас и может использоваться только на текущем компьютере.

– Трассировка ODBC позволяет создавать журналы вызовов драйверов ODBC для использования службой поддержки или для оказания помощи при отладке приложений.

– Системный DSN, системный источник данных ODBC сохраняет сведения о том, как подключиться к указанному поставщику данных. Системный источник данных является видимым для всех пользователей на этом компьютере, включая службы NT.

– Пул соединений позволяет приложению повторно использовать открытые дескрипторы соединений, что позволяет уменьшить число обменов данными с сервером.

– Файловый DSN, файловый источник данных ODBC позволяет установить связь с этим источником. Пользователи, у которых установлены одинаковы драйверы, могут применять их совместно.

– Драйверы ODBC позволяют программам ODBC получать сведения из источника данных ODBC. Драйверы устанавливаются с помощью программы установки.

64 разрядная версия имеет такого же администратора ODBC.

Download ODBC Driver for SQL Server

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Parallel Data Warehouse

Microsoft ODBC Driver for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to SQL Server. Use Microsoft ODBC Driver 17 for SQL Server to create new applications or enhance existing applications that need to take advantage of newer SQL Server features.

Download for Windows

The redistributable installer for Microsoft ODBC Driver 17 for SQL Server installs the client components, which are required during run time to take advantage of newer SQL Server features. It optionally installs the header files needed to develop an application that uses the ODBC API. Starting with version 17.4.2, the installer also includes and installs the Microsoft Active Directory Authentication Library (ADAL.dll).

Version 17.7.2 is the latest general availability (GA) version. If you have a previous version of Microsoft ODBC Driver 17 for SQL Server installed, installing 17.7.2 upgrades it to 17.7.2.

Download Microsoft ODBC Driver 17 for SQL Server (x64)
Download Microsoft ODBC Driver 17 for SQL Server (x86)

Version information

• Release number: 17.7.2.1
• Released: March 10, 2021

If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the US-English version of the site. You can download different languages from the US-English version site by selecting available languages.

Available languages

This release of Microsoft ODBC Driver for SQL Server can be installed in the following languages:

Release notes for Windows

For details about this release on Windows, see the Windows release notes.

Previous releases for Windows

Download for Linux and macOS

The Microsoft ODBC Driver for SQL Server can be downloaded and installed using package managers for Linux and macOS using the relevant installation instructions:
Install ODBC for SQL Server (Linux)
Install ODBC for SQL Server (macOS)

If you need to download the packages for offline installation, all versions are available via the below links.

Packages named msodbcsql17-* are the latest version. Packages named msodbcsql-* are version 13 of the driver.

Драйвер Microsoft ODBC для SQL Server в Windows Microsoft ODBC Driver for SQL Server on Windows

Скачать драйвер ODBC Download ODBC Driver

Драйверы Microsoft ODBC Driver for SQL Server SQL Server — это автономные драйверы ODBC, предоставляющие программный интерфейс (API), который реализует стандартные интерфейсы ODBC для Microsoft SQL Server SQL Server . The Microsoft ODBC Drivers for SQL Server SQL Server are stand-alone ODBC drivers which provide an application programming interface (API) implementing the standard ODBC interfaces to Microsoft SQL Server SQL Server .

Microsoft ODBC Driver for SQL Server можно использовать для создания приложений. The Microsoft ODBC Driver for SQL Server can be used to create new applications. Можно также обновить имеющиеся приложения, использующие старый драйвер ODBC. You can also upgrade your older applications which currently use an older ODBC driver. Драйвер ODBC для SQL Server поддерживает подключения к Базе данных SQL Azure, Azure Synapse Analytics и SQL Server SQL Server . The ODBC Driver for SQL Server supports connections to Azure SQL Database, Azure Synapse Analytics, and SQL Server SQL Server .

Сводка Summary

Версия Version	Поддерживаемые возможности Features Supported
Microsoft ODBC Driver for SQL Server версии 17 Microsoft ODBC Driver 17 for SQL Server	Поддержка Always Encrypted для API BCP Always Encrypted support for BCP API Новый атрибут строки подключения UseFMTONLY предписывает драйверу использовать старые метаданные в особых случаях, в которых требуются временные таблицы New connection string attribute UseFMTONLY causes driver to use legacy metadata in special cases requiring temp tables
Microsoft ODBC Driver for SQL Server версии 13.1 Microsoft ODBC Driver 13.1 for SQL Server	Always Encrypted Always Encrypted Аутентификация Azure AD Azure AD Authentication Группы доступности AlwaysOn AlwaysOn Availability Groups (AG)
Microsoft ODBC Driver for SQL Server версии 13 Microsoft ODBC Driver 13 for SQL Server	Международное доменное имя (IDN) Internationalized Domain Name (IDN)
Драйвер Microsoft ODBC 11 для SQL Server Microsoft ODBC Driver 11 for SQL Server	Организация пулов соединений с учетом драйвера Driver-Aware Connection Pooling Устойчивость подключений Connection Resiliency Асинхронное выполнение (метод опроса) Asynchronous execution (Polling Method)

Документация Documentation

Эта документация для Microsoft ODBC Driver для SQL Server SQL Server включает в себя следующее: This documentation for the Microsoft ODBC Driver for SQL Server SQL Server includes:

How to Install Oracle ODBC Driver on 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.

Steps to Install Oracle ODBC Driver on Windows 10

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.

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:\Oracle\Product\client. 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:\Oracle\Product\client\instantclient_12_2

Change C:\Oracle\Product\client\instantclient_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:\Oracle\Product\client\instantclient_12_2).

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

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:\Oracle\Product\client\instantclient_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

Share this:

Like this:

9 Comments

Mejor explicado no puedo quedar, mil gracias.

You have saved my life!!

Have a good one.

Hi,
I have trouble with install ODBC driver /client on Windows 10 64 bit machine. I have installed Oracle 19c Db on one PC, and from my PC I want connect to it , My PC is Windows 10 64 bit, but because my develeloping application is 32 bit I install ODBC 32 bit. ALso Visual C++ redist.is 32 bit. From ODBC Administrator data source I can create DSN, and also test connection, all works without problems.
But when I run my test program (programmed in Alaska Xbase++ and SQLExpress++ library) connect first after instalation, and no anymore, still get error
= SQL ERROR ===========
Date: 20200528 11:33:55
C:\TESTORACLE\SQLBROW.EXE, Thread: 1
Windows 8 06.02 Build 09200, SQLXpp: 3.3.00, Runtime: 2.00.554
SQLState: IM003, ErrorCode:160
Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in instantclient_19_6, C:\Oracle\Product\Client\instantclient_19_6\SQORA32.dll).

I tryedl everything, and no solution. This looks to first “some” open SQLORA32.DLL and not release it, or I do not know something stay blocked and cannot connect again.
No help reinstall driver, unistal/install, nothing. 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.
Interesting is that on third PC with also W10 64 bit this works for me that I mean some can be in Windows configuration, some process or dll open and stay opened, or rewrite some parameter in registry, do not know.
Please thanks for any advice.

Thanks for the article! One more possible solution is ODBC Driver for Oracle
https://www.devart.com/odbc/oracle/
Devart ODBC Driver for Oracle provides a high-performance and feature-rich connectivity solution for ODBC-compliant applications to access Oracle databases from Windows, macOS, or Linux, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with Oracle fast, easy and extremely handy.

Thanks for the suggestion, will try it next.