Microsoft KB Archive/913177

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

Article ID: 913177

Article Last Modified on 12/3/2007

-

APPLIES TO


 * Microsoft .NET Framework 2.0

-





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.



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

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

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

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 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 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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For more information, click the following article number to view the article in the Microsoft Knowledge Base:

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.

Keywords: kbtshoot kbbug kbfix kbqfe kbpubtypekc KB913177

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.