Connecting to Oracle Autonomous instances with Unidac

Connecting to Oracle Autonomous instances with Unidac

Hello,

We are using Unidac in Delphi 11 to connect to Oracle Autonomous instances in Direct mode but we can't get it to work.

If we give "adb.region.oraclecloud.com" as the server and valid user/password credentials, we receive the following error:

ora-03113 end-of-file on communication channel

Considering that we have a working JDBC connection string and having read some doc (https://docs.devart.com/dotconnect/oracle/OracleAutonomousDatabase.html) we tried putting this as the TUniConnection.ConnectionString value:


Provider Name=Oracle;Direct=True;Host="(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1521)(host=adb.region.oraclecloud.com))(connect_data=(service_name=prefix.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))";User ID=User;Password=SomePassword;SpecificOptions="ProxyPort=0"

But this fails too, with OraNetClassesUni raising an exception with the following message:

IOHandler is not specefied

Apart from the typo in the last word, I can't see anything remotely helpful with this message.

What have we missed here?