dbForge Data Compare for Oracle connection issue
It doesn't appear to be let me select a connection type other than "Direct" when I want to connect using TNS.
The connection type field is greyed out and already populated with "Direct" and the drop down to change this value is unresponsive.
I have Oracle Instant Client 19.3 installed and the following tnsnames.ora and sqlnet.ora files in the /network/admin folder
(ADDRESS = (PROTOCOL = TCPS)(HOST = myhost.co.uk) (PORT = 9999))
(CONNECT_DATA = (SERVICE_NAME = MYSERVICE))
(SECURITY = (WALLET_DIRECTORY = D:\wallet)))
WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = D:\wallet)))
I have the relevant ORACLE_HOME and TNS_ADMIN system variable setup.
Using the above I can successfully connect to the database using both SQLPLUS and Oracle SQLDeveloper 19.1 (using TNS).
Is this a limitation of the data compare software/trial or can you tell me what I'm missing?
If TNS is unavailable, can you let me know how I populate the Direct connection screen to connect using TCPS and oracle wallet?