'General Network Error' when reading large table

  • Thread starter Thread starter =?iso-8859-1?Q?Johan_Norm=E9n?=
  • Start date Start date
?

=?iso-8859-1?Q?Johan_Norm=E9n?=

Hi,

How does you Select querylook like? Do you use any Order
by? if not does it work if you add the order by in your
Sql query?

JN
NSQUARED2
 
Hi, ok...

I never got this problem. But when I read some of the
post with problems like yours I think it's related to the
query. I never use syntax like this XpUser.* will you
still have the problem if you change this to * only?

It's the only thing that differ from my Selects.
If you stil got the same problem I have no clue. I saw
something about setting the Pool to false have you ried
that too?

JN
NSQUARED2

-----Original Message-----
Hi,

I have seen this suggestion in a post and added the ORDER
BY, but no success. My query is:
SELECT XpUser.*
FROM XpUser
WHERE (XpUser.SipEnabled = 1) AND
(XpUser.Orphaned = 0)
ORDER BY NTLoginName

Thanks,
Peter
-----Original Message-----
Hi,

How does you Select querylook like? Do you use any Order
by? if not does it work if you add the order by in your
Sql query?

JN
NSQUARED2
-----Original Message-----
Hi,

I am reading a table in SQL server using ADO.NET's SQL
provider and get a 'General Network Error' SqlException.
But I only get this error when reading more than ~100
rows. Reading less than 100 or single rows works fine.
Also this only happens when reading from certain remote
servers.
SqlServer: W2003, Sql 2000 SP3, Framework V1.1
Client Server: W2000, Framework V1.1

After searching the web I found a few posts with the same
problem stating this to be a ADO.NET error, but found no
clear answer or solution.

Does anybody have more info on this?

Exception:
System.Data.SqlClient.SqlException: General network
error. Check your network documentation.
at System.Data.SqlClient.SqlConnection.OnError
(SqlException exception, TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError
(SqlException exception, TdsParserState state)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarnin
Click to expand...
g
()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32
bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByteArray (Byte
[] buff, Int32 offset, Int32 len)
at System.Data.SqlClient.TdsParser.ReadString(Int32
length)
at System.Data.SqlClient.TdsParser.ReadValue
(_SqlMetaData md, Int32 length)
at System.Data.SqlClient.SqlDataReader.SeqRead (Int32
i, Boolean useSQLTypes, Boolean byteAccess, Boolean&
isNull)
at System.Data.SqlClient.SqlDataReader.SeqRead (Int32
i, Boolean useSQLTypes, Boolean byteAccess)
at System.Data.SqlClient.SqlDataReader.GetValues (Object
[] values)
at System.Data.Common.SchemaMapping.LoadDataRow
(Boolean clearDataValues, Boolean acceptChanges)
at System.Data.Common.DbDataAdapter.FillLoadDataRow
(SchemaMapping mapping)
at System.Data.Common.DbDataAdapter.FillFromReader
(Object data, String srcTable, IDataReader dataReader,
Int32 startRecord, Int32 maxRecords, DataColumn
parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DbDataAdapter.Fill(DataTable
dataTable, IDataReader dataReader)
at System.Data.Common.DbDataAdapter.Fill(Object data,
Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable
dataTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable
dataTable)

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top