BorlandTalk.com

Lionel Pierre · Guest

Greetings all,

My simple test app which tries to establish a connection to Oracle via ADO
using the connection string "Provider=MSDAORA.1;Password=password;User
ID=userid;Data Source=SOURCE;Persist Security Info=True" results in the
error: "Oracle error occurred, but error message could not be retrieved from
Oracle" when I set the TADOConnection.Connected := true or try to open a
simple TADOQuery directly.

The same connection string in the UDL file tests correctly through the UDL's
test connection. The test app actually works correctly when run on my
development machine (windows XP pro) accessing Oracle on a separate machine.
It fails however on the production machine (also XP pro) which is also the
DB server.

I have found posts suggesting I switch to using the Oracle Provider for
OLEDB.

Does anyone know of any other solutions besides that? The Oracle OLEDB
provider offers some other obstacles I don't want to tackle unless I really,
really have to.

Thank you.

Lionel