wylbur
05-31-2006, 05:17 AM
Hi,
I'm accessing a pair of databases with ASP/ADO,
and using stored procedures on the first access.
The first access works OK - everything gets written
to where it's supposed to be.
On attempting to write to a pair of database tables
in the second database (second access attempt),
the server crashes, as does the app, and I get the following error:
--------------------------------------------------------------------
Server Error in '/Webfolder01' Application.
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:
A transport-level error has occurred when receiving results from the server.
(provider: Shared Memory Provider, error: 0 - The pipe has been ended.)
--------------------------------------------------------------------
After this, I have to go into the services panel and restart SQL 2005.
This doesn't happen if I use small test data sets in the first access,
and I can comment out the second access attempt, and the first access
executes just fine with both the large and small data sets,
so I'm thinking that this has something to do with synchronisation:
Perhaps the second attempt is being made before the server is ready.
Is there something that I need to do to make certain that SQL 2005
is ready to receive data?
I'm using SqlBulkCopy with both accesses, but I don't see how that
could be a problem.
--------------------------------------------------------------------
[SqlException (0x80131904): A transport-level error has occurred
when receiving results from the server.
(provider: Shared Memory Provider, error: 0 - The pipe has been ended.)]
System.Data.SqlClient.SqlConnection.OnError
(SqlException exception, Boolean breakConnection) +857370
System.Data.SqlClient.SqlInternalConnection.OnError
(SqlException exception, Boolean breakConnection) +734982
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParserStateObject.ReadSniError
(TdsParserStateObject stateObj, UInt32 error) +556
System.Data.SqlClient.TdsParserStateObject.ReadSni
(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +164
System.Data.SqlClient.TdsParserStateObject.ReadPacket
(Int32 bytesExpected) +34
System.Data.SqlClient.TdsParserStateObject.ReadBuffer() +30
System.Data.SqlClient.TdsParserStateObject.ReadByte() +17
System.Data.SqlClient.TdsParser.Run
(RunBehavior runBehavior, SqlCommand cmdHandler,
SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj) +59
System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() +1327
System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer
(Int32 columnCount) +916
System.Data.SqlClient.SqlBulkCopy.WriteToServer
(DataTable table, DataRowState rowState) +176
System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table) +6
Database_control.DB_ctrl_class.load_datatable_to_DB_table
(DB_ref_class src_table) in i:\Virtual Webfolders\DBctrl.cs:978
--------------------------------------------------------------------
THANK YOU VERY MUCH!!!
I'm accessing a pair of databases with ASP/ADO,
and using stored procedures on the first access.
The first access works OK - everything gets written
to where it's supposed to be.
On attempting to write to a pair of database tables
in the second database (second access attempt),
the server crashes, as does the app, and I get the following error:
--------------------------------------------------------------------
Server Error in '/Webfolder01' Application.
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:
A transport-level error has occurred when receiving results from the server.
(provider: Shared Memory Provider, error: 0 - The pipe has been ended.)
--------------------------------------------------------------------
After this, I have to go into the services panel and restart SQL 2005.
This doesn't happen if I use small test data sets in the first access,
and I can comment out the second access attempt, and the first access
executes just fine with both the large and small data sets,
so I'm thinking that this has something to do with synchronisation:
Perhaps the second attempt is being made before the server is ready.
Is there something that I need to do to make certain that SQL 2005
is ready to receive data?
I'm using SqlBulkCopy with both accesses, but I don't see how that
could be a problem.
--------------------------------------------------------------------
[SqlException (0x80131904): A transport-level error has occurred
when receiving results from the server.
(provider: Shared Memory Provider, error: 0 - The pipe has been ended.)]
System.Data.SqlClient.SqlConnection.OnError
(SqlException exception, Boolean breakConnection) +857370
System.Data.SqlClient.SqlInternalConnection.OnError
(SqlException exception, Boolean breakConnection) +734982
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParserStateObject.ReadSniError
(TdsParserStateObject stateObj, UInt32 error) +556
System.Data.SqlClient.TdsParserStateObject.ReadSni
(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +164
System.Data.SqlClient.TdsParserStateObject.ReadPacket
(Int32 bytesExpected) +34
System.Data.SqlClient.TdsParserStateObject.ReadBuffer() +30
System.Data.SqlClient.TdsParserStateObject.ReadByte() +17
System.Data.SqlClient.TdsParser.Run
(RunBehavior runBehavior, SqlCommand cmdHandler,
SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj) +59
System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() +1327
System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer
(Int32 columnCount) +916
System.Data.SqlClient.SqlBulkCopy.WriteToServer
(DataTable table, DataRowState rowState) +176
System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table) +6
Database_control.DB_ctrl_class.load_datatable_to_DB_table
(DB_ref_class src_table) in i:\Virtual Webfolders\DBctrl.cs:978
--------------------------------------------------------------------
THANK YOU VERY MUCH!!!