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:
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.
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
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
>> >> >
>> >>
>> >>
>> >>
>>
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 ***
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 ***
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 ***
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 ***
Subscribe to:
Posts (Atom)