
TimeOut of Query ODBC database
We have an app. connecting to a sybase table via ODBC, which contains a
data control which is the source for True DBGrid. On small queries,
everything works fine, but on large queries, the app. is falling over
with an ODBC timeout. With the data control (data1) I have tried adding
in code data1.database.querytimeout = 10. Whatever the value is being 0
or 10000 it does not seem to recognise this value and goes for the
default of 60 - 90 seconds. We need to use the data control so the
dbengine would not really be appropriate. Any options ?
Is there are another way to set the timeout value ? ie in an ini file or
???
Any help would be greatly appreciated.
Thanks,
Shane N.