Excel ODBC and 64 bit server
Posted
by Causas
on Stack Overflow
See other posts from Stack Overflow
or by Causas
Published on 2008-12-08T20:54:57Z
Indexed on
2010/03/25
22:43 UTC
Read the original article
Hit count: 339
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?
© Stack Overflow or respective owner