Excel ODBC和64位服务器 [英] Excel ODBC and 64 bit server
问题描述
我们的服务器以64位模式运行Windows 2008。
我使用以下代码访问excel文件:
...
string connection =
@Provider = MSDASQL; Driver = {Microsoft Excel Driver(* .xls)}; DBQ =+ path +;;
...
如果应用程序池设置为启用32位应用程序的代码工作如预期;然而,我使用的oracle驱动程序失败,因为它只有64位。
如果启用32位应用程序设置为false,则excel代码失败,出现错误: p>
未找到数据源名称,未指定
默认驱动程序
任何建议?
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?
The Microsoft Office team has just released a 64-bit driver
这篇关于Excel ODBC和64位服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!