Memory leak VisualBasic / Access - Ora-ODBC - Ora-DB

Memory leak VisualBasic / Access - Ora-ODBC - Ora-DB

When I do many different selects against Oracle in the following way
(example), slowly my free RAM dissapears
and the application will stop because of that.

example:

Set TEST_DB = OpenDatabase("MTECS", False, False, "ODBC;DSN=MTECS;DBQ=DBSERVER;DBA=W;UID=MTECS;PWD=xxx;")

For i = 1 To 10000

  If i Mod 2 = 1 Then 'change every time the SQL-Statement     SQL$ = "Select Col1 from Tab1 where rownum =1"   Else
    SQL$ = "Select Col1 from Tab2 where rownum =1"   End If

  Set snResult = TEST_DB.OpenRecordset(SQL$, dbOpenSnapshot, dbSQLPassThrough)

  'or (same problem):
  Set snResult = TEST_DB.OpenRecordset(SQL$, dbOpenSnapshot, dbSQLPassThrough+dbForwardOnly)
  'or (same problem):
  Set snResult = TEST_DB.OpenRecordset(SQL$, dbOpenSnapshot)

  snResult.Close
Next i

After 30000 Selects I miss 1,8 MB of memory.
(In my program with inserts/updates its much more)

If I use always the same SQL-Statement I havenīt this problem. It seems to me, as if some part of ODBC keeps always some cache.

The bugfix list of Oracles ODBC driver V. 8.0.4.4.0 mentioned some fixed memory leaks, but still ...

• Fixed memory leak when a statement handle is reused to prepare and execute SQL statements. (Bug 620910)
• Fixed memory leak of 100 bytes that was occuring on SQLDriverConnect.

Does anybody know this problem ????
Any idea

ENVIRONMENT:
PROBLEMS / TESTED WITH Visual Basic 4.0 16 Bit / Access 2.0 / Access 97 - Win NT 4.0 SP3 / Win 95
ODBC-drviver: Oracle 8.00.0400 (=Version 8.0.4.4.0) (SQORA32.DLL 04.05.98) Oracle Server 8.00.4.0-Server

Greetings SvenKunze_at_aol.com Received on Wed Aug 19 1998 - 14:36:34 CDT