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:

No comments:

Post a Comment