64-bit OLEDB Provider for ODBC (MSDASQL) Available in Longhorn Server, Starting Beta 3
We’re pleased to announce that Longhorn Server Beta 3 will include a 64-bit version of MSDASQL, Microsoft’s OLEDB Provider for ODBC.
What is MSDASQL?
MSDASQL is an OLEDB provider that allows applications built on OLEDB and ADO (which uses OLEDB internally) to access data sources through an ODBC driver instead of a database. MSDASQL ships with the Windows Operating System, and Longhorn Beta 3 is the first Windows release to include a 64-bit version of MSDASQL.
Who does this impact?
If you are a customer in one of the following scenarios, you will see direct benefits from this technology when upgrading to or deploying Longhorn Server:
· SQL Server Customers with Heterogeneous DBMS Environments: the Linked Server and Distributed Query features of SQL Server connect to external data sources through an OLEDB provider. The addition of the 64-bit MSDASQL Provider allows these features to leverage the 64-bit equivalents of ODBC drivers that SQL Server applications of 32-bit environments are already using, and to use an ODBC 64-bit driver if a 64-bit OLEDB provider for the target external data source is not available.
· ADO and ASP Customers Planning a Migration to 64-bit: on 32-bit operating systems, MSDASQL is the default OLEDB provider used by ADO. In Longhorn Server Beta 3, applications that specify an ODBC driver in the connection string (e.g. “Driver={SQL Server}...”) are not required to change connection strings when migrating to 64-bit.
· Customers with OLEDB Applications Using ODBC Data Sources: when migrating these applications to 64-bit, the applications can leverage a native 64-bit ODBC driver, provided that one is available for the target data source.
Isn’t MSDASQL Deprecated?
Previous messaging on MSDN indicated that a 64-bit version of MSDASQL would not be available. However, we have received numerous requests from customers for this technology and we are making it available to address the pain experienced in the scenarios described above without 64-bit MSDASQL.
Mo Lin
Program Manager, Data Programmability
John Bocharov
Program Manager, Data Programmability
Comments
Anonymous
June 08, 2007
Hi Mo, Hi Jonh, good news! is it possible to use this driver for win2003 Server (64bit)? Regards. Kyryl RomanenkoAnonymous
July 05, 2007
Excellent! I hope this driver will be available for Windows 2003 Server as well! We have to import data from Excel and this functionality is very important for us. We have moved to 64-bit and now we need a 32-bit server to select from the excel-file and into a table on the 64-bit server. Espen Antonsen System Developer 24SevenOfficeAnonymous
July 19, 2007
This great news. We have been really stressed. We need to be able to import data from an HP NonStop to our SQL Server data warehouse. We too would like to have MSDASQL available for Windows 2003 Server. The sooner the better!Anonymous
July 23, 2007
This is great news but is there going to be a MSDASQL release for Server 2003?? As most people who fall into the "numerous requests" seem to be running this os.Anonymous
July 30, 2007
Is it availble for Windows 2003 R2Anonymous
August 21, 2007
>Is it availble for Windows 2003 R2 Where we can find THAT?Anonymous
August 22, 2007
Hi, is this available to download as a seperate install? I need to use this on my current installation of windows 2003 x64Anonymous
September 04, 2007
Just installed longhorn beta 3 and I do not see the MSDASQL.dll. Am I missing something?Anonymous
September 27, 2007
How can i receive this beta version ?Anonymous
October 28, 2007
I trust this will also be in vista SP! 64 bit edition too. I also concurr that the next Server 2003 service PAK for 64 bit shoudl also have this. this is very very good news. RegardsAnonymous
November 15, 2007
We could use this also in our win 2003 x64 now. Could you advise if it is or is not avail as a separate download or can we get it from the Longhorn beta, or advise if its not compatabile with win 2003 x64? At least I'll know if I need tell my boss we need to get a workaround... thanks! "Hi, is this available to download as a seperate install? I need to use this on my current installation of windows 2003 x64"Anonymous
January 13, 2008
I don't see if the response for the question: Is it availble for Windows 2003 R2 ..... Can someone respond to thatAnonymous
January 22, 2008
I too urgently need this for our win2003 x64 environment. so far we have had move back to our old environment which is less than ideal. Come on Microsoft, shed some light on this please. ThanksAnonymous
January 24, 2008
Hello, Does this mean that the driver is available or will be availble? If it is available could some someone give me a link please. It would be of great help to me. thanksAnonymous
January 28, 2008
There is an installer for Itanium, but I didn't found a x64t OLEDB Provider for ODBC. Does any body found it?Anonymous
March 01, 2008
I too am desperate for a 64Bit OLE DB to ODBC driver. I am assuming that it will only access 64bit to 64 bit or will it be able to address 32bit ODBC System DSNs as well?Anonymous
March 06, 2008
Where can I download this 64-bit OLEDB Provider for ODBC? Windows Server 2008 has now been released so I would assume that Longhorn Beta 3 is long gone and therefore this OLEDB driver should be available. HELP!Anonymous
April 04, 2008
Can someone post a link here where I can download the update for Windows 2003 which will included the 64-bit MSDASQL? And also, if anyone has an anticipated release timeframe, that would be helpful too. The last estimate I received was by the end of March... Thanks!Anonymous
May 28, 2008
64-Bit OLEDB Provider for ODBC (MSDASQL) http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=enAnonymous
June 25, 2008
Thanks for the URL... I am back in businessAnonymous
November 25, 2008
There still is no drover for Windows 2003 R2 whats going on, surely it can't be that hard to sort this as well? :(Anonymous
August 26, 2009
I was wondering about the licensing requirements on the 64 bit msdasql.dll Can this be distributed with a non-microsoft product that runs on windows? Where can I find the license agreement that would clearly state whether the above is allowed or not. I have tried looking at the license agreement of the hotfix itself but says that it is a supplement to windows and that is not conclusive. Any pointer would be helpfulAnonymous
November 15, 2009
When will this be available for Windows 2008 Server?