Zeos hangs on Connect attempt to non-existent MySQL DB

[cmatrix]

If a Zeos app tries to connect to a non-existent MySQL DB it will hang indefinitely. This does not happen with ADO/MS SQL.

Adding a Timeout to the connection properties does nothing.

Looking through the previous posts this is a known issue. Anyone find a workaround?

[EgonHugeist]

cmatrix,

a good hint. But this is implemented by MySQL and here Zeos can't handle that AFAIK.

http://stackoverflow.com/questions/2436 ... n-in-mysql

execute 'SHOW VARIABLES LIKE 'wait_timeout';'. The defaults are 28800 secs. So if you would be more patiance.. 8hours then...((((:

Follow these instructions. Or do i musunderstand your question?

[cmatrix]

cmatrix,

a good hint. But this is implemented by MySQL and here Zeos can't handle that AFAIK.

http://stackoverflow.com/questions/2436 ... n-in-mysql

execute 'SHOW VARIABLES LIKE 'wait_timeout';'. The defaults are 28800 secs. So if you would be more patiance.. 8hours then...((((:

Follow these instructions. Or do i musunderstand your question?

No, that is good. Thank you.

[EgonHugeist]

cmatrix,

it would be nice if you can confirm my suggestion eventually? I couldn't test it by my selves..

[mdaems]

I wonder if previous proposals did work.
Without having tried it mysqlf I would guess http://dev.mysql.com/doc/refman/5.5/en/ ... tions.html will be of more use. Because I think it's not a server side problem. It's the connection library that's waiting too long before concluding it doesn't succeed in making the connection.
Does adding 'MYSQL_OPT_CONNECT_TIMEOUT=5' to the connection properties help?

Mark