间歇性SQL Server ODBC超时已过期 [英] Intermittent SQL Server ODBC Timeout expired

问题描述

我们有一堆VB6应用程序，它们访问两个不同的数据库服务器(两个32位Windows 2003，一个SQL Server 2000，一个SQL Server 2005).大约每十分钟左右，我们会出现一些错误:

We have a bunch of VB6 applications that access two different database servers (both 32-bit windows 2003, one SQL Server 2000, one SQL Server 2005). About every ten minutes or so, we are getting a few errors:

[Microsoft] [ODBC SQL Server驱动程序]超时已过期 [Microsoft] [ODBC SQL Server驱动程序] [DBNETLIB] SQL Server不存在或访问被拒绝. [Microsoft] [ODBC SQL Server驱动程序] ConnectionRead()

[Microsoft][ODBC SQL Server Driver]Timeout expired [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. [Microsoft][ODBC SQL Server Driver]ConnectionRead()

随机出现在十几台不同的计算机上.我们也有IP电话，它们都通过同一网络运行，并且没有任何问题.我们也可以将VNC插入用户计算机并重现他们遇到的错误，但是VNC仍然可以正常工作.电子邮件也可以.似乎是导致该问题的与SQL Server的ODBC连接.这些错误都发生在我们的两个SQL Server上.我们已经搜索了谷歌，但还没有提出解决方案.有什么我们可以尝试诊断的问题?有没有解决办法?

This is happening on more than a dozen different computers at random times. We also have IP phones that all run through the same network and those are not having any problems. We can also VNC into a users computer and reproduce the error they were getting, but VNC still continues to work. Email also works. It just seems to be an ODBC connection to SQL Server that causes the issue. The errors happen for both of our SQL Servers. We have scoured google, but haven't been able to come up with a solution. Is there anything we can try to diagnose the problem? Is there any fix out there?

我们在服务器或客户端上都没有内部防火墙.我们通过服务器的dns名称通过TCP/IP连接(也尝试使用IP地址).

We have no internal firewalls on either the servers or clients. We connect through TCP/IP via the dns name of the server (also have tried IP address).

一台服务器装有Windows 2003 SP2，另一台没有.

One server has Windows 2003 SP2 and the other doesn't.

奇怪的是，它已经运行了好多年，现在突然出现了这些错误.这些服务器在相当长的时间内没有任何变化.这使我们相信这是一个不好的选择，但似乎不太可能，因为其他任何东西(电子邮件，电话，vnc，文件服务器等)都可以正常工作.

The strange thing is that it has worked fine for years and now all of a sudden these errors are happening. Nothing has changed on those servers for quite some time. That leads us to beleive it is a bad switch, but that seems unlikely since nothing else (email, phones, vnc, file server, etc) all work without problems.

推荐答案

我们从未弄清楚为什么会发生这种情况.我们已将服务器升级到SQL Server 2008，并且错误消息停止了.

We never did figure out why this was happening. We upgraded our server to SQL Server 2008 and the error messages stopped.

这篇关于间歇性SQL Server ODBC超时已过期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！