DbExpress 4.2 PDB in Oracle 19c

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
tdobe
Posts: 4
Joined: Sat 10 Oct 2020 11:40

DbExpress 4.2 PDB in Oracle 19c

Post by tdobe » Sat 10 Oct 2020 11:49

Hi,

How to setup properties SQLConnection.Params.DataBase to connect to pluggable database Oracle 19c (PDB), is it possible in this driver?

Now my connection to non-PDB database 11g is: 10.14.2.2:1521:SID.

thx

MaximG
Devart Team
Posts: 1633
Joined: Mon 06 Jul 2015 11:34

Re: DbExpress 4.2 PDB in Oracle 19c

Post by MaximG » Tue 20 Oct 2020 09:08

You can specify the database server in the HostName property of DevartOracleDirect DBX Driver, for example:

Code: Select all

SQLConnection.Params.Values['HostName'] := '10.14.2.2:1521:pdb1';

tdobe
Posts: 4
Joined: Sat 10 Oct 2020 11:40

Re: DbExpress 4.2 PDB in Oracle 19c

Post by tdobe » Fri 30 Oct 2020 10:53

OK, it works (when USE_SID_AS_SERVICE_LISTENER = ON),

Now I have a problem with the protocol:
ora-28040 no matching authentication protocol from Oracle

I used the option: SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11 in the sqlnet.ora file but the problem still exists!

MaximG
Devart Team
Posts: 1633
Joined: Mon 06 Jul 2015 11:34

Re: DbExpress 4.2 PDB in Oracle 19c

Post by MaximG » Fri 30 Oct 2020 14:40

Oracle 19c support is available in our driver starting with version 7.1.2 (28-Nov-19). What version of our driver are you using?

Post Reply