Oracle connector with TCPS not working in VS 2019

Question

Hi,

I am using Oracle connector to connect to Oracle source database outside the domain which is using TCPS protocol and got below error.

Error: There was an error trying to establish an Oracle connection with the database server.

Note: I am able to connect to Oracle source database that is using TCP protocol inside our domain but not able to establish the connection to Oracle source database which is outside the domain ( different domain ) using TCPS protocol.

Any help is appreciated.

Thanks

Answer 1

Hi @SANDEEP TADISHETTY ,

Please first make sure that you target server version is SQL Server2019.

When using TNS service name in tnsnames.ora, user may encounter this error if the environment is not set right. There are few ways to fix:

1.Add TNS_ADMIN to system environment variable, which value is the path of tnsnames.ora file.
2.Set OracleHome and OracleHome64 in Oracle connection manager to tnsnames.ora path in x86 and x64 Oracle client respectively.
3.Use format [//]host[:port][/service_name] in the TNS service name field in connection manager to connect instead.

Reference: Microsoft Connector for Oracle is released for SQL Server 2019 Preview

oracle-connection-manager

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.