# Rdo access local machine database,errors:The resultset type is read_only,who help me?

Posted by yuan on September 15, 1998 at 13:18:20:

I use vb6 enterprise edition on system win95
on control panel,32bitodbc:
system dsn:yuan1
advanced:read_only=0
but always errors:run-time errors "40058"
the resulttype is read_only
I use DAo ways can sucess.

program code as follows:
Private Sub Form_Load()
Dim db As rdoconnection
Dim rs As rdoresultset
Dim ssql As String
Set db = rdoengine.rdoenvironments(0).OpenConnection("yuan1")
ssql = "select * from branch"
Set rs = db.openresultset(ssql, rdopenkeyset)
rs.movefirst
rs.edit
rs![branch_address] = "6"
rs.Update
While Not rs.EOF
Debug.Print rs.rdocolumns(0)
rs.movenext
Wend
rs.Close
db.Close
End Sub

i don't know why? who can help me?

Follow Ups:

- Re: Rdo access local machine database,errors:The resultset type is read_only,who help me? AndyLin 13:45:35 9/15/98 (1)
  - Sir,thank you very much,I have debug sucess yuan 14:02:15 9/15/98 (0)