64-Bit OLEDB MSDAC for Windows Server 2008

Question

For some reason I've to use OLEDB to integrate Access, Excel and text data in my 64-Bit application on Windows Server 2008.
No way to run it as 32-Bit.
For Windows 2003 Server there is now an addon / fix  available:


64-Bit OLEDB Provider for ODBC (MSDASQL)
http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

But I can't install this

WindowsServer2003.WindowsXP-KB948459-v2-x64-ENU.exe

on Windows 2008 Server (Error Message)

Any ideas, to bring 64-bit OLEB to live on Windows 2008 Server?

Cheers, Frank

---

Frank

Answer 1

Hi, It's not necessary to install the package on Windows 2008 Server. Actually, on Windows 2008 server, 64bit MSDASQL is in band in OS. You can use it directly without installing any package. detais here:
http://blogs.msdn.com/data/archive/2008/04/07/64-bit-oledb-provider-for-odbc-msdasql-is-now-available-for-windows-server-2003.aspx

Answer 2

Leo was quicker :-)

But as he says, it is delivered with the OS (Windows 2008 + Vista SP1).
You'll find it here:

C:\Program Files\Common Files\System\Ole DB

//Michael

---

This posting is provided "AS IS" with no warranties.

Answer 3

Hi fd2007,
Please read the end of that document http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

The document has explain that 64bit MSDASQL already shipped with vistasp1 and windows server 2008.
At a 64bit windows 2008, you will find them as follow,

32bit msdasql : %CommonProgramFiles(x86)%\System\Ole DB\msdasql.dll
64bit msdasql: %CommonProgramFiles%\System\Ole DB\msdasql

Answer 4

Thanks Leo, Michael, Gabriel for quick reply, but it doesn't solve my problem:

If open the ODBC configuration of my windows 2008 server system, no other driver is listed (SQL Server only).
Something wrong with installation? Is it an additional installation option for Windows 2008 Server?

If i try to use some OLEDB driver in a connecttion string a get the error message:

 The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

The same with other providers. What connection string / Provider name I shoud use, to connect to some Access accdb?

Sorry for stupid questions, but all this works fine with 32-bit...

Thanks, Frank

---

Frank

Answer 5

64-bit MSDASQL can only be used with 64-bit ODBC drivers.

Since there were no 64-bit ODBC drivers shipped for MS Access (the latest ACE driver is also 32-bit only), 64-bit MSDASQL is not a solution for your problem.

Therefore, if you are going to develop an application to access the MS Access data, you have to write 32-bit application.
(Please note that 32-bit application can be run under the WOW64 mode in a 64-bit windows server.)

So, you may need to recompile your application as a 32-bit application, and then your problem can be solved.

====
btw, you have to use c:\windows\syswow64\odbcad32 to display a list of 32-bit ODBC drivers, say MS Access driver.

Thanks,
Ming.
WDAC Team, Microsoft.

---

Pak-Ming Cheung - MSFT

Answer 6

Sorry, I didn't notice it was Access, Excel and text. As Ming mentioned, there is no 64bit ODBC drivers for Access, Excel and text. you may either still use 32 bit or move to .Net.

Answer 7

Thanks again for quick reply.

As I understand the discussion there is no chance for me to get it. I have to do the data access from a 64-bit web application (yes, its SharePoint). No way to recompile ;-) or change to 32-Bit in web application settings.

But, btw. how all the data integration services (SQL Server, BizTalk etc.) do this job in 64-Bit? I cannot believe, that Microsoft doesn't offer 64-bit access to all this office data. What about 64-Bit Office Versions?

unhappy: Frank

---

Frank

Answer 8

Be happy, Frank. :)
Sorry to make you unhappy. Microsoft offer 64 bit access to office data via .NET. For native APIs, it's ture, that there is no 64 bit driver for Access, Txt as well as Excel. However, for SQL Server there is 64bit driver.
One workaround is that you can try to find 3rd party 64 bit driver for those data source. Or there leaves no choice but using 32bit. Note you cannot load a 32bit driver from a 64bit Applicaiton.

Answer 9

Did you read the thread: http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/d75475e8-e283-4cbc-9d87-e2c438cb5b65?prof=required, which mentioned that x86 applications can be run under 64-bit sharepoint. Please see the post by "Qasem Elmogy" at April 22, 2009 6:34 AM.

This can be done by setting "Enable 32-bit Application" to TRUE in the APP Pool property.

I personally did not try this before. But it seems that there were some people can make this work. Therefore, this is a good try.

Cheer,
Ming.
WDAC Team, Microsoft.

---

Pak-Ming Cheung - MSFT