I am making a project using vb 6.0 and oracle 9i.In that i am using ADODB connection.I am able to reterive the data from my database.But if i try to add,delete or modify data through my frontend i am not able to do so.It is giving me the error as

Run time error-'3251'
Current recordset does not support updating.This may be the limltation of the provider or of the selected recordtype.

I have written the following code in the form load event.

con.ConnectionString = "Provider=MSDAORA;user id=scott;password=Tiger"
con.Open
rs.Open "TBLCITY", con, adOpenDynamic, adLockOptimistic
text1.text=rs.fields(0)
text2.text=rs.fields(1).

Please can any one help me