应用程序池回收后重新建立 ODBC 连接
我有一个 Web 服务应用程序，它通过 odbc sql 本机客户端和 SQL Server 驱动程序连接到数据库。突然，应用程序停止连接到数据库并抛出错误 08001。但是当我执行应用程序池回收时，它开始工作。现在它断断续续地发生，让我很头疼。这不可能是内存问题，因为它在应用程序池回收一次后立即发生。但在又一次应用程序池回收后，agian 得到了纠正。我不知道发生了什么，因为没有错误日志给出任何线索:(。请帮助我......
I have a web service application which connects to databases through odbc sql native client and SQL Server drivers. all of a sudden the application stopped connecting to the database throwing the error 08001. But when i did the application pool recycle it started working. Now it is happening intermittently and became a headache for me. It cant be a memory problem as it happened immediately after app pool reclycle once. but agian got corrected after one more app pool recycle. i dont know what is happening as none of the error logs give any clue:(. Please help me...
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
第一步是能够诊断正在发生的事情。你无法修复你无法衡量的东西。为此，我将在驱动程序的数据源控制台中启用池化，然后将计数器添加到性能监视器以查看连接池正在做什么。
我不确定 IIS 应用程序位置池进程和 odbc 连接之间的关系是什么，但我们在该区域看到了一些意外的行为。如果我通过本地安装的控制台应用程序连接到驱动程序，则 odbc 连接性能计数器也是可见的，但我看不到通过 IIS 中的 Web 服务应用程序池建立的连接的任何性能计数器活动？奇怪的！？
the first step is to be able to diagnose what is going on. You cannot fix what you cannot measure. To do this I would enable pooling in the data source console for the driver, then add the counters to the performance monitor to see what the connection pool is doing.
I'm not sure what the realtionship between IIS applocation pool processes and odbc connections is but we are seeing some unexpected behaviour in this area. Also the odbc connection performance counters are visible if I connect to the driver through a locally installed console application but I cannot see any performance counter activity for connections made via the web service app pool in IIS? ODD!?