General network error. Check your network document

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

General network error. Check your network document

Author

Topic

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-10-01 : 07:50:19

Hi Guys, I am firing thf ollowing query and it's giving me the error and idea or suggestions. What could be the reason

Query
select * from mt940 where mq_no in (72097,
72103,72109,72117,72124,72131,72137,72144,72145,72154,72159,72164,
72098,72104,72110,72118,72125,72132,72138,72146,72155,72160,72165,
72166,72213,72561,72562,72563,72656,72659,72662,72663,72664,72665,72666,72667,72668,69673,69674,.........continues till 90001,
90002,90003)

ERROR :
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken

Please help

SQL IN Minds

Kristen
Test

22859 Posts

Posted - 2007-10-01 : 07:56:24

Sounds like its timing out because you have an extremely long list. (Is it a REALLY long list?)

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-10-01 : 12:28:04

Yes it's really a long list. Could you suggest me some solution. Should i have to change my query to fetch the same records if how it should be... Please help to resolve this issue

SQL IN Minds

Kristen
Test

22859 Posts

Posted - 2007-10-01 : 12:30:24

Insert the IDs into a table, and JOIN that, instead of passing them as an IN list.

Kristen

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-10-01 : 14:14:07

Could you give any example

SQL IN Minds

Kristen
Test

22859 Posts

Posted - 2007-10-01 : 14:33:53

Are you serious?