Connecting to Oracle from Crystal reports 8.5

[itprogram]

When I connect to Oracle using the Oracle in Ora92 (sqora32.dll) driver v12/03/2002 from Crystal Reports 8.5 I'm getting the following error message

"Ora-01456: may not perform insert/update/delete operation inside a read only transaction." The read-only option was not checked when I set up the ODBC connection using this driver.

When I use the crystal oracle driver there is no problem. Is it possible to use Oracle's driver? If yes how can I get rid of the error message?

many thanks

 

[Turkbear]

Hi, Avoid ODBC altogether: Use the Native Oracle connection option under 'More Data Sources..Oracle Server.

It has fewer problems with passing the authentication to Oracle in some cases.