Article ID: 913177 - View products that this article applies to.
When a Microsoft ADO.NET-connected application uses the SqlBulkCopy class, you may receive an error message that is similar to the following:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount) at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader) at ConsoleApplication1.Program.Main(String args)
To resolve this issue, download the appropriate file for your computer:
For an x86-based computerThe following file is available for download from the Microsoft Download Center:
For an x64-based computerThe following file is available for download from the Microsoft Download Center:
For an Itanium-based computerThe following file is available for download from the Microsoft Download Center:
(http://download.microsoft.com/download/0/0/3/00392DD3-5B4F-4D99-94E8-6827B8F8D7EF/NDP20-KB916002-IA64.exe)For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
(http://support.microsoft.com/kb/119591/ )How to obtain Microsoft support files from online services
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates
This problem does not occur if the MultipleActiveResultSets connection string property has been set to True for the SQLConnection object. However, we do not recommend that you use this configuration as a workaround to prevent this problem. The MultipleActiveResultSets connection string property should only be enabled if the client application truly must maintain multiple active results on the connection.
Article ID: 913177 - Last Review: October 9, 2011 - Revision: 3.0