OracleDirect - TSQLConnection

[martinw30]

Hello

Trying the DevartOracleDirect. After hitting username and password I get ORA-01017 invalid username and password (credentials are right typed).

I am using the latest dbExpress driver (6.4) with Delphi Xe2.

/Martin

[AlexP]

Hello,

Please specify the exact version of Oracle Server. Also, make sure that, if you use the case-dependent login and password, you quote them.

[martinw30]

Oracle 12

[martinw30]

quote them did not help.

/Martin

[martinw30]

I can from Delphi IDE login, but when I do TSQLConnection.open in runtime it raises exception, same parameters in runtime as designtime.

[AlexP]

Starting from Oracle version 11.2.0.4, the connection protocol has been changed. We already supported this protocol. The latest driver version connects to Oracle 12c without any errors.
Please ensure, there are no older versions of the library on your PC.

[martinw30]

dbexpoda40.dll 6.4.7 in windows directory any other dependecies?

Can Delphi version XE2 be an issue?

/M

[AlexP]

If connection is established with no errors in design time, and the ORA-01017 error occurs when connecting to the same server in run time, this only means that different libraries are used. You can check the used libraries in both cases with the ProcessExplorer utility.