Oracle VB recordset problem

04-13-2004, 09:01 AM

I am trying to access the oracle database and it access it fine but I can't do any editing. I used the same way to obtain the recordset from Access but it doesn't work for oracle. This way of obtaining the recordset is not letting me do any updates to the database such as deleting and saving.

I try to search for it so many times in the net couldn't find anything. I am newbie to VB please help me.

Also at the same time if you someone can give me an idea how to access the sybase database (connection string) and how the recordset should written that would be great. Million thanks in advance


strConn = "data source=" & dBase & ";" & _
"user id=" & uid & ";" & _
"password=" & pwd

With db
.Provider = "MSDAORA"
.CursorLocation = adUseNone
.ConnectionTimeout = 10
.ConnectionString = strConn
End With

Set ORAcmd.ActiveConnection = db

rs.Open "SELECT * FROM tbmso.msot_mlis ORDER BY mli", db, adOpenStatic, adLockOptimistic

04-13-2004, 09:04 AM
For connectionStrings to various database engines, try this site:

Regarding opening and edit your recordset, why are not using a client or server side cursor? And, instead of using adOpenStatic, use AdOpenKeyset or AdOpenDynamic for your cursor type and add AdCmdText as the last parameter in your rs.Open Declaration

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum