The Oracle Connection String

The Connection String for an Oracle database requires a special parameter that you must code manually.

Add the following parameter, highlighted above, to your Connection element's Connection String attribute: PLSQLRSet=1 This informs the OLEDB provider that row sets can be returned (in the example above, an OLEDB provider supplied by Oracle has been installed and is used). Check here to see examples of Oracle connection strings for a variety of configurations and circumstances. All must include the parameter shown above in order to return row sets.