While connecting to TIBCO ComputeDB data source using ODBC driver, it fails with the below error. "Connection Failed : Unreachable server."
book
Article ID: KB0075567
calendar_today
Updated On:
Products
Versions
TIBCO ComputeDB
1.1.1 and higher
Description
There are generally two ways to connect to TIBCO ComputeDB data source, one is using JDBC Connections and other is using ODBC connection. While connecting through JDBC connection, the connection is established using a thrift server on port 10000, whereas while connecting through ODBC connection, it requires TIBCO ComputeDB ODBC driver to connect to the server on the port 1527. Also, through JDBC connection, users can also connect to the cluster via JDBC either to a locator or directly to a server at default port 1527, just like ODBC.
Refer to the below documentation on setting up ComputeDB ODBC driver.
There are multiple reasons on failure of ODBC connection to TIBCO ComputeDB Data source.
1. The port 1527 is disabled using Firewall. One is required to check the rules on port 1527. 2. It is recommended to install same version of TIBCO ComputeDB ODBC driver as of TIBCO ComputeDB version one is trying to connect. 3. ODBC driver cannot connect to the locator and must connect directly to one of the servers. Therefore, in cases where you start a cluster with multiple nodes on different machines and if the server and locator are collocated on a specific machine, then the port number of the server would be higher than that of the locator port which will be 1528. In case the locator is not co-located with the server on a machine then the server port will be 1527.
Issue/Introduction
While connecting to TIBCO ComputeDB data source using ODBC driver, it fails with the below error. "Connection Failed : Unreachable server."