Драйверы ODBC Майкрософт для баз данных на настольном компьютере Microsoft ODBC Desktop Database Drivers

ODBC — это API, который использует язык SQL (SQL) в качестве языка доступа к базе данных. ODBC is an API that uses Structured Query Language (SQL) as the database access language. Вы можете получить доступ к широкому спектру систем управления базами данных (СУБД) с тем же исходным кодом ODBC, который напрямую включен в исходный код приложения. You can access a wide variety of database management systems (DBMSs) with the same ODBC source code that is directly incorporated into an application’s source code. С драйверами базы данных Microsoft ODBC для настольных компьютеров пользователь приложения, поддерживающего ODBC, может открывать, запрашивать и обновлять базу данных настольных систем через интерфейс ODBC. With the Microsoft ODBC Desktop Database Drivers, a user of an ODBC-enabled application can open, query, and update a desktop database through the ODBC interface.

Драйверы Microsoft ODBC для настольных систем представляют собой набор драйверов ODBC на основе Microsoft Jet. The Microsoft ODBC Desktop Database Drivers are a Microsoft Jet-based set of ODBC drivers. В то время как 2,0 драйверы базы данных Microsoft ODBC для настольных систем включают как 16-разрядные, так и 32-разрядные драйверы, версии 3,0 и более поздних версий включают только 32-разрядные драйверы, работающие под управлением Windows 95 или более поздней версии, Windows NT Workstation или Server Version 4,0, Windows 2000 Professional или Windows 2000 Server. Whereas Microsoft ODBC Desktop Database Drivers 2.0 include both 16-bit and 32-bit drivers, versions 3.0 and later include only 32-bit drivers that work on Windows 95 or later, Windows NT Workstation or Server version 4.0, Windows 2000 Professional, or Windows 2000 Server. Эти драйверы предоставляют доступ к следующим типам источников данных: These drivers provide access to the following types of data sources:

Microsoft Access Microsoft Access

Microsoft Excel Microsoft Excel

Подробную документацию по драйверу ODBC для Microsoft Visual FoxPro® см. в разделе драйвер ODBC для Visual FoxPro . See Visual FoxPro ODBC Driver for detailed documentation about the Microsoft Visual FoxPro® ODBC Driver.

Доступ к другим источникам данных, таким как Lotus 1-2-3, Microsoft Exchange и HTML, включается с помощью устанавливаемых драйверов ISAM (IISAM). Access to other data sources, such as Lotus 1-2-3, Microsoft Exchange, and HTML, is enabled by installable ISAM (IISAM) drivers. Дополнительные сведения об этих драйверах см. в разделе «доступ к внешним данным» статьи Справочник программиста по Microsoft Jet ядро СУБД. For more information about these drivers, see «Accessing External Data» in the Microsoft Jet Database Engine Programmer’s Reference. Драйверы для баз данных ODBC для настольных систем 4,0 не поддерживают форматы данных Btrieve и EMS. ODBC Desktop Database Drivers 4.0 do not support Btrieve and EMS data formats.

Этот раздел содержит следующие подразделы. This section contains the following topics.

Win 10 ODBC MS Access ACCDB not available

Pretty Obvious to a retired systems manager that there is a 32bit and a 64bit version, I am testing legacy databases ready for Win 10 and Office 2016 that use ODBC connectors, so firstly the directory that you mention does not exist on a win 10 pro 32bit install and I on a 64bit install yes the ODBC 32 and 64bit options are available but again neither of them allow ACCDB connection only the older MDB.

Maybe someone could provide an answer that has some idea of what there talking about, a microsoft professional please, not a home user that thinks he’s the dogs.

Clean Install of Win 10 Pro Ver.Latest on insider preview 32Bit. I have Microsoft Access 2010 databases with extensions of ‘ACCDB’ held on a server with multi user access Via ODBC connectors. all worked fine on Windows 7/8 and office 2010.

Windows 10 has ODBC connectivity for Microsoft Access ‘MDB’ via ODBC but not ‘ACCDB’.

I have tried installing Office 2010 but the Connectors do not appear.

I have tried installing Office 2016 again the connectors do not appear.

I have trawled the Microsoft developer/technical sites, the old (very old) options showing for downloading the MDAC stuff I have tried but does not work.

So how to access server stored ACCBB files via ODBC .

with data Cannot find the ODBC drivers for MSAccess 2010×32 in the ODBC Data Source Administrator. Data transfer for non Office programs is not available.

Replies (5) 

You may want to install SQL Server Native Client if it is not installed.

There are two ODBC applets: one for 32-bit and one for 64-bit. The one for 32-bit is in the Windows\SysWow64 folder.

2 people found this reply helpful

Was this reply helpful?

Sorry this didn’t help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hmm, THIS Forum is manned by UNPAID volunteers and most are MVP’s and the like and while the are some are Home Users there is no need to be rude. Since it sounds like you want *professional* support please call Microsoft Support and for a fee you can get one on one assistance.

10 people found this reply helpful

Was this reply helpful?

Sorry this didn’t help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

«Maybe someone could provide an answer that has some idea of what there talking about, a microsoft professional please, not a home user that thinks he’s the dogs. «

I don’t know how you were brought up, but what a way to talk to people trying to help you on their own unpaid time! And you expect others to continue to answer you, only to get insulted!

4 people found this reply helpful

Was this reply helpful?

Sorry this didn’t help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

So you’re looking for ODBC drivers to connect to an Access database by an external application.

Because Access database engine runs in-process, you must use the same bitness the external application runs in. If it’s a 32-bit application, then you must use 32-bit driver. Likewise, if this application is 64-bit, then you must use 64-bit driver. The bitness of Windows is irrelevant in this context.

With Office, however, you cannot mix 32-bit installation and 64-bit installation and that goes for Access database engine, which is a part of the Office installation. Note that you can install the database engine without the Office by downloading and installing «Access Database Engine redistributable» (please note that this is different from Access runtime — runtime allows you to run Access applications (think forms & reports) whereas redistributable contains only the engine but no interface.

You can get either 32-bit or 64-bit 2010 redistributable here:

As Tom noted earlier, on a 64-bit Windows, you do have two odbcad32 applet and you must open one that is the appropriate bitness. You will likely find that because you’ve already installed Office, you will be able to see the 2010 Access ODBC drivers in 32-bit odbcad32.exe in sysWOW64 folder. By default Office 2010 installs 32-bit and one has to explicitly go out of their way to install 64-bit version of Office.

If your external application is 32-bit and the Office installed is 64-bit, then you have a problem because as said at the beginning, the drivers and the application has to be same bitness to be usable.

Драйверы ODBC Майкрософт для баз данных на настольном компьютере Microsoft ODBC Desktop Database Drivers

ODBC — это API, который использует язык SQL (SQL) в качестве языка доступа к базе данных. ODBC is an API that uses Structured Query Language (SQL) as the database access language. Вы можете получить доступ к широкому спектру систем управления базами данных (СУБД) с тем же исходным кодом ODBC, который напрямую включен в исходный код приложения. You can access a wide variety of database management systems (DBMSs) with the same ODBC source code that is directly incorporated into an application’s source code. С драйверами базы данных Microsoft ODBC для настольных компьютеров пользователь приложения, поддерживающего ODBC, может открывать, запрашивать и обновлять базу данных настольных систем через интерфейс ODBC. With the Microsoft ODBC Desktop Database Drivers, a user of an ODBC-enabled application can open, query, and update a desktop database through the ODBC interface.

Драйверы Microsoft ODBC для настольных систем представляют собой набор драйверов ODBC на основе Microsoft Jet. The Microsoft ODBC Desktop Database Drivers are a Microsoft Jet-based set of ODBC drivers. В то время как 2,0 драйверы базы данных Microsoft ODBC для настольных систем включают как 16-разрядные, так и 32-разрядные драйверы, версии 3,0 и более поздних версий включают только 32-разрядные драйверы, работающие под управлением Windows 95 или более поздней версии, Windows NT Workstation или Server Version 4,0, Windows 2000 Professional или Windows 2000 Server. Whereas Microsoft ODBC Desktop Database Drivers 2.0 include both 16-bit and 32-bit drivers, versions 3.0 and later include only 32-bit drivers that work on Windows 95 or later, Windows NT Workstation or Server version 4.0, Windows 2000 Professional, or Windows 2000 Server. Эти драйверы предоставляют доступ к следующим типам источников данных: These drivers provide access to the following types of data sources:

Microsoft Access Microsoft Access

Microsoft Excel Microsoft Excel

Подробную документацию по драйверу ODBC для Microsoft Visual FoxPro® см. в разделе драйвер ODBC для Visual FoxPro . See Visual FoxPro ODBC Driver for detailed documentation about the Microsoft Visual FoxPro® ODBC Driver.

Доступ к другим источникам данных, таким как Lotus 1-2-3, Microsoft Exchange и HTML, включается с помощью устанавливаемых драйверов ISAM (IISAM). Access to other data sources, such as Lotus 1-2-3, Microsoft Exchange, and HTML, is enabled by installable ISAM (IISAM) drivers. Дополнительные сведения об этих драйверах см. в разделе «доступ к внешним данным» статьи Справочник программиста по Microsoft Jet ядро СУБД. For more information about these drivers, see «Accessing External Data» in the Microsoft Jet Database Engine Programmer’s Reference. Драйверы для баз данных ODBC для настольных систем 4,0 не поддерживают форматы данных Btrieve и EMS. ODBC Desktop Database Drivers 4.0 do not support Btrieve and EMS data formats.

Этот раздел содержит следующие подразделы. This section contains the following topics.

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.

Драйвера odbc для windows 10 64 access

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

• Check the spelling of your keyword search.
• Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
• Try one of the popular searches shown below.
• Start a new search.

64-bit Oracle Data Access Components (ODAC) Downloads

Important: The 32-bit Oracle Developer Tools for Visual Studio download is required for Entity Framework design-time features. The downloads that support Entity Framework deployment below do not contain design-time tools, only run-time support.

64-bit ODAC 12.2c Release 1 (12.2.0.1.0) Xcopy for Windows x64

[Released May 31, 2017]

Download

Release Notes

This download contains ODP.NET, Managed Driver xcopy only. Installation Instructions are included within the zip file.

Installation Instructions are included within the zip file.

Download Includes

• 64-bit Oracle Data Provider for .NET 4 12.2.0.1.0
• 64-bit Oracle Data Provider for .NET 2.0 12.2.0.1.0
• 64-bit Oracle Providers for ASP.NET 4 12.2.0.1.0
• 64-bit Oracle Providers for ASP.NET 2.0 12.2.0.1.0
• 64-bit Oracle Provider for OLE DB 12.2.0.1.0
• 64-bit Oracle Services for Microsoft Transaction Server 12.2.0.1.0
• 64-bit Oracle Instant Client 12.2.0.1.0

64-bit ODAC 12.2c Release 1 (12.2.0.1.1) for Windows x64

[Released August 3, 2018]

Download

Release Notes

Download Includes

• 64-bit Oracle Data Provider for .NET 4 12.2.0.1.0
• 64-bit Oracle Data Provider for .NET 2.0 12.2.0.1.0
• 64-bit Oracle Providers for ASP.NET 4 12.2.0.1.0
• 64-bit Oracle Providers for ASP.NET 2.0 12.2.0.1.0
• 64-bit Oracle Provider for OLE DB 12.2.0.1.0
• 64-bit Oracle Services for Microsoft Transaction Server 12.2.0.1.0
• 64-bit Oracle ODBC Driver 12.2.0.1.0
• 64-bit Oracle SQL*Plus 12.2.0.1.0
• 64-bit Oracle Instant Client 12.2.0.1.0

64-bit ODAC 12c Release 4 (12.1.0.2.4) Xcopy for Windows x64

[Released October 5, 2015]

Download

Release Notes

This download contains ODP.NET, Managed Driver xcopy only. Installation Instructions are included within the zip file.

Installation Instructions are included within the zip file.

Download Includes

• 64-bit Oracle Data Provider for .NET 4 12.1.0.2.0
• 64-bit Oracle Data Provider for .NET 2.0 12.1.0.2.0
• 64-bit Oracle Providers for ASP.NET 4 12.1.0.2.0
• 64-bit Oracle Providers for ASP.NET 2.0 12.1.0.2.0
• 64-bit Oracle Provider for OLE DB 12.1.0.2.0
• 64-bit Oracle Services for Microsoft Transaction Server 12.1.0.2.0
• 64-bit Oracle Instant Client 12.1.0.2.0

64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64

[Released October 5, 2015]

Download

Release Notes

Download Includes

• 64-bit Oracle Data Provider for .NET 4 12.1.0.2.0
• 64-bit Oracle Data Provider for .NET 2.0 12.1.0.2.0
• 64-bit Oracle Providers for ASP.NET 4 12.1.0.2.0
• 64-bit Oracle Providers for ASP.NET 2.0 12.1.0.2.0
• 64-bit Oracle Database Extensions for .NET 4 12.1.0.2.0 — for upgrade only
• 64-bit Oracle Database Extensions for .NET 2.0 12.1.0.2.0 — for upgrade only
• 64-bit Oracle Provider for OLE DB 12.1.0.2.0
• 64-bit Oracle Services for Microsoft Transaction Server 12.1.0.2.0
• 64-bit Oracle ODBC Driver 12.1.0.2.0
• 64-bit Oracle SQL*Plus 12.1.0.2.0
• 64-bit Oracle Instant Client 12.1.0.2.0

64-bit ODAC 12c Release 3 (12.1.0.2.1) Xcopy for Windows x64

[Released December 23, 2014]

Download

Release Notes

This download contains ODP.NET, Managed Driver xcopy only. Installation Instructions are included within the zip file.

Installation Instructions are included within the zip file.

Download Includes

• 64-bit Oracle Data Provider for .NET 4 12.1.0.2.0
• 64-bit Oracle Data Provider for .NET 2.0 12.1.0.2.0
• 64-bit Oracle Providers for ASP.NET 4 12.1.0.2.0
• 64-bit Oracle Providers for ASP.NET 2.0 12.1.0.2.0
• 64-bit Oracle Provider for OLE DB 12.1.0.2.0
• 64-bit Oracle Services for Microsoft Transaction Server 12.1.0.2.0
• 64-bit Oracle Instant Client 12.1.0.2.0

64-bit ODAC 12c Release 3 (12.1.0.2.1) for Windows x64

[Released December 23, 2014]

Download

Release Notes

Download Includes

• 64-bit Oracle Data Provider for .NET 4 12.1.0.2.0
• 64-bit Oracle Data Provider for .NET 2.0 12.1.0.2.0
• 64-bit Oracle Providers for ASP.NET 4 12.1.0.2.0
• 64-bit Oracle Providers for ASP.NET 2.0 12.1.0.2.0
• 64-bit Oracle Database Extensions for .NET 4 12.1.0.2.0 — for upgrade only
• 64-bit Oracle Database Extensions for .NET 2.0 12.1.0.2.0 — for upgrade only
• 64-bit Oracle Provider for OLE DB 12.1.0.2.0
• 64-bit Oracle Services for Microsoft Transaction Server 12.1.0.2.0
• 64-bit Oracle ODBC Driver 12.1.0.2.0
• 64-bit Oracle SQL*Plus 12.1.0.2.0
• 64-bit Oracle Instant Client 12.1.0.2.0

64-bit ODAC 12c Release 2 (12.1.0.1.2) Xcopy for Windows x64

[Released December 20, 2013]

Download

Release Notes

This download contains ODP.NET, Managed Driver xcopy only. Installation Instructions are included within the zip file.

Installation Instructions are included within the zip file.

Download Includes

• 64-bit Oracle Data Provider for .NET 4 12.1.0.1.0
• 64-bit Oracle Data Provider for .NET 2.0 12.1.0.1.0
• 64-bit Oracle Providers for ASP.NET 4 12.1.0.1.0
• 64-bit Oracle Providers for ASP.NET 2.0 12.1.0.1.0
• 64-bit Oracle Provider for OLE DB 12.1.0.1.0
• 64-bit Oracle Services for Microsoft Transaction Server 12.1.0.1.0
• 64-bit Oracle Instant Client 12.1.0.1.0

64-bit ODAC 12c Release 2 (12.1.0.1.2) for Windows x64

[Released December 20, 2013]

Download

Release Notes

Download Includes

• 64-bit Oracle Data Provider for .NET 4 12.1.0.1.0
• 64-bit Oracle Data Provider for .NET 2.0 12.1.0.1.0
• 64-bit Oracle Providers for ASP.NET 4 12.1.0.1.0
• 64-bit Oracle Providers for ASP.NET 2.0 12.1.0.1.0
• 64-bit Oracle Database Extensions for .NET 4 12.1.0.1.0 — for upgrade only
• 64-bit Oracle Database Extensions for .NET 2.0 12.1.0.1.0 — for upgrade only
• 64-bit Oracle Provider for OLE DB 12.1.0.1.0
• 64-bit Oracle Services for Microsoft Transaction Server 12.1.0.1.0
• 64-bit Oracle ODBC Driver 12.1.0.1.0
• 64-bit Oracle SQL*Plus 12.1.0.1.0
• 64-bit Oracle Instant Client 12.1.0.1.0

64-bit ODAC 12c Release 1 (12.1.0.1.0) Xcopy for Windows x64

[Released August 13, 2013]

Download

Release Notes

This download contains ODP.NET, Managed Driver xcopy only. Installation Instructions are included within the zip file.

Installation Instructions are included within the zip file.

Download Includes

• 64-bit Oracle Data Provider for .NET 4 12.1.0.1.0
• 64-bit Oracle Data Provider for .NET 2.0 12.1.0.1.0
• 64-bit Oracle Providers for ASP.NET 4 12.1.0.1.0
• 64-bit Oracle Providers for ASP.NET 2.0 12.1.0.1.0
• 64-bit Oracle Provider for OLE DB 12.1.0.1.0
• 64-bit Oracle Services for Microsoft Transaction Server 12.1.0.1.0
• 64-bit Oracle Instant Client 12.1.0.1.0

64-bit ODAC 12c Release 1 (12.1.0.1.0) for Windows x64

[Released August 13, 2013]

Download

Release Notes

Download Includes

• 64-bit Oracle Data Provider for .NET 4 12.1.0.1.0
• 64-bit Oracle Data Provider for .NET 2.0 12.1.0.1.0
• 64-bit Oracle Providers for ASP.NET 4 12.1.0.1.0
• 64-bit Oracle Providers for ASP.NET 2.0 12.1.0.1.0
• 64-bit Oracle Database Extensions for .NET 4 12.1.0.1.0 — for upgrade only
• 64-bit Oracle Database Extensions for .NET 2.0 12.1.0.1.0 — for upgrade only
• 64-bit Oracle Provider for OLE DB 12.1.0.1.0
• 64-bit Oracle Services for Microsoft Transaction Server 12.1.0.1.0
• 64-bit Oracle ODBC Driver 12.1.0.1.0
• 64-bit Oracle SQL*Plus 12.1.0.1.0
• 64-bit Oracle Instant Client 12.1.0.1.0

64-bit ODAC 11.2 Release 6 (11.2.0.4.0) Xcopy for Windows x64

[Released January 14, 2014]

Download

Release Notes

Installation Instructions are included within the zip file.