Help and Support
 

powered byLive Search

FIX: You may receive an error message when an ADO.NET-connected application uses the SqlBulkCopy class

View products that this article applies to.
Article ID:913177
Last Review:December 3, 2007
Revision:2.3
On This Page

SYMPTOMS

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)
Note
•The error message depends on the size of the data that is being copied. There may not be a specific size or a specific size range that consistently causes the error message.

Back to the top

RESOLUTION

To resolve this issue, download the appropriate file for your computer:

Back to the top

For an x86-based computer

The following file is available for download from the Microsoft Download Center:
http://download.microsoft.com/download/2/C/5/2C5BCDC9-3241-443A-9F96-4E0B0EDFA727/NDP20-KB916002-X86.exe (http://download.microsoft.com/download/2/c/5/2c5bcdc9-3241-443a-9f96-4e0b0edfa727/ndp20-kb916002-x86.exe)

Back to the top

For an x64-based computer

The following file is available for download from the Microsoft Download Center:
http://download.microsoft.com/download/D/3/9/D39C79DF-4158-45DF-9031-92C52AB0ED19/NDP20-KB916002-X64.exe (http://download.microsoft.com/download/d/3/9/d39c79df-4158-45df-9031-92c52ab0ed19/ndp20-kb916002-x64.exe)

Back to the top

For an Itanium-based computer

The 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 (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:
119591 (http://support.microsoft.com/kb/119591/) How to obtain Microsoft support files from online services
Microsoft 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.

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top

MORE INFORMATION

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
824684 (http://support.microsoft.com/kb/824684/) Description of the standard terminology that is used to describe Microsoft software updates

Back to the top

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.

Back to the top

APPLIES TO
•Microsoft .NET Framework 2.0

Back to the top

Keywords: 
kbtshoot kbbug kbfix kbqfe kbpubtypekc kbhotfixserver KB913177

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.