Excel ODBC and 64 bit server

excel 64-bit odbc windows-server-2008 32-bit
Ris Adams picture Ris Adams · Dec 8, 2008 · Viewed 66k times · Source

using ASP.NET I need to update an excel template.

Our server is running Windows 2008 in 64 bit mode.

I am using the following code to access the excel file:

    ...
    string connection = 
@"Provider=MSDASQL;Driver={Microsoft Excel Driver (*.xls)};DBQ=" + path + ";";
    ...

IF the application pool is set to Enable 32 bit applications the code works as expected; however the oracle driver I am using fails as it is only 64 bit.

If Enable 32-bit applications is set to false the excel code fails with the error:

Data source name not found and no default driver specified

Any suggestions?

Answer

Matthew Skelton picture Matthew Skelton · May 11, 2010

The Microsoft Office team has just released a 64-bit driver

Related questions

How should I make my VBA code compatible with 64-bit Windows?

I have a VBA application developed in Excel 2007, and it contains the following code to allow access to the ShellExecute function from Shell32.dll: Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As …

Read More
Excel VBA Code: Compile Error in x64 Version ('PtrSafe' attribute required)

I am using Win8 x64 + Office 2013 x64. MY PROBLEM: I have an excel file, which has some modules in it, and works flawlessly in Office (Excel) x86. It uses the Swiss Ephemeris file (swedll32.dll) to do a lot of …

Read More
Excel 2013 64-bit VBA: Clipboard API doesn't work

I used to be able to use Windows API calls in Excel VBA to set text on the clipboard. But ever since upgrading to 64-bit Office 2013, I cannot. Below is some code that does not error, but it is also …

Read More