OracleDirect - TSQLConnection

OracleDirect - TSQLConnection

Postby martinw30 » Fri 15 Aug 2014 13:45

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
martinw30
 
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: OracleDirect - TSQLConnection

Postby AlexP » Mon 18 Aug 2014 08:00

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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: OracleDirect - TSQLConnection

Postby martinw30 » Mon 18 Aug 2014 08:09

Oracle 12
martinw30
 
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: OracleDirect - TSQLConnection

Postby martinw30 » Mon 18 Aug 2014 08:41

quote them did not help.

/Martin
martinw30
 
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: OracleDirect - TSQLConnection

Postby martinw30 » Mon 18 Aug 2014 08:47

I can from Delphi IDE login, but when I do TSQLConnection.open in runtime it raises exception, same parameters in runtime as designtime.
martinw30
 
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: OracleDirect - TSQLConnection

Postby AlexP » Mon 18 Aug 2014 11:52

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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: OracleDirect - TSQLConnection

Postby martinw30 » Mon 18 Aug 2014 12:11

dbexpoda40.dll 6.4.7 in windows directory any other dependecies?

Can Delphi version XE2 be an issue?

/M
martinw30
 
Posts: 15
Joined: Fri 11 Jan 2013 13:46

Re: OracleDirect - TSQLConnection

Postby AlexP » Wed 27 Aug 2014 11:34

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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle