Connection timeout expired during select query on sql server 2000 8.00.194

See more:

SQL

SQL-Server

connection

, +

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