Specifying table cache using Advantage ODBC
Connection string
This Advantage ODBC Driver connection string can be used for connections to Sybase Advantage.
DataDirectory=\\servername\sharename\dictionaryfile.add;ServerTypes=2;
MaxTableCloseCache=20;
The number of tables to hold in cache when cursors are opened and closed. Default value is 25.