OLE DB :: 10g R2 OLE-DB Provider?

Dec 1, 2012

we have a client side application, on Windows and Oracle 10g R2.We use OLEDB templates from MFC (CDynamic Paramete rAccessor).There is a long query (4610 char) what provider return E_UNEXPECTED HRESULT (from execute, before the bind).

No detailed info from provider (GetErrorRecords() return E_FAIL).If I copy this query into SQL* Plus, it run without error.There is an almost the same query run successfull, the difference is only in two added order by and alias column.

recordset properties was:
stPropSet.AddProperty(DBPROP_BOOKMARKS, true);
stPropSet.AddProperty(DBPROP_CANSCROLLBACKWARDS, true);
stPropSet.AddProperty(DBPROP_CANFETCHBACKWARDS, true);
stPropSet.AddProperty(DBPROP_QUICKRESTART, true);

[code]...

connection string is:
"Provider=OraOLEDB.Oracle;User ID=user;Password=pw;Data Source=foto1;ChunkSize=4000"

View 2 Replies


ADVERTISEMENT

ODP.NET :: Oracle Managed Provider Beta - Refresh?

Nov 15, 2012

I want to ask will be a beta refresh for managed provider soon. I reported a few bugs, one of them is a stopper and I wander are they fixed ?

Bug: Oracle Managed Provider and BindByName
and
Bug: Oracle Managed Provider and comments in SQL

View 0 Replies View Related

Windows :: Error / Test Failed / Provider Cannot Be Found

Feb 25, 2013

We just upgraded one of our databases to 11g on a new server. The 3rd party application that accesses the db is 32 bit. The software needs to be running on the db server in order for some transactions to occur. Since the oracle client on the db server is 64bit do we need to install a 32 bit client as well. As of right now we are getting an error in the software when trying to connect to the db that says "Test failed. provider cannot be found. it may not be properly installed." This is a live production server so uninstalling and reinstalling oracle is not really an option at this time (unless absolutely necessary). How will installing a 32 bit oracle client effect everything (if that is the route we need to take).

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved