OraOLEDB.OracleControling the fetchsize

This one specifies the number of rows the provider will fetch at a time (fetch array).

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

The FetchSize value must be set appropriately depending on the data size and the response time of the network. If the value is set too high, this could result in more wait time during the execution of the query. If the value is set too low, this could result in many more round trips to the database. Valid values are 1 to 429,496,296. The default is 100.

Connecting

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