Sybase ODBC - QUERY_TIMEOUT missing on unix

Author

QUERY_TIMEOUT missing on unix

Marko Nikolic

2005-06-17, 9:23 am

Hello,

I'm using ASE 12.5.3 server on Win32 and client on Linux.
Client is connecting with DataDircet ODBC drivers, but there is missing
QUERY_TIMEOUT implementation in this drivers. It is mandatory for my
application to support this feature.

I have tried to simulate QUERY_TIMOUT by calling SQLExecute in a
separate thread, which is canceled after timeout has expired.
Cancelation of thread causes connection handle to become invalid,
and it is of no use any more.

Does anyone know of a method of canceling query that has timed out ?

Regards,
Marko Nikolic

Ashish Mahajan

2005-06-17, 11:23 am

Sybase has an ODBC driver on Linux. You can try migrating your application
to that. Look for OCS SDK 12.5.1 ESD8...
It does implement QueryTimeout however you will not be able to use that
connection handle... This is an open issue which will be addressed in a
future release.

If you do migrate the foll. is the behavior you will currently get:

1. Set the query timeout
2. Driver times out but returns an error "Connection has been lost..."
3. You will not be able to use this connection and have to shut it down

Again the above behavior is not by design but a bug in the current ODBC
driver and may not solve the issue you are currently having.

HTH,

Ashish

"Marko Nikolic" <marko. nikolic@noSPAMDMSgro
up.co.yu> wrote in message
news:42b2cbd7$1@foru
ms-2-dub...
> Hello,
>
> I'm using ASE 12.5.3 server on Win32 and client on Linux.
> Client is connecting with DataDircet ODBC drivers, but there is missing
> QUERY_TIMEOUT implementation in this drivers. It is mandatory for my
> application to support this feature.
>
> I have tried to simulate QUERY_TIMOUT by calling SQLExecute in a
> separate thread, which is canceled after timeout has expired.
> Cancelation of thread causes connection handle to become invalid,
> and it is of no use any more.
>
> Does anyone know of a method of canceling query that has timed out ?
>
> Regards,
> Marko Nikolic

Marko Nikolic

2005-06-20, 3:23 am

Thanks for the answer, but....

Linux is only development environment, all code must run on Tru64 unix.
I must use DataDirect drivers, since this drivers are recomended by HP
on Tru64 platform.

Are there any other suggestions ?

Thanks in advance,
Marko Nikolic

Ashish Mahajan wrote:
> Sybase has an ODBC driver on Linux. You can try migrating your application
> to that. Look for OCS SDK 12.5.1 ESD8...
> It does implement QueryTimeout however you will not be able to use that
> connection handle... This is an open issue which will be addressed in a
> future release.
>
> If you do migrate the foll. is the behavior you will currently get:
>
> 1. Set the query timeout
> 2. Driver times out but returns an error "Connection has been lost..."
> 3. You will not be able to use this connection and have to shut it down
>
> Again the above behavior is not by design but a bug in the current ODBC
> driver and may not solve the issue you are currently having.
>
> HTH,
>
> Ashish
>
> "Marko Nikolic" <marko. nikolic@noSPAMDMSgro
up.co.yu> wrote in message
> news:42b2cbd7$1@foru
ms-2-dub...
>

Sponsored Links