While connecting to TIBCO ComputeDB data source using ODBC driver, it fails with the below error. "Connection Failed : Unreachable server."
Article ID: KB0075567
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.
While connecting to ComputeDB Data source, it fails with the below error.
https://community.tibco.com/wiki/tibco-spotfire-connectivity-tibco-computedb
========
Connection Failed : Unreachable server.
========
Refer to the below documentation on setting up ComputeDB ODBC driver.
While connecting to ComputeDB Data source, it fails with the below error.
https://community.tibco.com/wiki/tibco-spotfire-connectivity-tibco-computedb
========
Connection Failed : Unreachable server.
========
Issue/Introduction
While connecting to TIBCO ComputeDB data source using ODBC driver, it fails with the below error. "Connection Failed : Unreachable server."
Environment
All Supported Operating Systems.
Resolution
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.
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.
Additional Information
TIBCO Spotfire® Connectivity to TIBCO ComputeDB™
https://community.tibco.com/wiki/tibco-spotfire-connectivity-tibco-computedb
Feedback
Yes
No
Powered by
