在sql server 2000 8.00.194上的选择查询期间连接超时已到期 [英] Connection timeout expired during select query on sql server 2000 8.00.194

问题描述

我正在尝试使用select查询从Lan上的sql server 2000 8.00.194获取数据，我得到错误！[在此输入图像描述] [1]。根据@rebarry young [解决方案] [2]它可能是内存问题。



因此尝试使用Management Studio执行相同的查询，并且它没有任何错误。相同的查询在我的早期版本的项目中有效。我不知道应该朝哪个方向垂头丧气。在con.open（）期间抛出异常。





[1]：http：//i.stack.imgur.com /veZ6t.png

[2]：http：//stackoverflow.com/questions/22491283/how-to-prevent-query-timeout-expired-sqlncli11-error-80040e31

I am trying to fetch data from sql server 2000 8.00.194 on Lan using select query and i get error ![enter image description here][1]. According @rebarry young [Solution][2] it can be memory issue.

So tried executing same query using Management Studio and it worked without any error. Same query is working in my early versions of projects. I don't know in which direction should hang my head. Above exception is thrown during con.open().


[1]: http://i.stack.imgur.com/veZ6t.png
[2]: http://stackoverflow.com/questions/22491283/how-to-prevent-query-timeout-expired-sqlncli11-error-80040e31

推荐答案

http://stackoverflow.com/问题/ 15488922 / connection-to-sql-server-works-useful [ ^ ]



试试这个

http://stackoverflow.com/questions/15488922/connection-to-sql-server-works-sometimes[^]

Try this

这篇关于在sql server 2000 8.00.194上的选择查询期间连接超时已到期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！