Multiple fixes in the System.Data.dll file (834161)

MORE INFORMATION

The following bugs have been fixed in the System.Data.dll file:

• You receive an exception when you use a COMPUTE BY clause in a SQL statement. The exception is similar to the following:
  System.InvalidOperationException: COMPUTE BY statements not supported.
  For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

  823401 BUG: A System.InvalidOperationException exception may occur when you run a SQL Server query by using Visual Studio .NET

• You receive an error message when you handle connection strings that contain apostrophes (') or quotation marks ("") for the first or last character of the value. The error message may look similar to the following:
  System.ArgumentException: Invalid delimiter ' found in the connection option value
• You receive mixed result sets, error messages, and informational messages when you process a batch of results, or you process a stored procedure.
• The Microsoft SQL Server provider incorrectly times out. "Timeout=0" value does not work correctly when you read more than one network packet from the server.

Note The previous four bugs are fixed in the System.Data.dll file for the Microsoft .NET Framework 1.1.

• An exception occurs when a dataset contains a RowError property or a ColumnError property between a Web service and a client application. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

  818587 FIX: Regression in Dataset serialization in the .NET Framework

• The DataTable.Select method may leak memory when you set some specific filter properties. You can use an OR clause instead of an IN clause to work around this leak. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

  814470 DataTable.Select method leaks memory from the index when you set some specific filter properties

• A stack overflow issue occurs when the connection to the server is lost. The connection may be lost when there are any periodic network problems, and when you are using the Microsoft ODBC .NET Managed Provider. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

  821238 Stack Overflow when you use the ODBC .NET Managed Provider

• An exception occurs when you create a DataTable with a computed column that is based on an aggregate function.
  For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

  821415 FIX: "System.Data.VersionNotFoundException: There is no current data to access" error message when you add a row to DataTable