Data Access and ObjectDataSource Control

Re: Connect to Excel. Using x64 (64-bit) platform. Compiled as x64.

KBJensen — Tue, 27 May 2008 08:45:12 GMT

Download link: 64-Bit OLEDB Provider for ODBC (MSDASQL)

http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

/ Klaus Bjørn Jensen

Re: Connect to Excel. Using x64 (64-bit) platform. Compiled as x64.

sapnam — Fri, 16 May 2008 19:29:28 GMT

i am using windows server 2008. I read that 64bit oledb drivers are now available.

Where can i download them from.I checked the ODBC panel of my server 2008, there are no drivers there.

Any help would be highly appreciated.

Regards,

Sapna

Re: Connect to Excel. Using x64 (64-bit) platform. Compiled as x64.

Kevin Yu - MSFT — Mon, 02 Jul 2007 03:55:21 GMT

Hi,

Since there are no 64-bit OleDb drivers for anything other than SQL Server, therefore, we cannot write 64-bit apps which interface with databases directly.

What you need to do is split your application into a 32 bit part and a 64 bit part, use COM interop to cross the 64/32 bit boundary. For instance, drop the code (just a simple class library compiled as 32 bit) that retrieves the Excel data into a COM+ (System.EnterpriseServices) as a "server type" application, and call that server methods from your 64 bit Windows service. This is exactly why System.EnterpriseServices are made for.

There is already request sent to the product group to ask for 64-bit JET provider for x64 OS. You can check the following link for more information.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125117

If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

Connect to Excel. Using x64 (64-bit) platform. Compiled as x64.

WebMaster Mark — Sat, 30 Jun 2007 15:31:00 GMT

Hello,

Has anybody susessfully connected to Excel from an ASP.NET Website that is running on X64 platform?

The only solution I have found is to convert my website to a Web Apllication Project and then complie the application as a 32-bit application.

This is only a very small part of a much larger application so I do not want to complie the whole thing as a 32 bit application.

If anybody has susessfully connected to Excel from an ASP.NET Website that is running on X64 platform, please can you tell me how you did it?

Thanks,

Mark.