FIX: SQLRowCount Returns -1 After Insertion of a BLOB >= 400K

Article translations Article translations
Article ID: 252948 - View products that this article applies to.
This article was previously published under Q252948
BUG #: 54818 (SQLBUG_70)
Expand all | Collapse all

SYMPTOMS

After inserting 400K or more of data for a text or image column, a call to the ODBC SQLRowCount function incorrectly returns -1, if the following conditions are met:

  • You use the Microsoft ODBC Driver for SQL Server, version 3.7.

  • The backend is Microsoft SQL Server 7.0 or later.

CAUSE

If the amount of data that needs to be inserted is more than 400K, the ODBC Driver for SQL Server switches to another mechanism to insert the data.

WORKAROUND

Run the ODBCCMPT utility against your ODBC application. For more information, refer to Microsoft SQL Server 7.0 Books Online or the following Web address:
http://msdn.microsoft.com/library/psdk/sql/4_opingc.htm

STATUS

Microsoft has confirmed this to be a problem in the Microsoft ODBC Driver for SQL Server, version 3.7.

This bug was corrected in SQL Server 7.0 Service Pack 2.

MORE INFORMATION

Because Microsoft Access 97 uses the SQLRowCount function to verify a successful INSERT, the following error message occurs when you try to insert BLOB data that is 400K or more into an attached SQL Server table:
ODBC - Insert on a linked table 'table name' failed.

Properties

Article ID: 252948 - Last Review: October 16, 2002 - Revision: 1.0
APPLIES TO
  • Microsoft ODBC Driver for Microsoft SQL Server 3.7
Keywords: 
kbbug kbfix kbqfe KB252948
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com