OraOLEDB.OracleControling the chunksize

This one specifies the size, in bytes, of the data in LONG and LONG RAW columns fetched and stored in the provider cache.

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;
Password
=myPassword;ChunkSize=200;

Providing a high value for this attribute improves performance, but requires more memory to store the data in the rowset. Valid values are 1 to 65535. The default is 100.

Connecting

This connection string (Controling the chunksize 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.