Geek Answers Handbook

Is there a 64-bit msdasql for Windows 7?

I am using Windows 7 (x64bit) Ultimate.

I have both ODBC32 and ODBC64 managers with which I can access through Start. The default is ODBC64.

However, I do not see MSDASQL - Microsoft OLEDB for ODBC.

I wonder if it exists. I see some links to 64Bit MSDASQL for Windows Server 2003. IBM 64bit for ODBC seems to work (I heard), but haven't tried it. Now, I would like to know if anyone knows the link to 64-bit MSDASQL for Windows 7. Microsoft seems to have outdated MSDASQL, and I'm not sure about the status of this story.

These issues occurred when configuring a linked server in SQL Server 2012 for SQL Server (SAP) SqlAnywhere.

+2
odbc
source share
2 answers

I'm not sure how I missed. This link allows you to download the Redistributable Microsoft Access Database Engine 2010 http://www.microsoft.com/en-us/download/details.aspx?id=13255 Details of this indicate both ODBC and OLEDB as copied from the Microsoft website : "This download will install a set of components that will facilitate the transfer of data between existing Microsoft Office files, such as Microsoft Office Access 2010 (* .mdb and .accdb) and Microsoft Office Excel 2010 (.xls, * .xlsx and *. xlsb) to other data sources, such as Microsoft SQL Server, also supports the ability to connect to existing text files. ODBC and OLEDB installed application drivers A great way to develop applications with the ability to connect to Office file formats. "

+2
source share

On Windows 7, the MSDASQL x64 bit is missing. In Windows Server 2003, it is one. Finally, I was able to create a linked server in SQL Server 2012 Express using SAOLEDB.16 from Sybase / SAP.

Although I myself answered that MSDASQL (x64) does not exist based on some of the "deprecated elements" that I am still considering.

Here is a link to the same question on MSDN:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/3c715023-4322-4bc6-a2c8-64a873f87e46/can-someone-confirm-the-architecture-of-this-file-precond-microsoft- guys? forum = sqldatabaseengine # db5ed4e2-2391-4062-b34d-1f1b11431e1e

0
source share

More articles:


All Articles