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
DbExpress 4.2 PDB in Oracle 19c
Re: DbExpress 4.2 PDB in Oracle 19c
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
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!
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
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?