[cooltea]

please help me with programming error message "E_FAIL". im using visual basic and interbase database with MSado.

when i update datbase, error message appear "E_FAIL".

'properties
CursurLocation=adUseClient

'SQL
adodc1.recordsource="select * from ib_payment"
adodc1.refresh

'Add button
adodc1.recordset.addnew

'Save button
adodc1.recordset.update
'error appear when i click save button

[MrWizard]

Originally posted by cooltea
please help me with programming error message "E_FAIL". im using visual basic and interbase database with MSado.

when i update datbase, error message appear "E_FAIL".

'properties
CursurLocation=adUseClient

I've seen this one before posted somewhere in this forum (or maybe it was another ASP forum?)... If you remove the cursorlocation property, the error should go away.

Tim