Kbase 21525: SQL92 VB Error With Client-Side Cursor Updates and Deletes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/24/2008 |
|
Status: Verified
SYMPTOM(s):
E_FAIL status error from Visual Basic (VB) when using client-side static cursors.
-2147467259 Data provider or other service returned an E_FAIL status.
Error source reported as Microsoft Cursor Engine.
FACT(s) (Environment):
Products / Versions
All Supported Operating Systems
CAUSE:
This is a Microsoft problem regarding offset binding.
To confirm that offset binding is being used, check for following in sql trace:
ConnectTest fffa79cb-fffa7f67
ENTER SQLSetStmtAttrW SQLHSTMT 03F91810
SQLINTEGER SQL_ATTR_ROW_BIND_OFFSET_PTR>
SQLPOINTER 007FE9C8
SQLINTEGER -4
FIX:
There is a workaround which causes parameter validation not to use the bind offset when validating the charoctetlength buffer.
In the VB application, where the data source name is entered (eg. VcClinicalProgress), change the name from
"Data Source=VcClinicalProgress;"
- to -
"Data Source=VcClinicalProgress;WorkArounds2=16".
In order to not change the application itself, the data source must register the string value of "WorkArounds2" to 16.