Hi Mike,

The ConnectTimeOut connection property controls ODBC timeout. The OS itself can introduced additional delays before it returns control back to ODBC driver.

>
>=sqlsetprop(0,'connecttimeout',5)
>
>I understand executing the above statement before using a stringconnect, will set the connection timeout when attempting connection to a remote server to 5 seconds. If the server is not available or the internet connection is down, the time taken is always around 20 seconds regardless of the sqlsetprop setting.
>
>What am I doing wrong? Are there other settings that need adjustment?
>
>