Updateting Oracle from Excel

[Sonnich]

Hello

I have no problems reading, but writing (update...) fails, as:
Runtime error 3146 - ODBC--call failed.

My code:


Set oWS = CreateWorkspace("blabla", "blabla", "blabla",
dbUseODBC)
oWS.DefaultCursorDriver = dbUseODBCCursor

oData = oWS.OpenConnection("blabla", dbDriverNoPrompt, True, _
"ODBC;DSN=blabla;UID=blabla;PWD=blabla")

Dim oConn As DAO.Connection ' database connection
Set oConn = oData.Connection ' open it
'If oConn.Updatable Then ' this is false...
oConn.Execute "update blabla set blabla where 1=0" ' test!

BR
Sonnich

 

[MH]

Perhaps you are using a read-only connection?

If not, then it may be that there is a setting in Oracle that you need to
change.

MH