Reducing (Oracle) ODBC bugs as much as possible?

[Sten Westerback]

Hi

Do anyone know which Oracle ODBC driver version is the
most bug free? As one can see in numerous articles on the net
there is clearly a resource leak in the ODBC driver and also
in the Microsoft MDAC modules (which can be fixed).

I have now tried with Oracle 8i and 9i and both experience
different problems. Version 8, according to Process Explorer
(sysinternals.com), leaves a event handle behind for every query
and version 9 leaves two semaphores and manages to close an event
handle. The unnamed kernel objects are probably from inside a
critical section that isn't removed properly especially if the query
is very short and fast. Use of connection pooling might also play a role.

Anyway, do anyone have experience about this? Should i get version 10
and hope it has got those problems removed? Or could it be that there
is also some problem in the ODBC interface itself?

A code snipet:

SQLAllocHandle(SQL_HANDLE_ENV, NULL, &henv);
SQLAllocHandle(SQL_HANDLE_DBC, NULL, &hdbc);
if (SQLDriverConnect(hdbc, .... )
{
SQLFetch(...
}
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
....

There are also, according to BoundChecker, many other bugs in
Oracles code.. like sprintf and fopen stuff -- which make me believe
BoundChecker might be wrong too?

- Sten