Hi,
I have a desktop VB application which connects to an Oracle 11g database. Untill now it has been using the Microsoft ODBC for Oracle driver (MSDASQL.DLL) to connect to the Oracle DSNs. Now I wish to change over to the "Oracle in OraHome11g_home1" driver (MSDAORA.DLL).
When the above change is made, the application connects fine and the select queries (simple fetches without aggregate functions) execute alright. However I am facing issues, when I try to execute complex SQL statements such as statements invoking stored procedures and returning recordsets.
This gives an oracle error. The error is "-2147217887 Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done".
If anybody has worked on something similar or can give pointers on the same, and similar such issues that we might encounter because of the driver change. Thanks.