Microsoft OLE DB Driver for SQL Server is the third generation of OLE DB Drivers for SQL Server. It introduces multi-subnet failover capabilities and includes the latest TLS 1.2 standards. Backwards compatibility with SNAC 11 is maintained. More info about this provider can be found at the Microsoft product page.
Ms Sql Odbc Driver Download
During my recent conversation about Oracle linked server with one of my client, I learned something new about “Microsoft OLE DB Provider for Oracle”. This blog has highlights of a lengthy conversation.
- ODBC drivers shipped with SNAC for SQL Server 2005 through SQL Server 2012. After SQL Server 2012, ODBC Drivers have shipped individually and contain support for new SQL Server features. For new development, avoid using ODBC drivers from the first two phases, and use ODBC drivers from the third phase.
- OLE DB Driver 18 for SQL Server At the time of writing, the OLEDB driver 18 is the latest driver. Even though the version is one higher, the feature set is equivalent to the ODBC Driver 17 for SQL Server. The connection string looks like this.
- Microsoft OLE DB Driver 18 for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to Microsoft SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, Analytics Platform System, Azure SQL Database and Azure SQL Data Warehouse.
- The OLE DB Driver for SQL Server is a stand-alone data access application programming interface (API), used for OLE DB, that was introduced in SQL Server 2005 (9.x). OLE DB Driver for SQL Server delivers the SQL OLE DB driver in one dynamic-link library (DLL).
- MSDAORA is short form for “Microsoft OLE DB Provider for Oracle”.
- MSDAORA is driver provided by Microsoft to connect to Oracle database server.
- There is no 64-bit version provided by Microsoft for MSDAORA. Its only available for 32 bit.
- MSDAORA is no longer supported by current versions of Oracle. It was last updated for Oracle 9, and is no longer being updated.
- For 64 bit, we need to download and use the Oracle client and the provider from their site for connecting with SQL. Oracle has a 64-bit version that is usable for us.
- Oracle is a provider which is supported by Oracle.
Here is a snip from one of Microsoft connect item.
If you are using Oracle data sources, you should migrate to the Oracle-supplied provider and driver. Microsoft OLEDB Provider for Oracle (msdaora.dll) and Microsoft ODBC driver for Oracle (msorcl32.dll) are built by using Oracle Call Interface (OCI) version 7. Oracle no longer supports applications that use OCI version 7 calls, and these technologies are deprecated.
Now you may ask, how do I get 32-bit version? Well, it’s already available as a part of the operating system. You can do that by creating a UDL file as suggested in the link and opening it via 32-bit command prompt. Hopefully you know that there are two cmd.exe on 64-bit machine, one is under C:WindowsSystem32 and another is under C:WindowsSysWOW64.
I have created a UDL file and opened via both commands prompts.
As we can see above, we can see provider under 32 bit but not 64 bit.
Hopefully this blog would help you in getting the common question which I found is very difficult to search and get answer.
Ole Db Driver For Sql
Reference: Pinal Dave (https://blog.sqlauthority.com)