Migrating OLE DB connection to ODBC
Microsoft has released Cumulative Update #2 for SQL Server 2012 service pack 1 today. There are new fixes introduced in this and it contains roll up fixes for CU5. I am just updating you with the latest SQL Server updates news here. But, the main blog post is given below.
Microsoft also introduced new ODBC drivers for Linux and Windows today. It is a great effort from Microsoft to provide cross-platform support for SQL Server. Now, Application running the Linux can smoothly access the SQL Server using Microsoft ODBC Driver 11 for SQL Server on Linux.
- Linux ODBC driver name has renamed from Microsoft SQL Server ODBC Driver 1.0 for Linux.
- Microsoft ODBC Driver 11 for SQL Server on Windows is a combination of SQL Server Native Client (SNAC) and ODBC functionalists.
You may ask me, why do I care about all these changes? There is an important point behind all these changes happening now. Because, Microsoft has announced in the year 2011 about the deprecation of the “SQL Server OLE DB provider. SQL Server 2012 is the last version that supports “SQL Server OLE DB provider” then it will be a deprecated provider. But, Microsoft will support this provide till the Microsoft Support Lifecycle. – Reference
Why do we need ODBC?
ODBC is the native relational data access connector. It supports all platform and make the data access seamless for application. It also supports cloud data platform on SQL Azure. The key feature is ODBC contains set of APIs that are available on all platforms including non-Windows platforms.
IT is moving towards cloud based environment and we need a strongly supported cross-platform data connectivity component like ODBC.
Microsoft has provided data access connector for enterprise class application platform such as Java and PHP.
Tracking ODBC announcements and Enhancements:
- Microsoft is Aligning with ODBC for Native Relational Data Access – August 2011
- Introducing the new Microsoft ODBC Drivers for SQL Server
I know, you may have a lot of questions about New ODBC. Some of the your questions are already answered there. So, Go to SQL Data Access forum.