][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).

Question

Post reply

][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).

sivaprasad

SSCertifiable

Points: 6183
More actions
May 31, 2006 at 7:12 am

#115436

Getting below error message when running a simple select to a table from Query analyser 2000 to a SQLServer 2000 running with SP4.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (InvalidParam()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken

Any one faced this error? Any advise please,
Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

It looks like you have a few posts out here that are very similar to this one, but with different error messages.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=283862

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=283864

Are you getting all three of these errors on the same SELECT? Can you post your SELECT statement? Are you using QA from the Server or from a workstation? Does this work from a different machine? Are you using Windows authentication or SQL Server?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

ram4tech Hall of Fame Points: 3140 More actions · Answer 2

Hi Siva,

What's the syntax of the SELECT.

Here are couple threads where similar problem was discussed,

http://www.dbforums.com/archive/index.php/t-929535.html

http://www.mcse.ms/archive81-2005-3-1512945.html

HTH

-R

sivaprasad SSCertifiable Points: 6183 More actions · Answer 3

Ram,

Refered the links

http://www.dbforums.com/archive/index.php/t-929535.html

http://www.mcse.ms/archive81-2005-3-1512945.html

It does not answer the problem.

John,

That is simple 'select statement againt a table', not even where clause being used. The table has arround 40000 records.

HTH

Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

babuganesh2000 Hall of Fame Points: 3123 More actions · Answer 4

On the Database Server

Right Click MyNetworkPlaces -> Properties

Right Click Local Area Connection -> Properties

Select Internet Protocol(TCP/IP) -> Configure

Go to Advanced Tab -> Speed & Duplex

If the value is "auto"

Set the Value to -> 100mb full

It resoved my problem, hope it does for you too.

Thanks,

Ganesh