Re: Handle count leak when connecting to Oracle via ODBC on Windows

likong_at_email.com (Kong Li) wrote in message news:<9e121089.0401261903.69879325_at_posting.google.com>...
> Environments:
> 1. WinXP SP1, MDAC 2.7 SP1 (Microsoft ODBC for Oracle is
> 2.573.9030.0), Oracle client 9.2.0.1.
> 2. Win2000 SP4, MDAC 2.7 SP1 (Microsoft ODBC for Oracle is
> 2.573.9030.0), Oracle client 9.2.0.1.
> 3. Win2000 SP4, MDAC 2.8 (Microsoft ODBC for Oracle is 2.573.1022.0),
> Oracle client 9.2.0.1.
>
> I have a simple program calling SQLDriverConnect (not OLEDB, not ADO,
> but ODBC) to an Oracle server 9.2, and then disconnect. The value of
> handle count increases by 2 each time I did the connect/disconnect.
> This has been verified on the above 3 environments. Turning on/off
> ODBC connection pooling does not change the handle count leakage.
>
> Connection caching is not an option for me since the application
> connects to a set of Oracle servers that keep changing.
>
> Is this a known problem? I did not try Oracle's own ODBC driver.
>
> Any pointers, ideas?
>
> Thanks.
>
> Kong
> likong_at_email.com

From the Microsoft ODBC's version number it looks like you are using a Oracle 7 compatible ODBC driver. I don't think Oracle 9.2 supports Oracle 7 connections any longer. You could verify the sqlnet version being used by selecting from v$session. If it shows TNS V1-V2 instead of TNS V1-V3 you are using an obsolete driver.

Sybrand Bakker
Senior Oracle DBA Received on Tue Jan 27 2004 - 02:29:00 CST