OraOLEDB.OracleControling rowset cache mechanism

Specifies the type of caching used by the provider to store rowset data. OraOLEDB provides two caching mechanisms; File and Memory.

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;

Memory is the default value. All the rowset data is stored in-memory which provides better performance at the expense of higher memory utilization.

File = All the rowset data is stored on disk. This caching mechanism limits the memory consumption at the expense of performance.


This connection string (Controling rowset cache mechanism using OraOLEDB.Oracle) can be used for connections to Oracle.

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.