ASP.NET应用程序无法找到或连接到64位Oracle驱动程序的DSN，但未找到错误的数据源名称(ASP.NET application is not able to find or connect

ASP.NET应用程序无法找到或连接到64位Oracle驱动程序的DSN，但未找到错误的数据源名称(ASP.NET application is not able to find or connect to DSN of 64 bit Oracle Driver with error Data source name not found)

我开发了ASP.Net应用程序，它通过DSN连接使用ODBC连接到Oracle数据库。 一切都在我的本地开发环境中工作，但在我部署到IIS后，它无法连接到数据库和日志以下错误。

***[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified***

然后我开始寻找解决方案，尝试下面的东西但没有任何效果。

检查应用程序是使用Platform Any CPU开发的。

DSN使用Oracle客户端64位ODBC数据源进行配置和测试连接。 在64位服务器上，DSN也可以配置为64位和32位。

试图在注册表中为apppool身份用户设置DSN权限。 尝试将AppBool设置为启用32Bit应用程序为True，在这种情况下，它会给出ODBC和应用程序架构不匹配的另一个错误。

如果有更多替代方案，请告诉我，否则我正在考虑安装32位oracle客户端并尝试使用32位ODBC DSN进行连接。

感谢您的帮助。

I have developed ASP.Net application which is connecting to Oracle Database using ODBC via DSN connection. Everything works on my local development environment but after I deployed in IIS, it is unable to connect to database & logs below error.

***[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified***

Then I started looking for solution & tried below things but nothing worked.

Checked the application is developed using Platform Any CPU.

DSN is configured & Tested Connection using Oracle client 64 bit ODBC Data Source. On 64 bit server DSN can be configured for 64 bit & 32 bit also.

Tried with setting permissions to DSN in registry for the apppool identity user. Tried AppPool Setting for Enable 32Bit Application to True, in this case it give another error that ODBC & application architecture mismatch.

Please let me know if any more alternative is there, otherwise I am thinking of installing 32bit oracle client & try to connect using 32bit ODBC DSN.

Thanks for your help in advance.

最满意答案

发现此链接非常有帮助。 https://support.microsoft.com/en-in/kb/942976它说明了32位和64位应用程序的DSN连接的可见性。 尝试使用小型测试实用程序（winform），可以区分32位和64位应用程序的行为。 但无法找到ASP.Net应用程序的解决方案。

I have built the code using X64 platform & then deployed it in IIS. I was using 11.2.0 client so it started reading the DSN but Arithmetic operation resulted in an overflow exception. This is issue in the driver need to install the patch. https://blogs.msdn.microsoft.com/mariae/2012/07/05/arithmetic-operation-resulted-in-an-overflow-error-running-a-report-that-uses-a-connection-data-source-to-oracle-10/