6.6.2-RC Connection Timeout

[ChaosBiker]

Is there a way to modify connection timeout?
Say be able to have connect give up after x number of seconds?

[mdaems]

Depends on your database.
For mysql it should be as easy as adding 'timeout=x' to the ZConnection.Properties

Mark

[seawolf]

Firebird at the moment does not support timeout=X but changing:

ZdbcInterbsae6.pas

Append at the end of "constructor TZInterbase6Connection.Create"

ConnectTimeout := StrToIntDef(Info.Values['timeout'], -1);
if ConnectTimeout >= 0 then
self.Info.Values['isc_dpb_connect_timeout'] := IntToStr(ConnectTimeout);

(declaring ConnectTimeout : integer; at the beginning of that function)

ZDbcInterbase6Utils.pas

case ParamNo of
0: Continue;
isc_dpb_set_db_SQL_dialect:
Dialect := StrToIntDef(ParamValue, 0);
isc_dpb_user_name, isc_dpb_password, isc_dpb_password_enc,
isc_dpb_sys_user_name, isc_dpb_license, isc_dpb_encrypt_key,
isc_dpb_lc_messages, isc_dpb_lc_ctype, isc_dpb_sql_role_name, isc_dpb_connect_timeout:

Adding "isc_dpb_connect_timeout" after ", isc_dpb_sql_role_name, "

[ChaosBiker]

"
Depends on your database.
For mysql it should be as easy as adding 'timeout=x' to the ZConnection.Properties
"

asume x is in seconds?

does the same work for MSSQL ?

[ChaosBiker]

adding
timeout=5
to properties, does NOT seem to work
it's still sitting waiting there for quite a while, until it finally gives up...

[mdaems]

I think you were using Mssql...

Can you set a debug point in procedure TZDBLibConnection.InternalLogin ? In that function the timeout value should be set Can you step trough to see if that's handled allright?. If you're using the ADO protocol, the timeout property isn't supported, however.

[ChaosBiker]

usign MSSQL

once I get that working mysql is next.
will have a look at the TZDBLibConnetion