run-time error 3251 (1 Viewer)

[jl39775]

I am trying to insert a record to a Oracle DB but keep getting the following error:
Run-time error '3251'
Object or Provider is not capable of performing requested operation.

Does anyone know how to correct this. My code is below:

Dim cnMaximo As ADODB.Connection 'Maximo connection object
Dim sConnect As String

Set cnMaximo = New ADODB.Connection
sConnect = "Provider=MSDAORA.1;Password=maxglobe;User ID=maxglobe;Data Source=maxdev;Persist Security Info=True"
cnMaximpen sConnect

Dim rsEqTrans As ADODB.Recordset
Set rsEqTrans = New ADODB.Recordset
rsEqTrans.CursorLocation = adUseServer
rsEqTrans.CursorType = adOpenKeyset
rsEqTrans.LockType = adLockOptimistic
rsEqTrans.ActiveConnection = cnMaximo

rsEqTrans.Open "eqtrans"

rsEqTrans.AddNew
rsEqTrans!eqnum = rsMaxLoc!eqnum
rsEqTrans!DATEMOVED = MYrs!Date
rsEqTrans!FROMLOC = rsMaxLoc!Location
rsEqTrans!TRANSDATE = Now()
rsEqTrans!ENTERBY = MYrs!UserInitial
rsEqTrans!Memo = "via Physical Inventory"
rsEqTrans.Update

Thanks,
James

 

[jl39775]

Does anyone know what I'm doing wrong with the problem I have in the previous post???

Thanks,

James

 

[Pat Hartman]

Just a wild guess - "Memo" is most likely a reserved word. Change the column name.

 

[jl39775]

Ok, I found out why I could not add a record to oracle using addnew and update. For some reason the Microsoft provider "MSDAORA.1" in my dns-less connection string did not allow me to use the addnew command. I change the provider to Oracle's provider "MSDASQL.1" with a dsn connection. Now I can add records. Did Microsoft design their Oracle provider from adding records?

Anyways, my application is working fine now and thanks for your help.

James