How to update recordset with ADO

I can't update recordset when i use Informix OLE DB Provider, the Error Message is X42000:-201:Syntax error or access violation Informix Database Server is IDS/UD 9.14.UC1-1 Client SDK 2.3 for Intel NT can you tell me why this error occured and how can avoid this VB Code as follows Dim intindex As Long Dim connection As New ADODB.connection Dim records As New ADODB.Recordset Dim ConStr As String Dim sql As String On Error GoTo errhandle ConStr = "Provider=Ifxoledbc.2;User ID=informix;Data Source=gd@sgio2;Connect Timeout=120" Call connection.Open(ConStr, "informix", "informix") records.CursorLocation = adUseClient Set records.ActiveConnection = connection records.LockType = adLockBatchOptimistic sql = "SELECT * FROM doc WHERE id=0" records.Open sql, , , , adCmdText records("title")= "foo" records.UpdateBatch 'error occured here records.Close Set records = Nothing connection.Close Set connection = Nothing errhandle: records.Close Debug.Print Err.Description End Sub

Check that your DELIMIDENT is set. Yu Zhen <yu_zhen@yeah.net> wrote in message news:830hqb$2pfr$1@news.cz.js.cn... >