Page 1 of 1
DbExpress 4.2 PDB in Oracle 19c
Posted: Sat 10 Oct 2020 11:49
by tdobe
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
Re: DbExpress 4.2 PDB in Oracle 19c
Posted: Tue 20 Oct 2020 09:08
by MaximG
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';
Re: DbExpress 4.2 PDB in Oracle 19c
Posted: Fri 30 Oct 2020 10:53
by tdobe
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!
Re: DbExpress 4.2 PDB in Oracle 19c
Posted: Fri 30 Oct 2020 14:40
by MaximG
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?