Tuesday, July 21, 2009 2:07 PMFor 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)
But I can't install this
WindowsServer2003.WindowsXP-KB948459-v2-x64-ENU.exeon Windows 2008 Server (Error Message)
Any ideas, to bring 64-bit OLEB to live on Windows 2008 Server?
Tuesday, July 21, 2009 2:26 PMAnswererHi, 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:
Tuesday, July 21, 2009 2:31 PMLeo 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
This posting is provided "AS IS" with no warranties.
Wednesday, July 22, 2009 3:11 AMAnswererHi 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
Wednesday, July 22, 2009 8:49 AMThanks 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...
Wednesday, July 22, 2009 10:19 AMAnswerer64-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.
WDAC Team, Microsoft.
Pak-Ming Cheung - MSFT
Wednesday, July 22, 2009 12:16 PMAnswererSorry, 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.
Thursday, July 23, 2009 10:41 AMThanks 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?
Thursday, July 23, 2009 2:46 PMAnswerer
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.
- Marked As Answer by John C GordonMicrosoft Employee, Moderator Thursday, July 23, 2009 4:39 PM
Friday, July 24, 2009 6:42 AMAnswerer
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.
WDAC Team, Microsoft.
Pak-Ming Cheung - MSFT
- Proposed As Answer by Pak-Ming CheungMicrosoft Employee, Editor Friday, July 24, 2009 6:42 AM