Invalid Buffer Error (Hotfix 815494) and ADO.NET and Framework 1.0

[Jean-Francois Gagnon]

Hi,

FYI,

We were able to fix a problem we had with SQLServer after Hotfix
815495 was installed.

Our application, written in VB.NET, with ADO.NET under .NET framework
1.0, would generate an SQL exception of "General network error" or "A
severe error occured on the current command. The Results, if any,
should be discarded". At the same time this error would occur in the
application, an exception would occur in SQL Server and the message
would be "Invalid buffer".

Our application would not generate the exception if run under .NET
framework 1.1, but we would have a bunch of other problems with
Crystal Reports.

The error would occur with inserts on that specific table that had a
field of type "Text". A thorough investigation revealed that the
Adapters created by the VS.NET Code Generators (dragging og an
SQLadapter Icon onto a Web Page or a Data Access Component) would be
generated with code that generate that error.

The Update Command as well as the Insert Command Parameters would
have that field defined as a System.Data.Sql DbType.VarChar( 2147483647)
instead of System.Data.Sql DbType.Text. The Changing to
"System.Data.Sq lDbType.Text" fixed the problem WITHOUT having to
migrate to the .NET Framework 1.1.

Regards

JFG

PS. The Knowledge base from Microsoft as well as their MSDN site are
totally silent on that topic... If anybody from Microsoft reads this,
Please update your site appropriately.