FreeLists / oracle-l / Re: OLEDB internal queries - last try

[Grant Allen <gxallen@xxxxxxxxx>]

Alvaro Jose Fernandez wrote:
> Hi Dennis,
>
>  
>
> Thanks for the comments. No, this is Oracle bug in the implementation 
> of the provider, since if we use (for example) Microsoft OLEDB 
> provider, these queries are not generated.
>  
>
> Anyway, thanks for your comments.
>
>  
>
> alvaro
Alvaro,

A couple of things might be useful in helping you with this.  The 
connection string used (no need to include the password or real 
server/user names), the connection object's properties (a very simple 
bit of VB should be able to iterate over these and print them out ... 
ask your VB devs), and the OLEDB_SERVICES value for the Oracle OLE DB 
provider from the registry.
In 11 years of writing c++, c#, and vb against Oracle's ODBC driver and 
OLE DB provider, I never saw your symptoms ... and we had regular 
religious wars about the comparative merits of server-side versus 
client-side cursors.
One other thing springs to mind as well.  Is your VB code calling Oracle 
stored procedures, and do these stored procedures include declarations 
using %TYPE or %ROWTYPE?  There are hideous bugs (i.e. massively 
increased sql noise and network traffic) with Oracle's implementation of 
these technologies in combination ... I can elaborate if this matches 
your situation.
Ciao
Fuzzy
:-)

------------------------------------------------
Dazed and confused about technology for 20 years
http://fuzzydata.wordpress.com/
--
http://www.freelists.org/webpage/oracle-l