PRB: CLongBinary Edits Fail with SQL Server Snapshot (156296)
The information in this article applies to:
- The Microsoft Foundation Classes (MFC), when used with:
- Microsoft Visual C++, 32-bit Learning Edition 4.0
- Microsoft Visual C++, 32-bit Learning Edition 4.2
- Microsoft Visual C++, 32-bit Enterprise Edition 4.2
- Microsoft Visual C++, 32-bit Professional Edition 4.0
- Microsoft Visual C++, 32-bit Professional Edition 4.1
- Microsoft Visual C++, 32-bit Professional Edition 4.2
This article was previously published under Q156296 SYMPTOMS
When calling CRecordset::Edit() followed by CRecordset::Update() to update
an image field in a snapshot recordset, you may receive the following
errors:
Incorrect syntax near the keyword 'UPDATE'.
State:37000,Native:156,Origin:[Microsoft][ODBC SQL Server Driver]
[SQL Server]
Line 1: Incorrect syntax near '='.
State:37000,Native:170,Origin:[Microsoft][ODBC SQL Server Driver]
[SQL Server]
CAUSE
There is a bug in the Microsoft SQL Server ODBC driver version 2.65.0201,
which ships with Visual C++ version 4.2.
RESOLUTION
Upgrade your SQL Server ODBC driver to version 2.65.0213, which comes with
Microsoft Visual C++, Enterprise Edition, version 4.2 or with the Service
Pack 1 for Microsoft SQL Server version 6.5.
MORE INFORMATION
This problem occurs only when the cursor library is loaded and the
recordset is opened as a snapshot. Dynasets without the cursor library do
not display this problem.
REFERENCES
For additional information, please see the following article in the
Microsoft Knowledge Base:
152709 FIX: Update of BLOB Data w/SQL Server 2.65.0201 Driver Stops
| Modification Type: | Major | Last Reviewed: | 12/1/2003 |
|---|
| Keywords: | kbDatabase kberrmsg kbprb kbProgramming KB156296 |
|---|
|