Error: Multiple-step OLE DB operation generated errors
I've a situation here..!
An error occurs when I try to update a record to mytable.
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Err : -2147217887
Finidings:-
This happence to the field which is created as TEXT or VarChar type..!!
While skipping those fields in Debug Mode, Data Storing to the Database
OS: XP
Connectivity : ODBC
Application : VB6/ADO Object Method
If any one have experianced about this please Suggest me how to solve the issue.
Create Table tblJournal
(
fldAccountID Int(4) NOT NULL,
fldID Int(6) NOT NULL,
fldSerial Int(4) NOT NULL,
fldModuleID Int(6) NOT NULL,
-----
-----
-----
fldNarration varChar(80) NULL,
fldByLedgerID Int(6) NOT NULL,
fldTagID Int(6) DEFAULT 0,
fldProjectID Int(6) DEFAULT 0,
fldModeOfPayment Int(1) DEFAULT 1,
fldNameOfBank varChar(100) Null,
fldPlace varChar(100) Null,
fldRefNo varChar(50) Null,
fldDated Date ,
fldDeleted Int(1)DEFAULT 0
);
The error occurs either in fldNarration, fldNameOfBank, fldPlace, fldRefNo
fldNarration was actually TEXT type..
So please