Article ID: 192142
Article Last Modified on 11/21/2003
Dim rs As rdoResultset
Dim cn As New rdoConnection
cn.CursorDriver = rdUseClientBatch
cn.Connect = "dsn=<dsn>;uid=<uid>;pwd=<pwd>"
cn.EstablishConnection
cn.Execute "CREATE TABLE temp1 (id int, name char(20))"
cn.Execute "CREATE UNIQUE INDEX temp1_id on temp1 (id)"
cn.Execute "GRANT ALL ON temp1 TO PUBLIC"
cn.Close
On Error GoTo Erh
For i = rdUseIfNeeded To rdUseClientBatch
cn.CursorDriver = i
cn.EstablishConnection
Set rs = cn.OpenResultset("select * from temp1", rdOpenKeyset, _
rdConcurRowVer)
rs.AddNew
rs(0) = i
rs(1) = "Also works fine"
rs.Update '<-- Errors occur here
cn.Close
Next
cn.EstablishConnection
cn.Execute "DROP TABLE temp1"
End
Erh:
sterr = Error & Chr(13) & "With CursorDriver "
Select Case cn.CursorDriver
Case rdUseServer
sterr = sterr & "rdUseServer"
Case rdUseOdbc
sterr = sterr & "rdUseOdbc"
Case rdUseNone
sterr = sterr & "rdUseNone"
Case rdUseIfNeeded
sterr = sterr & "rdUseIfNeeded"
Case rdUseClientBatch
sterr = sterr & "rdUseClientBatch"
Case Else
End Select
MsgBox sterr
Resume Next
End Sub
Additional query words: kbVBp500 kbOracle kbODBC kbRDO kbdse kbDSupport KbVBp kbDatabase kbDriver
Keywords: kbfix kbprb KB192142