Hi all! Is there a way to set connection timeout for firebird at client side?
The default value is somewhere around 50 seconds and if i have wrong IP address set up in connection parameters then the application will freeze for almost a minute before it gives an error message that it couldn't connect. I'd like to reduce this waiting time to 5 seconds. At server side there is a ConnectionTimeout parameter, but it does not help me in this case (when i try to connect to an inexistent server, caused by wrong configuration). In real world example i have 2 servers configurations in a priority list (the development server and the production one). The production server is the highest priority one, so my clients have quick connection when they use the application. But when i'm in development environment (where the production server is not reachable) the application would first try the prod server then after failing it will try next server and my connection takes about a minute. I'd like this to be 5 seconds or less. (I know i could create connection definition files on each computer and rely on those files - but that would bring more administration issues which i don't want for this simple app) Can you help me? Thank you and have a happy new year!