12c Direct Connection Problem

12c Direct Connection Problem

Postby mmalinow » Mon 22 Jan 2018 19:10

Hello

We are currently using dbExpress for Oracle 4.90.0.25 with Delphi 2010 on Oracle 11g servers using direct connect. A decision to upgrade our servers to 12c has prompted us to investigate dbExpress for Oracle 6.10.14. We downloaded and installed the trial version of the latest dbExpress in our current development environment. We are able to connect to our 11g servers using the new driver.

When attempting to connect to the 12c test server we receive the following "ORA-01017: invalid username/password; logon denied". A code snippet of the method we have been using to connect is included below. Has something changed in the way the connection must be established?

with DataModule1.SqlConnection1 do
begin
Connected := False;
KeepConnection := False ;
LoadParamsOnConnect := False;
Params.Clear;

TheBDEAlias := cbServers.Text;
intAliasIndex := cbServers.Items.IndexOf(TheBDEAlias);
iPrevSelection := intAliasIndex;
SetServerParams(TheBDEAlias);
LoadDriverParams;

Params.Values['Database'] := 'linux-server.domain.com:1527:DEVTST';
Params.Values['Password'] := 'user_master_';
Params.Values['User_Name'] := 'user';
Params.Values['UseUnicode'] := 'False';
Params.Values['EnableBCD'] := 'False';
end;

try
DataModule1.SqlConnection1.Connected := True;
...

We appreciate your input on this matter as we wish to upgrade our dbExpress driver and proceed with further testing. We are just unsure as to what the cause of the problem is.

Sincerely,
Michael Malinowski
Production Resource Group
mmalinow
 
Posts: 24
Joined: Sat 14 May 2011 00:56

Re: 12c Direct Connection Problem

Postby MaximG » Tue 23 Jan 2018 16:13

We checked the performance of our driver when working with the Oracle 12c server and found no problems. Try downloading and installing the latest version of dbExpress Driver for Oracle 6.10.15 (27-Apr-2017). After that, connect to the test server (linux-server.domain.com) in OCI Mode. In case of successful connection in this mode, send us TNS Alias, with which this connection was established.
MaximG
Devart Team
 
Posts: 848
Joined: Mon 06 Jul 2015 11:34

Re: 12c Direct Connection Problem

Postby mmalinow » Tue 23 Jan 2018 16:21

MaximG,

I believe that the developer on our team who installed the trial discovered that dbexpoda40.dll was not updated to the latest version on the install. It appears that he is connecting now.

Thank you for your reply,
Mike Malinowski
mmalinow
 
Posts: 24
Joined: Sat 14 May 2011 00:56


Return to dbExpress driver for Oracle