Informix odbc attempt to connect to database server failed

#INFORMIX ODBC ATTEMPT TO CONNECT TO DATABASE SERVER FAILED SERIAL#

In practice, I just created a linked server locally with the default settings, turned off the target instance, and tried to query it. The default value for this option is 10 seconds. The connection is somewhat flaky though, and everything is much slower than with the other databases I use (mssql 2k and mysql). The remote login timeout option specifies the number of seconds to wait before returning from a failed attempt to log in to a remote server. I'm using kettle with informix since 2.3.0 (now 2.5.1) without much problems, through ODBC. The description from here sounds like the thing we're looking for: Sp_configure doesn't support an option called 'connect timeout' but has one called 'remote login timeout' (see Server Configuration Options). I installed the IBM Informix ODBC Driver for 64bit and ran. Time-out valuein seconds for connecting to a linked server. Solved: Hello, I have been trying all day to get an ODBC connection to our new informix server. You can increase the timeout to 20 seconds by doing the following: EXEC you need to change the connect timeout to something higher because seconds 20 seconds is too low: EXEC docs on the default value for 'connect timeout' are a little confusing. The default connection timeout on linked servers is 10 seconds (represented by '0' on the settings screen).

#INFORMIX ODBC ATTEMPT TO CONNECT TO DATABASE SERVER FAILED SERIAL#

If you don't want to use that option (you mentioned not wanting the overhead of configuring ODBC connections on all your cluster servers), another solution would be to increase the (linked) server-level connection timeout setting to a value that's high enough to deal with the serial connection attempts. This increases the chances that a connection will be made successfully before reaching the connection timeout limit. The way that setting deals with the problem is attempting many connections in parallel, rather than one after the other (the default behavior). Can I connect to 2 informix database but from the different INFORMIXSERVER I am using Powerbuilder 5.04 and Informix SetNet32. The solution you linked to overcomes the problem with connecting to multi-subnet failover groups by using the MultiSubnetFailover=True connection string setting. two informix server connect to powerbuilder database profile Please give me some feedback as it is real urgent.

Informix odbc attempt to connect to database server failed