使用ASP.NET我需要更新Excel模板。
using ASP.NET I need to update an excel template.
我们的服务器运行的是Windows 2008在64位模式。
Our server is running Windows 2008 in 64 bit mode.
我使用下面的code来访问Excel文件:
I am using the following code to access the excel file:
...
string connection =
@"Provider=MSDASQL;Driver={Microsoft Excel Driver (*.xls)};DBQ=" + path + ";";
...
如果应用程序池设置为启用32位应用程序的code按预期工作;不过,我现在用的是Oracle驱动程序失败,因为它只有64位。
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.
如果启用32位应用程序设置为false Excel的code失败,错误:
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
有什么建议?
Microsoft Office团队刚刚的发布 64位驱动程序
The Microsoft Office team has just released a 64-bit driver
下一篇:结合3D / 2D绘图