Updating values in Oracle

Hi there!

Have a problem with updating records in oracle :
i am using RDO to access oracle data. My sample code as follows

Dim env As rdoEnvironment
Dim con As rdoConnection
Dim rs As rdoResultset

Private Sub Form_Load()

Set env = rdoEngine.rdoEnvironments(0)
env.CursorDriver = rdUseOdbc
Set con = env.OpenConnection("", rdDriverNoPrompt, False, "uid=scott;pwd=tiger;dsn=oracledata")
SSQL = "select * from dept"
Set rs = con.OpenResultset(SSQL, rdOpenDynamic, rdConcurRowVer)
SSQL = "select empno,ename,sal,comm,deptno from emp"
Set rs1 = con.OpenResultset(SSQL, rdOpenDynamic, rdConcurRowVer)
Text1.Text = rs!deptno
Text2.Text = rs!dname
Text3.Text = rs!Loc
End Sub

Private Sub CommandEdit_Click()
rs.Edit
End Sub
Private Sub CommandAddnew_Click()
rs.addnew
End Sub

Private Sub CommandSave_Click()
rs!deptno = Text1.Text
rs!dname = Text2.Text
rs!Loc = Text3.Text
rs.Update
End Sub

problem is when i say rs.edit and update record it's giving error:
Run time error 40002
IM006:[MICROSOFT][ODBC Drivers Manager] Drivers sqlsetconnectAttr failed

but when i add new record it's inserting records without any problem
I am using VB5 and ORACLE8 Client
And the same code is working good in Personal Oracle7.3

Thanks in advance!

[S joy]

Hi
The Error Code is basically for the error in Connection object.
Try with DSN-less Connection as:

rdoenvironment(0).OpenConnection("",rddrivernoprompt,false,"server=oracledata;Driver={Microsoft ODBC for Oracle};uid=scott;pwd=tiger"



I don't know the default cursor type in RDO ,is it Readonly ?
I hope it will help you