global code: March 2012

Thursday, March 29, 2012

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,

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

|||

-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 ?
>

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 while backing up databases

Microsoft SQL Server 2000 - 8.00.780 (Intel X86)
Mar 3 2003 10:28:28
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Client is Windows XP SP 1
I have this intermittent problem when attempting to backup a database
from another machine. Each time SQL Server communicates back the
status of the backup, I get a general network error as follows:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
10 percent backed up.
Connection Broken
My backup script is very simple, as I am just backing up a test
database:
BACKUP DATABASE Development
TO DISK = 'Development_2003_09_04.bak'
WITH STATS = 10
It is not a query timeout, because I checked. I also varied the STATS
parameter to smaller values and the connection breaks at different
times, as follows:
Disconnect@.15 seconds:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
10 percent backed up.
Connection Broken
Disconnect@.9 seconds:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
5 percent backed up.
Connection Broken
Disconnect@.4 seconds:
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
2 percent backed up.
Connection Broken
The SQL Server log only lists that the backup fails, but doesn't give
a reason. The event log also listed the backup failures but didn't
give any more information than the sql log. I did notice the
following error in the server's application log:
Event Type: Error
Event Source: MSSQLServer
Event Category: (8)
Event ID: 19011
Date: 9/4/2003
Time: 3:02:29 AM
User: N/A
Computer: DAEDALUS
Description:
SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip
[TCP/IP]) : Error 10013.
followed by this warning:
Event Type: Warning
Event Source: MSSQLServer
Event Category: (8)
Event ID: 19011
Date: 9/4/2003
Time: 3:02:30 AM
User: N/A
Computer: DAEDALUS
Description:
SuperSocket info: (SpnRegister) : Error 8344.
Ideas?
Brandon Lilly
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)"jeff" <jeff@.hotmail.com> wrote in message
news:217001c37318$11a76be0$a601280a@.phx.gbl...
> Looks like a permission issue. Try adding sql server
> startup account to local NT admin, restart sql server,
> connect using sysadmin or sa from the xp client, and issue
> backup command again.
I added the account to Builtin\Administrators and also to Domain
Admins to no avail. After stopping and starting SQL Server, the
backup command would still fail if run from my client, regardless of
whether I logged in as SA, or using windows authentication (I am the
domain admin).
I am able to backup a different database remotely, but it is very
small (< 3MB) as opposed to the development database which is about 1
GB. They have the same security.
Brandon
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)|||I don't know anything more on this. Try posting your
question to microsoft.public.win2000.networking group, or
to one of winsock progrrammers group.
Good luck.
>--Original Message--
>"jeff" <jeff@.hotmail.com> wrote in message
>news:217001c37318$11a76be0$a601280a@.phx.gbl...
>> Looks like a permission issue. Try adding sql server
>> startup account to local NT admin, restart sql server,
>> connect using sysadmin or sa from the xp client, and
issue
>> backup command again.
>I added the account to Builtin\Administrators and also to
Domain
>Admins to no avail. After stopping and starting SQL
Server, the
>backup command would still fail if run from my client,
regardless of
>whether I logged in as SA, or using windows
authentication (I am the
>domain admin).
>I am able to backup a different database remotely, but it
is very
>small (< 3MB) as opposed to the development database
which is about 1
>GB. They have the same security.
>Brandon
>--
>"In the beginning the universe was created. This has
made a lot of
>people very angry, and has been widely regarded as a bad
move." -
>Douglas Noel Adams (1952-2001)
>
>.
>|||Brandon,
I am a little confused as to what your actually trying to do. You state
your backing up to a remote server but your backup command does not show
that.
> BACKUP DATABASE Development
> TO DISK = 'Development_2003_09_04.bak'
> WITH STATS = 10
Actually it doesn't show a location at all. You should probably be using
UNC to specify the device if it's remote.
--
Andrew J. Kelly
SQL Server MVP
"Brandon Lilly" <brandon.lilly@.nospam_medevolve.com> wrote in message
news:epoqWBwcDHA.2436@.TK2MSFTNGP12.phx.gbl...
> Microsoft SQL Server 2000 - 8.00.780 (Intel X86)
> Mar 3 2003 10:28:28
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
>
> Client is Windows XP SP 1
>
> I have this intermittent problem when attempting to backup a database
> from another machine. Each time SQL Server communicates back the
> status of the backup, I get a general network error as follows:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 10 percent backed up.
> Connection Broken
>
> My backup script is very simple, as I am just backing up a test
> database:
> BACKUP DATABASE Development
> TO DISK = 'Development_2003_09_04.bak'
> WITH STATS = 10
>
> It is not a query timeout, because I checked. I also varied the STATS
> parameter to smaller values and the connection breaks at different
> times, as follows:
> Disconnect@.15 seconds:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 10 percent backed up.
> Connection Broken
>
> Disconnect@.9 seconds:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 5 percent backed up.
> Connection Broken
>
> Disconnect@.4 seconds:
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (WrapperRead()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> 2 percent backed up.
> Connection Broken
>
> The SQL Server log only lists that the backup fails, but doesn't give
> a reason. The event log also listed the backup failures but didn't
> give any more information than the sql log. I did notice the
> following error in the server's application log:
>
> Event Type: Error
> Event Source: MSSQLServer
> Event Category: (8)
> Event ID: 19011
> Date: 9/4/2003
> Time: 3:02:29 AM
> User: N/A
> Computer: DAEDALUS
> Description:
> SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip
> [TCP/IP]) : Error 10013.
> followed by this warning:
> Event Type: Warning
> Event Source: MSSQLServer
> Event Category: (8)
> Event ID: 19011
> Date: 9/4/2003
> Time: 3:02:30 AM
> User: N/A
> Computer: DAEDALUS
> Description:
> SuperSocket info: (SpnRegister) : Error 8344.
> Ideas?
>
> Brandon Lilly
> --
> "In the beginning the universe was created. This has made a lot of
> people very angry, and has been widely regarded as a bad move." -
> Douglas Noel Adams (1952-2001)
>|||OK, I see now.. It looks like your using named pipes, have you tried
connecting with tcp instead and see if that makes any difference?
--
Andrew J. Kelly
SQL Server MVP
"Brandon Lilly" <brandon.lilly@.nospam_medevolve.com> wrote in message
news:u5jcPl%23cDHA.2392@.TK2MSFTNGP10.phx.gbl...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:Oji9ot7cDHA.2564@.TK2MSFTNGP09.phx.gbl...
> > I am a little confused as to what your actually trying to do. You
> state
> > your backing up to a remote server but your backup command does not
> show
> > that.
> > Actually it doesn't show a location at all. You should probably be
> using
> > UNC to specify the device if it's remote.
> I am backing up a remote server, meaning that I am not at that machine
> running query analyzer - I am at a client machine on the domain
> executing the backup script. I don't specify a location, because I am
> just wanting it to backup to the default location
> Sorry if my post was misleading.
> Brandon
> --
> "In the beginning the universe was created. This has made a lot of
> people very angry, and has been widely regarded as a bad move." -
> Douglas Noel Adams (1952-2001)
>

General network error when you try to back up or restore a SQL Server 2000 on Windows 2000

I am receiving General network error when I try to back up a SQL Server
database on a computer that is running Windows Server 2000
I receive Following error when running DB maintenance job:
[2] Database master: Database Backup...
Destination: [\\LGA01\SysDbBackup_01\master_db_200503311443.BAK ]
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft][ODBC SQL
Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]General network error. Check
your network documentation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages for
database 'master', file 'mastlog' on file 1.
[3] Database model: Database Backup...
Destination: [\\LGA01\SysDbBackup_01\model_db_200503311443.B AK]
Please Help
Hi
Maintenance plans do not support UNC paths. You need to use T-SQL to do
that.
At the same time, check that the account that the SQL Service is running
under has permissions on the destination directory.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rafet Ducic" <rducic@.hotmail.com> wrote in message
news:OZbJL6iNFHA.164@.TK2MSFTNGP12.phx.gbl...
>I am receiving General network error when I try to back up a SQL Server
> database on a computer that is running Windows Server 2000
> I receive Following error when running DB maintenance job:
> [2] Database master: Database Backup...
> Destination: [\\LGA01\SysDbBackup_01\master_db_200503311443.BAK ]
> [Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft][ODBC
> SQL
> Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][Named Pipes]General network error.
> Check
> your network documentation.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages for
> database 'master', file 'mastlog' on file 1.
> [3] Database model: Database Backup...
> Destination: [\\LGA01\SysDbBackup_01\model_db_200503311443.B AK]
> Please Help
>

General network error when you try to back up or restore a SQL Server 2000 on Windows

I am receiving General network error when I try to back up a SQL Server
database on a computer that is running Windows Server 2000
I receive Following error when running DB maintenance job:
[2] Database master: Database Backup...
Destination: & #91;\\LGA01\SysDbBackup_01\master_db_200
503311443.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft]&#
91;ODBC SQL
Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]General network
error. Check
your network documentation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages
for
database 'master', file 'mastlog' on file 1.
[3] Database model: Database Backup...
Destination: & #91;\\LGA01\SysDbBackup_01\model_db_2005
03311443.BAK]
Please HelpHi
Maintenance plans do not support UNC paths. You need to use T-SQL to do
that.
At the same time, check that the account that the SQL Service is running
under has permissions on the destination directory.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rafet Ducic" <rducic@.hotmail.com> wrote in message
news:OZbJL6iNFHA.164@.TK2MSFTNGP12.phx.gbl...
>I am receiving General network error when I try to back up a SQL Server
> database on a computer that is running Windows Server 2000
> I receive Following error when running DB maintenance job:
> [2] Database master: Database Backup...
> Destination: & #91;\\LGA01\SysDbBackup_01\master_db_200
503311443.BAK]
> [Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 4035: [Microsoft]
[ODBC
> SQL
> Server Driver][Named Pipes]ConnectionRead (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][Named Pipes]General networ
k error.
> Check
> your network documentation.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pag
es for
> database 'master', file 'mastlog' on file 1.
> [3] Database model: Database Backup...
> Destination: & #91;\\LGA01\SysDbBackup_01\model_db_2005
03311443.BAK]
> Please Help
>

General Network Error Randomly But Consistantly

We have a .net 1.1 application that gets this both with MSDE and SSE but more with SSE.

It randomly crashes with this error on laptops where they have SSE or MSDE installed on the local computer. They're being referenced by the machineName\Instance because (Local)\Instance had bugs in the past with network connections disappearing and us getting this error.
Now we're getting this, especially with Intel Wireless Cards on a random but consistant basis.

Under SSE we've had to turn on tcp/ip to make our app run, which tells me that something is preventing it from using shared memory access, which I suspect is that we're not using (Local)\Instance, so I tried switching it, and no dice, same problem.

Is anyone else getting this? It's driving us nuts!!!! (and pissing off customers)Are your laptops running Windows XP SP2? Check the firewall if you have allowed the port for SQL Server|||

With respect to SSE, what I would recommend to try is specifying the named pipe protocol in your connection string by adding "Network Library=dbnmpntw;" to your connection string.

If that connects successfull you should be able to turn off TCP/IP on your SSE.

|||Thanks! I'll try that. The firewall was open (but shouldn't have to be because it's local to local...) so I guess using named pipes (which I think is faster anyhow no?) probably can work around it.

Thanks!

General Network Error OpenXML

I am using OpenXML to import data from text file. While it is working

fine with small files...I am getting General Network error while

parsing file of 4.5MB. Could anyone suggest the possible cause for

this. What is interesting is that , I am able to load the same file

using another SQL server. Could someone tell me the possible reason for

this behaviour....

Thanks

AnandThis error typically denotes a problem at the network layer. Can you check the NT event logs of the server for any network card failures? What about the SQL errorlog? Does it have any suspicious messages?sql

General Network Error on subscriber

I am trying to replicate over a dial-up connection a database between
a server running Sql Server 2000 on Windows 2000 server and two SQL
server 2000 personal edition on Windows XP pro.
For one site, the replication worked correclty. For the other one, the
replication process starts, but when trying to connect to the
subscriber (i.e Windows XP pro), after waiting 5 minutes the following
error message is displayed:
Merge Process could not retreive generation information at the
subscriber.
General Network error source <windows xp database> (data source) error
number 11.
Replication tries again automatically and same error is displayed.
All suggestions are welcome.
Best Regards
Patrick
Use the slow link profile for this problem subscribe. Right click on the
agent (expand replication monitor, replication agents, merge agents, locate
your agent), select agent profiles, select the slow link profile, accept
defaults and restart it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Patrick" <pmenage@.intnet.mu> wrote in message
news:4b9f6ca1.0411250208.6f22429a@.posting.google.c om...
>I am trying to replicate over a dial-up connection a database between
> a server running Sql Server 2000 on Windows 2000 server and two SQL
> server 2000 personal edition on Windows XP pro.
> For one site, the replication worked correclty. For the other one, the
> replication process starts, but when trying to connect to the
> subscriber (i.e Windows XP pro), after waiting 5 minutes the following
> error message is displayed:
> Merge Process could not retreive generation information at the
> subscriber.
> General Network error source <windows xp database> (data source) error
> number 11.
> Replication tries again automatically and same error is displayed.
> All suggestions are welcome.
> Best Regards
> Patrick
|||I just found the solution. When I entered my user name in the dial-up
connection box I entered it with the remote machine name eg: PC1\User1.
But when I checked the user in the "add user to operating system" module
in Windows XP, the machine name was dropped, only the user name
appeared. So when connecting, I entered only the user name, and
everything worked fine.
Thank you for your support.
Best Regards
Patrick
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

general network error on asp .net 1.1

hi guys

i am developing my application on framework 1.1 on asp .net

i am trying to connect to sql server 2005 but it gives me error like general network error check your network documentation.

does any one know how to solve this error then pl reply fast

Is SQL Server on your local machine or on a remote server? Make sure the name or IP of the server is correct and that the port is open on any firewall. Try pinging the server to see if it responds.

General network error in VB Application

Hello All,

I need some help with tracing this problem. Only one system in our network gets this error.

Runtime error '-2147467259(80004005')

[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

I am using SQL Server 2000

I have checked the access rights of the user they are perfect and also as i have mentioned earlier this error comes up with this login only. I have also tried replacing the system but it was not helpfull.

What can I do to trace this error.

Thanks in advance.

If this happens during the connection (login) time most likely the server closed the connection.

There may be several raesons. Besides general login permissions, it can be lack of permissions on the default database, lack of the default database etc.

You can try checking the EventLog ERRORLOG on the server whether it reveals any clues.

What is the OS of the client and server?

Do you get the same error if you use the same login account through tools like Query Analyzer or OSQL?

|||

dhavalchoksi,

Looks like this is permission issue with your login credential. Even the login credential has permission to login on the server machine, it probably does not have permission to access the targetted dababase tables. Hence you wan to also verify that the targetted table exists and the user login has the permission. Otherwise, tell me about your machine settups.

(1) domain or workgroup,

(2) OS of both client and server.

(2) connection strings in your VB app.

Thanks,

Nan

General Network error even good connection and small amount of data

Hy everyone,

I have a problem at pulling data on PDA using Sql Mobile 5 from Sql Server 2000.

It work s for most tables, except for two . Every table of those two has about 1000 records and every record about 150 bytes, so all data is about 150 kbytes.

When I connect to the Sql Server 2000 through LAN, no problem. But when I connect through GPRS - VPN, the error occurs. But, the PDA- phone connection is via Bluetooth and at ping no TimeOut appears, the replies are about 600-700 ms. When connecting with a desktop computer through GPRS no such problem occurs.

So , I don't know what could be the cause: the connection or the Sql Mobile which doesn't retry enough in case of error to transfer all data .

A specialist from the GPRS provider told me to use 3G phone , but , because the GPRS phones have already been bought, this would be a too big investment. So, I don't think this is a good idea in this moment .

I found similar problem on the net and a solution was to use Pooling = False. But , in Sql Mobile there is no pulling parameter available when making the connection string .

Any help is very precious to me ,

Mihai .

Hi Mihai,

Seems like you are using a GPRS phone to act like a bluetooth modem for a PDA. This is a tested scenario, and would work :) A couple of issues i can imagine right-away:

1. From the ping round trip time of 600 ms, i guess the synchronization must be timing-out at the TCP/IP level. Below are some time-out properties (HTTP &TCP/IP) of the merge replication and RDA programming objects, which can be set to optimize synchronization over various network bandwidths.

(HTTP)

ConnectionRetryTimeout: Specifies the time, in seconds, to continue to retry sending requests after an established connection has failed.

(TCP/IP)

ConnectTimeout: Specifies the time, in milliseconds, to wait for a connection to the server.

ReceiveTimeout: Specifies the time, in milliseconds, to wait for the response to a server request.

SendTimeout: Specifies the time, in milliseconds, to wait to send a request to the server.

When data is synchronized over a cellular or mobile network, requests sent to the server, and responses from the server can time out. This occurs when a low-bandwidth connection requires too much time to transmit the data. In your case, you have an overhead of the bluetooth transport as well! These time-outs would cause synchronization to fail, which you can solve by specifying a longer time-out value. Try setting a huge value (60000 ms) in your code for the TCP/IP Connect and Send/Recieve Timeouts on the merge replication/RDA object. This mostly should solve your problem.

2. Bluetooth DUN Profile - I assume you are using the Dial-Up Networking profile for the phone to act as a GPRS modem. Are you sure there are no pairing issues? During our tests, we faced a lot of issues with the bluetooth pairing - especially between WM 5.0 PDA's and third party mobile devices.

Let me know if this works out!

Regards,

Sravanth Aluru

|||

When inserting the parameters you specify for the connection string I get an error that says "Unknown connection option ..." .

And for the SqlConnection object there are no properties like those. Only PacketSize, ConnectionTimeout .

I forgot to say previously that I put in connection string "Packet Size=512" and "ConnectionTimeout=90". I tried even with ConnectionTimeout=180. No change.

Do I miss anything, any assembly declaration ?

Could give me another advice ?

Mihai.

|||

The parameters are available in SQL Mobile 3.1 Beta which shipped with Visual Studio 2005 SP1 and onwards.

Sorry for missing this information out in my earlier response!

Can you specify which version you are on?

/Sravanth

|||

I have Sql Mobile 3.00. So , now I am downloading it . I'll reply as soon as I have news.

Thanks a lot,

Mihai.

|||

I can't get sql mobile 3.1

I just installed VS Professional, then SP1. Only Sql mobile 3.0. Anyway, in VS when I try to add reference to System.Data.Sqlclient it shows 3.0 version .

I tried to connect with SendTimeout parameter in the connection string . But I get error which says it is unknown parameter.

I even installed Sql everywhere because I saw it was 3.1 version. Nothing .

I also installed 3_SQL Server 2005 Mobile Edition Server Tools ...

I don't know what else to do.

Any suggestion ?

Thank you,

Mihai .

|||

Yes, I see. It's TCP/IP level ... sorry .

Of course I won't have those parameters in connection string. But how can I work at stream level and use the SQL commands to get data ? Everywhere in docs, when using TcpClient class, the stream is used for sending/receiving data .

But, how do I do to use these TCP/IP parameters if I work at IP level, with sql connection and then sql commands ?

Please give me some advices , I'm a rookie in working with these protocols.

Thanks a lot,

Mihai.

|||

This is a sample of how I get data:

SqlConnection s2000conn = new SqlConnection("Server=10.1.1.10 ; Connection Timeout=60 ; Packet Size = 512 ; UId=user;Pwd=pwd;Database=GestSC");

try

{

s2000conn.Open();

}

catch (SqlException eroare)

{

MessageBox.Show("Connection error", "Eroare Sql");

return;

}

SqlCommand sqlcoms = new SqlCommand();

sqlcoms.CommandText = "SELECT * FROM part ";

SqlDataAdapter da_part = new SqlDataAdapter(sqlcoms.CommandText, s2000conn);

DataSet ds_part = new DataSet();

DataTable dt_part = ds_part.Tables.Add("downpart");

da_part.Fill(ds_part, "downpart");

.....

Then I insert this data in Sql Mobile database .

But how would I use TcpClient ?

TcpClient tc = new TcpClient();

tc.SendTimeout = 90;

And then ?

Thank you ,

Mihai .

|||

Man ,

Is it that simple that it doesn't really worth the effort or you have no answer ?

Can you say smth ?

Thanks anyway,

Mihaila.

|||

Hy all,

I solved the problem by breaking the results into many smaller packets.

First I counted the total number of records and then Fill-ed the cursor with a for-end loop. Simple, but initially I wanted to work in the default mode, not to write code.

And it works.

Finally I heared from the GPRS provider that the GPRS allows small packets of data (maximum 2048 for Packet Size preffered) and the transport of data is not very reliable, so small amount of data should be transfered at one time.

Thank you anyway for all your replies,

Mihaila.

General Network error even good connection and small amount of data

Hy everyone,

I have a problem at pulling data on PDA using Sql Mobile 5 from Sql Server 2000.

It work s for most tables, except for two . Every table of those two has about 1000 records and every record about 150 bytes, so all data is about 150 kbytes.

So , I don't know what could be the cause: the connection or the Sql Mobile which doesn't retry enough in case of error to transfer all data .

I found similar problem on the net and a solution was to use Pooling = False. But , in Sql Mobile there is no pulling parameter available when making the connection string .

Any help is very precious to me ,

Mihai .

Hi Mihai,

Seems like you are using a GPRS phone to act like a bluetooth modem for a PDA. This is a tested scenario, and would work :) A couple of issues i can imagine right-away:

(HTTP)

ConnectionRetryTimeout: Specifies the time, in seconds, to continue to retry sending requests after an established connection has failed.

(TCP/IP)

ConnectTimeout: Specifies the time, in milliseconds, to wait for a connection to the server.

ReceiveTimeout: Specifies the time, in milliseconds, to wait for the response to a server request.

SendTimeout: Specifies the time, in milliseconds, to wait to send a request to the server.

Let me know if this works out!

Regards,

Sravanth Aluru

|||

When inserting the parameters you specify for the connection string I get an error that says "Unknown connection option ..." .

And for the SqlConnection object there are no properties like those. Only PacketSize, ConnectionTimeout .

I forgot to say previously that I put in connection string "Packet Size=512" and "ConnectionTimeout=90". I tried even with ConnectionTimeout=180. No change.

Do I miss anything, any assembly declaration ?

Could give me another advice ?

Mihai.

|||

The parameters are available in SQL Mobile 3.1 Beta which shipped with Visual Studio 2005 SP1 and onwards.

Sorry for missing this information out in my earlier response!

Can you specify which version you are on?

/Sravanth

|||

I have Sql Mobile 3.00. So , now I am downloading it . I'll reply as soon as I have news.

Thanks a lot,

Mihai.

|||

I can't get sql mobile 3.1

I just installed VS Professional, then SP1. Only Sql mobile 3.0. Anyway, in VS when I try to add reference to System.Data.Sqlclient it shows 3.0 version .

I tried to connect with SendTimeout parameter in the connection string . But I get error which says it is unknown parameter.

I even installed Sql everywhere because I saw it was 3.1 version. Nothing .

I also installed 3_SQL Server 2005 Mobile Edition Server Tools ...

I don't know what else to do.

Any suggestion ?

Thank you,

Mihai .

|||

Yes, I see. It's TCP/IP level ... sorry .

But, how do I do to use these TCP/IP parameters if I work at IP level, with sql connection and then sql commands ?

Please give me some advices , I'm a rookie in working with these protocols.

Thanks a lot,

Mihai.

|||

This is a sample of how I get data:

SqlConnection s2000conn = new SqlConnection("Server=10.1.1.10 ; Connection Timeout=60 ; Packet Size = 512 ; UId=user;Pwd=pwd;Database=GestSC");

try

{

s2000conn.Open();

}

catch (SqlException eroare)

{

MessageBox.Show("Connection error", "Eroare Sql");

return;

}

SqlCommand sqlcoms = new SqlCommand();

sqlcoms.CommandText = "SELECT * FROM part ";

SqlDataAdapter da_part = new SqlDataAdapter(sqlcoms.CommandText, s2000conn);

DataSet ds_part = new DataSet();

DataTable dt_part = ds_part.Tables.Add("downpart");

da_part.Fill(ds_part, "downpart");

.....

Then I insert this data in Sql Mobile database .

But how would I use TcpClient ?

TcpClient tc = new TcpClient();

tc.SendTimeout = 90;

And then ?

Thank you ,

Mihai .

|||

Man ,

Is it that simple that it doesn't really worth the effort or you have no answer ?

Can you say smth ?

Thanks anyway,

Mihaila.

|||

Hy all,

I solved the problem by breaking the results into many smaller packets.

First I counted the total number of records and then Fill-ed the cursor with a for-end loop. Simple, but initially I wanted to work in the default mode, not to write code.

And it works.

Thank you anyway for all your replies,

Mihaila.

sql

General Network Error Check network documentation

Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly.

The Error details are as follows:

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:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: General network error. Check your network documentation.]

System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

If once a update is fired from IDE it takes long to respond but once its done the error disappears.

Any body any Idea.

Thursday, March 29, 2012

General network error. Check your network documentation.

General network error. Check your network documentation.

General network error. Check your network documentation.

General network error. Check your network documentation.

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

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

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

General network error. Check your network documentation

General network error. Check your network documentation

General network error. Check your network documentation

General network error. Check your network documentation

General Network Error. Check your network documentation

General network error. Check your network documentation

General network error. Check your network documentation

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

General network error.

General network error.

General network error.

General Network Error, Check ur network documentation

General Network Error, Check ur network documentation

General Network Error, Check ur network documentation

General Network Error while backing up databases

General network error when you try to back up or restore a SQL Server 2000 on Windows 2000

General network error when you try to back up or restore a SQL Server 2000 on Windows

General Network Error Randomly But Consistantly

General Network Error OpenXML

General Network Error on subscriber

general network error on asp .net 1.1

General network error in VB Application

General Network error even good connection and small amount of data

General Network error even good connection and small amount of data

General Network Error Check network documentation

global code

Blog Archive

About Me