Devart Forums

We are currently using Delphi 13.3 and dbexpress for Oracle 7.2.1.
We are looking to change our Oracle client server database to the the cloud.
We looking into to moving to an Oracle Cloud Autonomous Database via Direct Connect...ie Connection Name = DevArt Oracle Direct.
Is there a tutorial as to how to do this?

For example:...using TSQLConnection
DataBase=OracleTestDb
DriverName=DevartOracleDirect
HostName=OracleTestHostName

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

I get the following generic error "ORA-03113:end-of-file on communication channel".

If I take the information from TNS names... I use
test_high = (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=xxxx.oraclecloud.com))(connect_data=(service_name=yyyy.oraclecloud.com))(security=(ssl_server_cert_dn="zzzz")))

SQLConnection.Params.Values['HostName'] := 'xxxx.oraclecloud.com:1522:yyyy.oraclecloud.com';
SQLConnection.Params.Values['User_Name'] := 'myUserName';
SQLConnection.Params.Values['Password'] := 'myPassword';

I set my SQLConnection to connected=true then I get "ORA-03113:end-of-file on communication channel". I have worked through some various scenarios and appear stuck at this point.
With the Oracle Cloud database am I missing something else ? like including the security/ssl certificate? or the Oracle Cloud Wallet/Client Credentials in the SQLConnection?


On a side note I also have the dbx SQLServer product and do a direct connect to an Azure SQLServer database and all works very easily.

Currently Devart dbExpress Driver forOracle doesn't support SSL connection in Direct Mode. You can leave your suggestions at our UserVoice page (https://devart.uservoice.com/forums/225 ... rt-general), and if there are many votes for your suggestion, we will implement it.