Page 1 of 1
OracleDirect - TSQLConnection
Posted: Fri 15 Aug 2014 13:45
by 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
Re: OracleDirect - TSQLConnection
Posted: Mon 18 Aug 2014 08:00
by 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.
Re: OracleDirect - TSQLConnection
Posted: Mon 18 Aug 2014 08:09
by martinw30
Oracle 12
Re: OracleDirect - TSQLConnection
Posted: Mon 18 Aug 2014 08:41
by martinw30
quote them did not help.
/Martin
Re: OracleDirect - TSQLConnection
Posted: Mon 18 Aug 2014 08:47
by martinw30
I can from Delphi IDE login, but when I do TSQLConnection.open in runtime it raises exception, same parameters in runtime as designtime.
Re: OracleDirect - TSQLConnection
Posted: Mon 18 Aug 2014 11:52
by 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.
Re: OracleDirect - TSQLConnection
Posted: Mon 18 Aug 2014 12:11
by martinw30
dbexpoda40.dll 6.4.7 in windows directory any other dependecies?
Can Delphi version XE2 be an issue?
/M
Re: OracleDirect - TSQLConnection
Posted: Wed 27 Aug 2014 11:34
by 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.