Howto Set/Get Query and Connection Timeouts in Zeos?
Tx for help.
timeouts query/connection
Moderators: gto, cipto_kh, EgonHugeist
timeouts query/connection
fabian
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
Hi Fabian,
Depends fully on the database. All this kind of options are db independent.
For mysql you can look in 'TZMySQLConnection.Open'. There somebody tried to implement this. I never tried. As you see, the options available in the API are not all implemented. Just compression and timeout. Whether this works or not? No idea. Getting this information is impossible as far as I know (unless you query something like "show session variables like '%timeout%'")
Ideas about a general solution?
Mark
Depends fully on the database. All this kind of options are db independent.
For mysql you can look in 'TZMySQLConnection.Open'. There somebody tried to implement this. I never tried. As you see, the options available in the API are not all implemented. Just compression and timeout. Whether this works or not? No idea. Getting this information is impossible as far as I know (unless you query something like "show session variables like '%timeout%'")
Ideas about a general solution?
Mark