Devart Forums

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

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,

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