Showing posts with label microsoft. Show all posts
Showing posts with label microsoft. Show all posts

Thursday, March 29, 2012

General network error. Check your network documentation.

Hi ,
I am getting following error . Can anyone help me on this ?
General network error. Check your network documentation.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlInternalConnection.Execut eTransaction(String
sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.BeginTransacti on(IsolationLevel iso)
at System.Data.SqlClient.SqlConnection.BeginTransacti on()
I would appreicate if anyone can help me on this ?
Jitesh k
Hi,
Are you using Windows Server 2003 on SQL?
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
> Hi ,
> I am getting following error . Can anyone help me on this ?
> General network error. Check your network documentation.
> at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
> TdsParserState state)
> at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
> exception, TdsParserState state)
> at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
> cmdHandler, SqlDataReader dataStream)
> at System.Data.SqlClient.SqlInternalConnection.Execut eTransaction(String
> sqlBatch, String method)
> at System.Data.SqlClient.SqlConnection.BeginTransacti on(IsolationLevel
> iso)
> at System.Data.SqlClient.SqlConnection.BeginTransacti on()
> I would appreicate if anyone can help me on this ?
> --
> Jitesh k
>
|||Hi Danijel,
O/s is windows 2000
and SQL server 2000 with sp3a
Jitesh k
"Danijel Novak" wrote:

> Hi,
> Are you using Windows Server 2003 on SQL?
> --
> Danijel Novak
>
> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
> news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
>
>
|||Hi,
I found this solution:
I have set the CommandTimeOut of my command object and I have added
Pooling=False in my connection string.
Hope it helps..
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:CD016A68-EFA0-42CF-9B08-B730C8FBDB36@.microsoft.com...[vbcol=seagreen]
> Hi Danijel,
> O/s is windows 2000
> and SQL server 2000 with sp3a
> --
> Jitesh k
>
> "Danijel Novak" wrote:
|||what does pooling=False does ?
will it degrade performance ?
Jitesh k
"Danijel Novak" wrote:

> Hi,
> I found this solution:
> I have set the CommandTimeOut of my command object and I have added
> Pooling=False in my connection string.
> Hope it helps..
> --
> Danijel Novak
>
> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
> news:CD016A68-EFA0-42CF-9B08-B730C8FBDB36@.microsoft.com...
>
>
|||Hi,
Pooling=false means that connection you're establishing is not pooled in
connection pool.
Yes, it could influence your performance as connection must be created again
and it is not drawn from pool.
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:BF4B56AE-5A61-4E95-92A1-090EA88B8A85@.microsoft.com...[vbcol=seagreen]
> what does pooling=False does ?
> will it degrade performance ?
> --
> Jitesh k
>
> "Danijel Novak" wrote:

General network error. Check your network documentation.

DTS Gurus !
We have a SQL 2000 package which uses a data driven query
which makes use of two stored procedures.
GETNeededRecords() and ProcessNeededRecords() with
transformations defined. Each record in the
result set returned by the GETNeededRecords is used by the
ProcessNeededRecords(). The Data Driven
step has a log file which logs the error messages.
Consistently the package fails reporting error
the below listed error. There is not enough we could find
online. Any help in this regard is
appreciated.
Command Error in Data Driven Query:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description:[DBNETLIB][ConnectionRead (recv()).]
General network error. Check your network documentation.
Error Help File:
Error Help Context ID:0
If the package is running on the same server, I dont
understand why there should be network error.
Would this have to do with the details talked about in the
article
http://support.microsoft.com/default.aspx?scid=kb;en-
us;827452&Product=sql2k
..
1. Please do a select * from this table, and preferably run a checktable on
this to make sure it's consistent.
2. If it is,hvae u tried reducing the number of rows/resultsets to be
processed? Same behaviour still?
3. Pls check the sql error logs and Event logs at the same time of DTS
failure.
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

General network error. Check your network documentation.

DTS Gurus !
We have a SQL 2000 package which uses a data driven query
which makes use of two stored procedures.
GETNeededRecords() and ProcessNeededRecords() with
transformations defined. Each record in the
result set returned by the GETNeededRecords is used by the
ProcessNeededRecords(). The Data Driven
step has a log file which logs the error messages.
Consistently the package fails reporting error
the below listed error. There is not enough we could find
online. Any help in this regard is
appreciated.
Command Error in Data Driven Query:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description:[DBNETLIB][ConnectionRead (recv()).]
General network error. Check your network documentation.
Error Help File:
Error Help Context ID:0
If the package is running on the same server, I dont
understand why there should be network error.
Would this have to do with the details talked about in the
article
http://support.microsoft.com/default.aspx?scid=kb;en-
us;827452&Product=sql2k
.1. Please do a select * from this table, and preferably run a checktable on
this to make sure it's consistent.
2. If it is,hvae u tried reducing the number of rows/resultsets to be
processed? Same behaviour still?
3. Pls check the sql error logs and Event logs at the same time of DTS
failure.
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.sql

General network error. Check your network documentation.

Hi ,
I am getting following error . Can anyone help me on this ?
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.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso)
at System.Data.SqlClient.SqlConnection.BeginTransaction()
I would appreicate if anyone can help me on this ?
--
Jitesh kHi,
Are you using Windows Server 2003 on SQL?
--
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
> Hi ,
> I am getting following error . Can anyone help me on this ?
> 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.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
> cmdHandler, SqlDataReader dataStream)
> at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> sqlBatch, String method)
> at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
> iso)
> at System.Data.SqlClient.SqlConnection.BeginTransaction()
> I would appreicate if anyone can help me on this ?
> --
> Jitesh k
>|||Hi Danijel,
O/s is windows 2000
and SQL server 2000 with sp3a
--
Jitesh k
"Danijel Novak" wrote:
> Hi,
> Are you using Windows Server 2003 on SQL?
> --
> Danijel Novak
>
> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
> news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
> > Hi ,
> >
> > I am getting following error . Can anyone help me on this ?
> > 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.ThrowExceptionAndWarning()
> > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> > at System.Data.SqlClient.TdsParser.ReadBuffer()
> > at System.Data.SqlClient.TdsParser.ReadByte()
> > at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
> > cmdHandler, SqlDataReader dataStream)
> > at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> > sqlBatch, String method)
> > at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
> > iso)
> > at System.Data.SqlClient.SqlConnection.BeginTransaction()
> >
> > I would appreicate if anyone can help me on this ?
> > --
> > Jitesh k
> >
>
>|||Hi,
I found this solution:
I have set the CommandTimeOut of my command object and I have added
Pooling=False in my connection string.
Hope it helps..
--
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:CD016A68-EFA0-42CF-9B08-B730C8FBDB36@.microsoft.com...
> Hi Danijel,
> O/s is windows 2000
> and SQL server 2000 with sp3a
> --
> Jitesh k
>
> "Danijel Novak" wrote:
>> Hi,
>> Are you using Windows Server 2003 on SQL?
>> --
>> Danijel Novak
>>
>> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
>> news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
>> > Hi ,
>> >
>> > I am getting following error . Can anyone help me on this ?
>> > 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.ThrowExceptionAndWarning()
>> > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
>> > at System.Data.SqlClient.TdsParser.ReadBuffer()
>> > at System.Data.SqlClient.TdsParser.ReadByte()
>> > at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
>> > cmdHandler, SqlDataReader dataStream)
>> > at
>> > System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
>> > sqlBatch, String method)
>> > at
>> > System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
>> > iso)
>> > at System.Data.SqlClient.SqlConnection.BeginTransaction()
>> >
>> > I would appreicate if anyone can help me on this ?
>> > --
>> > Jitesh k
>> >
>>|||what does pooling=False does ?
will it degrade performance ?
--
Jitesh k
"Danijel Novak" wrote:
> Hi,
> I found this solution:
> I have set the CommandTimeOut of my command object and I have added
> Pooling=False in my connection string.
> Hope it helps..
> --
> Danijel Novak
>
> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
> news:CD016A68-EFA0-42CF-9B08-B730C8FBDB36@.microsoft.com...
> > Hi Danijel,
> > O/s is windows 2000
> > and SQL server 2000 with sp3a
> >
> > --
> > Jitesh k
> >
> >
> >
> > "Danijel Novak" wrote:
> >
> >> Hi,
> >>
> >> Are you using Windows Server 2003 on SQL?
> >>
> >> --
> >> Danijel Novak
> >>
> >>
> >>
> >> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
> >> news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
> >> > Hi ,
> >> >
> >> > I am getting following error . Can anyone help me on this ?
> >> > 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.ThrowExceptionAndWarning()
> >> > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> >> > at System.Data.SqlClient.TdsParser.ReadBuffer()
> >> > at System.Data.SqlClient.TdsParser.ReadByte()
> >> > at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
> >> > cmdHandler, SqlDataReader dataStream)
> >> > at
> >> > System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> >> > sqlBatch, String method)
> >> > at
> >> > System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
> >> > iso)
> >> > at System.Data.SqlClient.SqlConnection.BeginTransaction()
> >> >
> >> > I would appreicate if anyone can help me on this ?
> >> > --
> >> > Jitesh k
> >> >
> >>
> >>
> >>
>
>|||Hi,
Pooling=false means that connection you're establishing is not pooled in
connection pool.
Yes, it could influence your performance as connection must be created again
and it is not drawn from pool.
Danijel Novak
"Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
news:BF4B56AE-5A61-4E95-92A1-090EA88B8A85@.microsoft.com...
> what does pooling=False does ?
> will it degrade performance ?
> --
> Jitesh k
>
> "Danijel Novak" wrote:
>> Hi,
>> I found this solution:
>> I have set the CommandTimeOut of my command object and I have added
>> Pooling=False in my connection string.
>> Hope it helps..
>> --
>> Danijel Novak
>>
>> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
>> news:CD016A68-EFA0-42CF-9B08-B730C8FBDB36@.microsoft.com...
>> > Hi Danijel,
>> > O/s is windows 2000
>> > and SQL server 2000 with sp3a
>> >
>> > --
>> > Jitesh k
>> >
>> >
>> >
>> > "Danijel Novak" wrote:
>> >
>> >> Hi,
>> >>
>> >> Are you using Windows Server 2003 on SQL?
>> >>
>> >> --
>> >> Danijel Novak
>> >>
>> >>
>> >>
>> >> "Jiteshk" <Jitesh.kannanchery@.igate.com> wrote in message
>> >> news:D67E3C3F-808E-499B-ABC5-111764DBBF57@.microsoft.com...
>> >> > Hi ,
>> >> >
>> >> > I am getting following error . Can anyone help me on this ?
>> >> > 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.ThrowExceptionAndWarning()
>> >> > at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
>> >> > at System.Data.SqlClient.TdsParser.ReadBuffer()
>> >> > at System.Data.SqlClient.TdsParser.ReadByte()
>> >> > at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
>> >> > cmdHandler, SqlDataReader dataStream)
>> >> > at
>> >> > System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
>> >> > sqlBatch, String method)
>> >> > at
>> >> > System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel
>> >> > iso)
>> >> > at System.Data.SqlClient.SqlConnection.BeginTransaction()
>> >> >
>> >> > I would appreicate if anyone can help me on this ?
>> >> > --
>> >> > Jitesh k
>> >> >
>> >>
>> >>
>> >>
>>

General network error. Check your network documentation ADO.Net error

Hi
I'm getting the General Network error, though not consistently. Stack
trace is below. Any fix for this?
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.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token)
at System.Data.SqlClient.TdsParser.ProcessColumnHeader(_SqlMetaData
col, Boolean& isNull)
at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
Object[] buffer, Int32[] map, Boolean useSQLTypes)
at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
Thanks
*** Sent via Developersdex http://www.examnotes.net ***"RJN" <rjn@.yahoo.com> wrote in message
news:Oj67JKhZGHA.3832@.TK2MSFTNGP04.phx.gbl...
> Hi
> I'm getting the General Network error, though not consistently. Stack
> trace is below. Any fix for this?
> 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.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token)
> at System.Data.SqlClient.TdsParser.ProcessColumnHeader(_SqlMetaData
> col, Boolean& isNull)
> at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
> Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
> at System.Data.SqlClient.SqlDataReader.get_Item(String name)
> Thanks
>
1. Don't multipost.
2. This is probably one of
-a network error
-SQL Server box Crashing
-A severity 20+ error in SQL Server.
So check the SQL Server logs.
David|||Hi David
Sorry for the multipost. Since they are different forums, I thought
chances of getting an answer are more.
Which log file should I check? The one under "Microsoft SQL
Server\MSSQL\LOG" ?
Thanks
*** Sent via Developersdex http://www.examnotes.net ***|||Read this KB Article
http://support.microsoft.com/defaul...Ben-us%3B821289 after
you are finished with the error logs
Nathan H. Omukwenyi
"RJN" <rjn@.yahoo.com> wrote in message
news:Oj67JKhZGHA.3832@.TK2MSFTNGP04.phx.gbl...
> Hi
> I'm getting the General Network error, though not consistently. Stack
> trace is below. Any fix for this?
> 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.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token)
> at System.Data.SqlClient.TdsParser.ProcessColumnHeader(_SqlMetaData
> col, Boolean& isNull)
> at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
> Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
> at System.Data.SqlClient.SqlDataReader.get_Item(String name)
> Thanks
>
> *** Sent via Developersdex http://www.examnotes.net ***

General network error. Check your network documentation - ADO.Net

Hi
I'm getting the General Network error, though not consistently. Stack
trace is below. Any fix for this?
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.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token)
at System.Data.SqlClient.TdsParser.ProcessColumnHeader(_SqlMetaData
col, Boolean& isNull)
at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
Object[] buffer, Int32[] map, Boolean useSQLTypes)
at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
Thanks
*** Sent via Developersdex http://www.codecomments.com ***Could you provide more information and maybe the code that throws that
exception because the error could occur for many reasons like:
When this happens, what is the state of your Sqlconnection object, your
physical network or the SQL Server computer?
You are trying to read the value of a column return by the Sqldatareader.
Does the column exist in the underlying datasource? What is the data type of
the column?
Nathan H. Omukwenyi
"RJN" <rjn@.yahoo.com> wrote in message
news:Ov80uEhZGHA.3480@.TK2MSFTNGP03.phx.gbl...
> Hi
> I'm getting the General Network error, though not consistently. Stack
> trace is below. Any fix for this?
> 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.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token)
> at System.Data.SqlClient.TdsParser.ProcessColumnHeader(_SqlMetaData
> col, Boolean& isNull)
> at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns
,
> Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
> at System.Data.SqlClient.SqlDataReader.get_Item(String name)
> Thanks
> *** Sent via Developersdex http://www.codecomments.com ***|||RJN,
If you have selected "Force Protocol Encryption" on your SQL Server "Server
Network Utility" (meaning you are using an SSL connection) and you are
connecting from the SqlClient in the .NET Framework version 1.0 or 1.1 then
this KB will be of help:
http://support.microsoft.com/defaul...Ben-us%3B821289
Nathan H. Omukwenyi
"RJN" <rjn@.yahoo.com> wrote in message
news:Ov80uEhZGHA.3480@.TK2MSFTNGP03.phx.gbl...
> Hi
> I'm getting the General Network error, though not consistently. Stack
> trace is below. Any fix for this?
> 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.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token)
> at System.Data.SqlClient.TdsParser.ProcessColumnHeader(_SqlMetaData
> col, Boolean& isNull)
> at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns
,
> Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
> at System.Data.SqlClient.SqlDataReader.get_Item(String name)
> Thanks
> *** Sent via Developersdex http://www.codecomments.com ***

General network error. Check your network documentation - ADO.Net

Hi
I'm getting the General Network error, though not consistently. Stack
trace is below. Any fix for this?
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.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token)
at System.Data.SqlClient.TdsParser.ProcessColumnHeader(_SqlMetaData
col, Boolean& isNull)
at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
Object[] buffer, Int32[] map, Boolean useSQLTypes)
at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
Thanks
*** Sent via Developersdex http://www.developersdex.com ***Could you provide more information and maybe the code that throws that
exception because the error could occur for many reasons like:
When this happens, what is the state of your Sqlconnection object, your
physical network or the SQL Server computer?
You are trying to read the value of a column return by the Sqldatareader.
Does the column exist in the underlying datasource? What is the data type of
the column?
Nathan H. Omukwenyi
"RJN" <rjn@.yahoo.com> wrote in message
news:Ov80uEhZGHA.3480@.TK2MSFTNGP03.phx.gbl...
> Hi
> I'm getting the General Network error, though not consistently. Stack
> trace is below. Any fix for this?
> 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.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token)
> at System.Data.SqlClient.TdsParser.ProcessColumnHeader(_SqlMetaData
> col, Boolean& isNull)
> at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
> Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
> at System.Data.SqlClient.SqlDataReader.get_Item(String name)
> Thanks
> *** Sent via Developersdex http://www.developersdex.com ***|||RJN,
If you have selected "Force Protocol Encryption" on your SQL Server "Server
Network Utility" (meaning you are using an SSL connection) and you are
connecting from the SqlClient in the .NET Framework version 1.0 or 1.1 then
this KB will be of help:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B821289
Nathan H. Omukwenyi
"RJN" <rjn@.yahoo.com> wrote in message
news:Ov80uEhZGHA.3480@.TK2MSFTNGP03.phx.gbl...
> Hi
> I'm getting the General Network error, though not consistently. Stack
> trace is below. Any fix for this?
> 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.ThrowExceptionAndWarning()
> at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
> at System.Data.SqlClient.TdsParser.ReadBuffer()
> at System.Data.SqlClient.TdsParser.ReadByte()
> at System.Data.SqlClient.TdsParser.GetTokenLength(Byte token)
> at System.Data.SqlClient.TdsParser.ProcessColumnHeader(_SqlMetaData
> col, Boolean& isNull)
> at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
> Object[] buffer, Int32[] map, Boolean useSQLTypes)
> at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
> at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
> at System.Data.SqlClient.SqlDataReader.get_Item(String name)
> Thanks
> *** Sent via Developersdex http://www.developersdex.com ***

General network error. Check your network documentation

I use sqlclient to connect directly from my mobile 5 pocketpc to a sql server 2005 database on my desktop.

I use a sqldatareader to traverse the results of a query that delivers 2 fields: (1) the filespec, and (2) the image field.

I use a filestream with a binary writer to write the contents of the image data to the pocketpc's storage card.

I have a test table with 10 images, not one more than 4 MB. I cannot complete a test run prior to receiving the general network error.

The pocketPC is connected via activesync to the desktop, and I connect to the database with:

Integrated Security=false;
user id=sa
password=admin.

Any help with this strange error would be greatly appreciated.

Wil

Will,

Using a SqlDataReader and the SqlClient from a device to a remote SQL Server database is a bad idea unless you have a 100% reliable network connection. Best case you can wrap your calls to dtr.Read() in a try catch and re-establish the connection and data reader if it drops, but what you are really doing is trying to keep an open cursor across a network to a remote db.

Better to grab what you need from SQL Server via RDA or an asynch web service call.

-Darren

|||

Hello Darren,

Thanks for your sensible reply...it was very helpful. I wonder why some sample code illustrates this technique for SqlClient if it is not generally advisable?

I will take a look at the alternatives you proposed.

Thanks again,

Wil Pannell

|||

Sure thing Wil - I think using the SQLClient makes sense in a cradled situation and if you have some local data caching established (using SQL CE/Mobile for example), you can get away with connecting over 802.11 as well, but you have to really protect yourself code-wise and assume the connection could drop at any moment.

-Darren

sql

General network error. Check your network documentation

I use sqlclient to connect directly from my mobile 5 pocketpc to a sql server 2005 database on my desktop.

I use a sqldatareader to traverse the results of a query that delivers 2 fields: (1) the filespec, and (2) the image field.

I use a filestream with a binary writer to write the contents of the image data to the pocketpc's storage card.

I have a test table with 10 images, not one more than 4 MB. I cannot complete a test run prior to receiving the general network error.

The pocketPC is connected via activesync to the desktop, and I connect to the database with:

Integrated Security=false;
user id=sa
password=admin.

Any help with this strange error would be greatly appreciated.

Wil

Will,

Using a SqlDataReader and the SqlClient from a device to a remote SQL Server database is a bad idea unless you have a 100% reliable network connection. Best case you can wrap your calls to dtr.Read() in a try catch and re-establish the connection and data reader if it drops, but what you are really doing is trying to keep an open cursor across a network to a remote db.

Better to grab what you need from SQL Server via RDA or an asynch web service call.

-Darren

|||

Hello Darren,

Thanks for your sensible reply...it was very helpful. I wonder why some sample code illustrates this technique for SqlClient if it is not generally advisable?

I will take a look at the alternatives you proposed.

Thanks again,

Wil Pannell

|||

Sure thing Wil - I think using the SQLClient makes sense in a cradled situation and if you have some local data caching established (using SQL CE/Mobile for example), you can get away with connecting over 802.11 as well, but you have to really protect yourself code-wise and assume the connection could drop at any moment.

-Darren

General network error. Check your network documentation

When I try to update the site setting, I get this Error and I don't know how to fix.

Server Error in '/DotNetNuke' Application.
------------------------

General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.

Source Error:

Line 281:
Line 282: myConnection.Open()
Line 283: myCommand.ExecuteNonQuery()
Line 284: myConnection.Close()
Line 285: End Sub

Source File: C:\DotNetNuke\Components\AdminDB.vb Line: 283

Stack Trace:

[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
DotNetNuke.AdminDB.UpdatePortalInfo(Int32 PortalId, String PortalName, String PortalAlias, String LogoFile, String FooterText, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, String ExpiryDate, Double HostFee, Double HostSpace, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory) in C:\DotNetNuke\Components\AdminDB.vb:283
DotNetNuke.SiteSettings.Update_Click(Object sender, EventArgs e) in C:\DotNetNuke\admin\Portal\SiteSettings.ascx.vb:287
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()

------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

Please Help!

Thank you,

dlouaniswrong forum buddy. That's a dotnetnuke addin.|||Did you look in the server's event log? There is probably more information there that could help you to track down the problem.

And actually, the Data Access forum would be a better place for this post, and yeah perhaps one of the DNN forums, but I don't have a problem with it being here for the time being.

Terri

General network error. Check your network documentation

Hello,

I am getting this error "General network error. Check your network documentation." inconsistently. It is happening in some of the stored procs but not all the time. This is always accompanied by "Procedure: ConnectionRead (recv())." in the stack.

I am wondering is this due to some network packets getting dropped or there is something else that probably may be causing this.

ThanksHave you checked the SQL Server error log? There should be something in there to help you pinpoint the problem.

Terri|||Checked the sql server log, there is nothing in there about this error

General Network Error. Check your network documentation

Hi,

I am using .Net 1.1 for my web application.

And my database server is SQL Server 2005.

My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,

General Network Error. Check your network documentation

I have also searched many articles and tried following solutions but nothing working

- connectiontimeout = 0, max pool size = 7500/100, pooling = false

- SSL disabling enforce security false as mentioned in microsoft kb article.

And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)

Can any one please help me to solve this error?

Hi,

Correct me if I am wrong but are you trying to load 3000 records onto a page. If so there is a limit to the number of data records that a page can hold and this may be your problem. Have you tried paging the results so that you only get about 100 or 500 records per page.

Regards

Scottyb

|||

Hi,

Finally i got solution.

that rather then adding connectiontimeout = 0 in connection string.

We have to assign it in command property.

cmd.ConnectionTimeout = 0

because if we didn't assign in command microsoft internally set it's default value.

If you see SqlCommand class code by disassemble, in it's constructor it set this property to 30.
so if you not assign value 0 its default value is 30. it can not take value from connection string.

And it's working fine.

Finally i got so now i can take breath, otherwise my client calling me every 15-20 mins for solution.


General network error. Check your network documentation

Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

Hello my friend,

Are you using forms authentication? If so, are you using a SQL Server Express database to handle the users and roles? If so, you need to change this so it uses a full proper SQL Server, not the Express version. I made a guess that you may be doing this because the error involves OpenAndLogin(). The Express version is just for development, not recommended for production. If I have guessed incorrectly, then I am sorry.

Kind regards

Scotty

|||

Hi Scotty,

Thanks for your information. But We are using SQL Server Enterprise edition. its full version. Please let me know if you have any information.

sql

General network error. Check your network documentation

I've a merge replication over a ISDN router between two
SQL Server 2000 databases.
The job for synchronize always run at 0:00h every day.
Sometimes i'll get this errors messages:
The process could not make a generation at
the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error
number: -2147200994)
General network error. Check your network documentation.
(Source: MAILVXE (Data source); Error number: 11)
Communication link failure
(Source: MAILVXE (Data source); Error number: 0)
The merge process could not perform retention-based meta
data cleanup in database 'WinSGS'.
(Source: Merge Replication Provider (Agent); Error
number: -2147199467)
General network error. Check your network documentation.
(Source: MAILVXE (Data source); Error number: 11)
I've already set the agent profile for a slow link
connection, can someone help qith this?
These errors are likely to be transitory. Schedule your job to run every 10
minutes or have the job loop back to step one on failuer.
See if this clears the problem.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Nuno Higgs" <nunohiggs@.hotmail.com> wrote in message
news:00a601c494ff$4c705ca0$a401280a@.phx.gbl...
> I've a merge replication over a ISDN router between two
> SQL Server 2000 databases.
> The job for synchronize always run at 0:00h every day.
> Sometimes i'll get this errors messages:
> The process could not make a generation at
> the 'Subscriber'.
> (Source: Merge Replication Provider (Agent); Error
> number: -2147200994)
> ----
> General network error. Check your network documentation.
> (Source: MAILVXE (Data source); Error number: 11)
> ----
> Communication link failure
> (Source: MAILVXE (Data source); Error number: 0)
> ----
> The merge process could not perform retention-based meta
> data cleanup in database 'WinSGS'.
> (Source: Merge Replication Provider (Agent); Error
> number: -2147199467)
> ----
> General network error. Check your network documentation.
> (Source: MAILVXE (Data source); Error number: 11)
> ----
> I've already set the agent profile for a slow link
> connection, can someone help qith this?
|||General Network Error often occurs when your CPU(s) are all pinned,
and the db won't accept any more connections.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:<#Dn7BgQlEHA.1476@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
> These errors are likely to be transitory. Schedule your job to run every 10
> minutes or have the job loop back to step one on failuer.
> See if this clears the problem.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Nuno Higgs" <nunohiggs@.hotmail.com> wrote in message
> news:00a601c494ff$4c705ca0$a401280a@.phx.gbl...
|||my experience is that you get the general network error when there is a
network problem. When the server is pegged I normally get timeout error
messages.
I could be wrong here, are you quite sure about this?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Douglas Tarr" <douglas.tarr@.gmail.com> wrote in message
news:c33eac8b.0409080834.686d0d43@.posting.google.c om...
> General Network Error often occurs when your CPU(s) are all pinned,
> and the db won't accept any more connections.
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:<#Dn7BgQlEHA.1476@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
10[vbcol=seagreen]
|||I often get both. It depends on "how pegged" the CPU is. If its at
99%, there's usually enough CPU to obtain new connections. The
timeouts happen when the query itself is run. However, if it is
totally pegged (to the point where i can't even access the box), i get
a general network error.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:<eSg3
$XtlEHA.2224@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
> my experience is that you get the general network error when there is a
> network problem. When the server is pegged I normally get timeout error
> messages.
> I could be wrong here, are you quite sure about this?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Douglas Tarr" <douglas.tarr@.gmail.com> wrote in message
> news:c33eac8b.0409080834.686d0d43@.posting.google.c om...
> news:<#Dn7BgQlEHA.1476@.tk2msftngp13.phx.gbl>...
> 10

General network error. [SQLSTATE 42000] (Error 11).

Looking for info on the noted error message received:
General network error. Check your network documentation.
[SQLSTATE 42000] (Error 11). The step failed.
Basic file import INSERT job failed on data warehouse.
No reported network or backup problems ...
Thanks in advance,
ericggordonHi Ericggordon,
Thanks for your post. What is the version of SQL Server (Service Pack)? I
am not quite clear the problem on your side, Please provide more
information so that I can narrow down this issue.
1. How does this problem occur? Can you describe it in detail?
2. How often did the job fail? Do you mean that the job fails every time?
How is the issue going on your side now?
3. What did the job do? Please describe it in detail.
4. It seems that the INSERT job failed, could you run the job manually?
Does any error occur?
Please check to see if the following article helps.
317852 FIX: An INSERT May Fail with a 3624 Error Message After a Failed
Attempt
http://support.microsoft.com/?id=317852
I am standing by for your response.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

General network error.

This error message is generated from ODBC, and not really
from SQL Server. It is generated when a connection
something the ODBC fails ie DB2 (see Microsoft) so
although SQL Server is reporting it, it is not the cause.
I would sugest that you go through the Event View on your
NT, or put in a trace to see exactly where it fails.
J

>--Original Message--
>Receiving error:
>"General network error. Check your network documentation.
[SQLSTATE 08S01]
>(Error 11)".
>Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
>This started after we rebuild the server. We have tens
of jobs that run at
>night. This error is happening only randomly as some
days nothing happens
>and same job runs fine but other day it blows up. It is
not happening with
>same job either. Then we restart the job and it runs
fine.
>
>.
>
Nothing in the event log or SQLServer log accept that error message.
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:1302301c4433d$9f6096f0$a101280a@.phx.gbl...[vbcol=seagreen]
> This error message is generated from ODBC, and not really
> from SQL Server. It is generated when a connection
> something the ODBC fails ie DB2 (see Microsoft) so
> although SQL Server is reporting it, it is not the cause.
> I would sugest that you go through the Event View on your
> NT, or put in a trace to see exactly where it fails.
> J
>
> [SQLSTATE 08S01]
> of jobs that run at
> days nothing happens
> not happening with
> fine.
|||Hi ilovesql,
We are expiriencing the same issue - I was woundering if you had this resolved.
I also wanted to ask you - when you rebuild the server did it have the same configuration as before or you installed SP3 for SQL Server?
We went from Win2000 server SQL server 2000 SP2 to WIN2003 server SP3 and we started to have this problem from that day on. Microsoft is working on it but this is the second day and they haven't came up with the solution.
I think it is SP3 - something is not right with it.
Thanks,
Anna
"ilovesql" wrote:

> Nothing in the event log or SQLServer log accept that error message.
>
> "Julie" <anonymous@.discussions.microsoft.com> wrote in message
> news:1302301c4433d$9f6096f0$a101280a@.phx.gbl...
>
>

General network error.

Receiving error:
"General network error. Check your network documentation. [SQLSTATE 08S01]
(Error 11)".
Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
This started after we rebuild the server. We have tens of jobs that run at
night. This error is happening only randomly as some days nothing happens
and same job runs fine but other day it blows up. It is not happening with
same job either. Then we restart the job and it runs fine.This error message is generated from ODBC, and not really
from SQL Server. It is generated when a connection
something the ODBC fails ie DB2 (see Microsoft) so
although SQL Server is reporting it, it is not the cause.
I would sugest that you go through the Event View on your
NT, or put in a trace to see exactly where it fails.
J
>--Original Message--
>Receiving error:
>"General network error. Check your network documentation.
[SQLSTATE 08S01]
>(Error 11)".
>Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
>This started after we rebuild the server. We have tens
of jobs that run at
>night. This error is happening only randomly as some
days nothing happens
>and same job runs fine but other day it blows up. It is
not happening with
>same job either. Then we restart the job and it runs
fine.
>
>.
>|||Nothing in the event log or SQLServer log accept that error message.
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:1302301c4433d$9f6096f0$a101280a@.phx.gbl...
> This error message is generated from ODBC, and not really
> from SQL Server. It is generated when a connection
> something the ODBC fails ie DB2 (see Microsoft) so
> although SQL Server is reporting it, it is not the cause.
> I would sugest that you go through the Event View on your
> NT, or put in a trace to see exactly where it fails.
> J
>
> >--Original Message--
> >Receiving error:
> >"General network error. Check your network documentation.
> [SQLSTATE 08S01]
> >(Error 11)".
> >
> >Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
> >
> >This started after we rebuild the server. We have tens
> of jobs that run at
> >night. This error is happening only randomly as some
> days nothing happens
> >and same job runs fine but other day it blows up. It is
> not happening with
> >same job either. Then we restart the job and it runs
> fine.
> >
> >
> >
> >.
> >|||Hi ilovesql,
We are expiriencing the same issue - I was woundering if you had this resolved.
I also wanted to ask you - when you rebuild the server did it have the same configuration as before or you installed SP3 for SQL Server?
We went from Win2000 server SQL server 2000 SP2 to WIN2003 server SP3 and we started to have this problem from that day on. Microsoft is working on it but this is the second day and they haven't came up with the solution.
I think it is SP3 - something is not right with it.
Thanks,
Anna
"ilovesql" wrote:
> Nothing in the event log or SQLServer log accept that error message.
>
> "Julie" <anonymous@.discussions.microsoft.com> wrote in message
> news:1302301c4433d$9f6096f0$a101280a@.phx.gbl...
> > This error message is generated from ODBC, and not really
> > from SQL Server. It is generated when a connection
> > something the ODBC fails ie DB2 (see Microsoft) so
> > although SQL Server is reporting it, it is not the cause.
> > I would sugest that you go through the Event View on your
> > NT, or put in a trace to see exactly where it fails.
> >
> > J
> >
> >
> > >--Original Message--
> > >Receiving error:
> > >"General network error. Check your network documentation.
> > [SQLSTATE 08S01]
> > >(Error 11)".
> > >
> > >Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
> > >
> > >This started after we rebuild the server. We have tens
> > of jobs that run at
> > >night. This error is happening only randomly as some
> > days nothing happens
> > >and same job runs fine but other day it blows up. It is
> > not happening with
> > >same job either. Then we restart the job and it runs
> > fine.
> > >
> > >
> > >
> > >.
> > >
>
>

General network error.

This error message is generated from ODBC, and not really
from SQL Server. It is generated when a connection
something the ODBC fails ie DB2 (see Microsoft) so
although SQL Server is reporting it, it is not the cause.
I would sugest that you go through the Event View on your
NT, or put in a trace to see exactly where it fails.
J

>--Original Message--
>Receiving error:
>"General network error. Check your network documentation.
[SQLSTATE 08S01]
>(Error 11)".
>Running on SQLServer 2000 EE, SP3, Windows 2000 Adv.
>This started after we rebuild the server. We have tens
of jobs that run at
>night. This error is happening only randomly as some
days nothing happens
>and same job runs fine but other day it blows up. It is
not happening with
>same job either. Then we restart the job and it runs
fine.
>
>.
>Nothing in the event log or SQLServer log accept that error message.
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:1302301c4433d$9f6096f0$a101280a@.phx
.gbl...[vbcol=seagreen]
> This error message is generated from ODBC, and not really
> from SQL Server. It is generated when a connection
> something the ODBC fails ie DB2 (see Microsoft) so
> although SQL Server is reporting it, it is not the cause.
> I would sugest that you go through the Event View on your
> NT, or put in a trace to see exactly where it fails.
> J
>
> [SQLSTATE 08S01]
> of jobs that run at
> days nothing happens
> not happening with
> fine.|||Hi ilovesql,
We are expiriencing the same issue - I was woundering if you had this resolv
ed.
I also wanted to ask you - when you rebuild the server did it have the same
configuration as before or you installed SP3 for SQL Server?
We went from Win2000 server SQL server 2000 SP2 to WIN2003 server SP3 and we
started to have this problem from that day on. Microsoft is working on it b
ut this is the second day and they haven't came up with the solution.
I think it is SP3 - something is not right with it.
Thanks,
Anna
"ilovesql" wrote:

> Nothing in the event log or SQLServer log accept that error message.
>
> "Julie" <anonymous@.discussions.microsoft.com> wrote in message
> news:1302301c4433d$9f6096f0$a101280a@.phx
.gbl...
>
>sql

General Network Error, Check ur network documentation

Hi All,
I have been facing this error since last week.
The querry is fired on the dev. server itself, so this is not a network
issue I suppose. Secondly, it's not constant, when retried the same querry
works fine.
There are no recent hotfixes, or service packs applied.
Server is a Win 2000 server, with Sql 2000 Enterprise edition , Sp 3
Any clues ?Hi
There was problems like this with virus checkers and named pipes. You may
want to check the client network utility to make sure that you are using
shared memory.
Also you may want to update MDAC or make sure it is consistent and check
disc space.
John
"k_s" wrote:

> Hi All,
> I have been facing this error since last week.
> The querry is fired on the dev. server itself, so this is not a network
> issue I suppose. Secondly, it's not constant, when retried the same querry
> works fine.
> There are no recent hotfixes, or service packs applied.
> Server is a Win 2000 server, with Sql 2000 Enterprise edition , Sp 3
> Any clues ?
>

General Network Error, Check ur network documentation

Hi All,
I have been facing this error since last week.
The querry is fired on the dev. server itself, so this is not a network
issue I suppose. Secondly, it's not constant, when retried the same querry
works fine.
There are no recent hotfixes, or service packs applied.
Server is a Win 2000 server, with Sql 2000 Enterprise edition , Sp 3
Any clues ?
Hi
There was problems like this with virus checkers and named pipes. You may
want to check the client network utility to make sure that you are using
shared memory.
Also you may want to update MDAC or make sure it is consistent and check
disc space.
John
"k_s" wrote:

> Hi All,
> I have been facing this error since last week.
> The querry is fired on the dev. server itself, so this is not a network
> issue I suppose. Secondly, it's not constant, when retried the same querry
> works fine.
> There are no recent hotfixes, or service packs applied.
> Server is a Win 2000 server, with Sql 2000 Enterprise edition , Sp 3
> Any clues ?
>