Re: alter session

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Wed, 4 Nov 1998 11:32:27 +0200
Message-ID: <71p73k$1ve$1@hermes.is.co.za>

Detlev Goebel wrote in message <363ED9B0.BE652E3C_at_www.gzs.de>...

>this query is ok (1 min). I thought, by running the alter session
>command before the select statement will give me the correct results - but
ODBC
>runs the alter session command and the select statement
>is grouped by seconds. That means, that ODBC uses a new connect with each
>statement.

Yep, that is a problem. Can not remember much from ODBC, but it needs a new statement handle per statement, but the client can run each statement handle across a different db session handle or something. That is a problem with the way the particular interface to ODBC works - be it the Jet Engine , ADO, RDO, WHOKNOWS, DONTKNOW or any of the other confusing options you get for database access with VB (anyone else see a kind of desperation from Microsoft with all these options?).

But having said that. Microsoft does not consists of total idiots alone, so I guess that one of these access options will allow you to run multiple statements on a single db session handle. And if all else fails, there is Delphi... :-)

regards,
Billy Received on Wed Nov 04 1998 - 03:32:27 CST