Microsoft KB Archive/823896

= FIX: An error may occur when you try to use the JDBC driver to insert binary large object data into a SQL Server 2000 table =

Article ID: 823896

Article Last Modified on 3/19/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Driver for JDBC

-



SYMPTOMS
When you try to insert binary large object (BLOB) data into a Microsoft SQL Server 2000 table by using the Microsoft SQL Server 2000 Driver for JDBC, and then you set the network packet size configuration option of the sp_configure system stored procedure to a value that is larger than 4096, you may receive the following error message:

[Microsoft][SQLServer 2000 Driver for JDBC]End of stream was detected on a read.

[Microsoft][SQLServer 2000 Driver for JDBC]Connection aborted by peer: socket write error



RESOLUTION
To resolve this problem, obtain the latest service pack for SQL Server 2000 Driver for JDBC. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

883370 Information about how to obtain the latest SQL Server 2000 Driver for JDBC service pack

For additional information about how to obtain a hotfix for this problem, click the following article number to view the article in the Microsoft Knowledge Base:

817326 FIX: JDBC driver may cause application to stop responding during multiple transactions



STATUS
Microsoft has confirmed that this is a bug in SQL Server 2000 Driver for JDBC version 2.20.0029 for Service Pack 1.

This bug was corrected in SQL Server 2000 Driver for JDBC version 2.20.0030 for Service Pack 1.



MORE INFORMATION
You may use the following code to set the network packet size configuration option of the sp_configure system stored procedure: EXEC sp_configure 'network packet size', 8192 RECONFIGURE WITH OVERRIDE GO

