vb 6.0 and oracle 9i

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

Hi,

In your connection string, change the provider from "MSDAORA" to "oraOLEDB.Oracle.1", becoz I think the Microsoft Provider for Oracle doesnt support updating of records.

I hope this helps...


Bye & regards.
Ravi

priyan11


It is unknown how you are retrieving the information from database. Some queries are not updatable. The problem could be several places.

The example you posted only reads the information. There is no indication that you are attempting to update anything and no indication from you to where in your code you are getting the error.