Forum Stats

  • 3,872,915 Users
  • 2,266,490 Discussions
  • 7,911,382 Comments

Discussions

Error 2147217887(80040e21) changing Oracle Provider in ODBC from "Microsoft ODBC for Oracle" to "Ora

2742274
2742274 Member Posts: 1
edited Aug 29, 2014 8:38AM in ODBC


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.


Answers

This discussion has been closed.