| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: OLEDB internal queries - last try
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
:-)
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 05 2007 - 02:19:38 CDT
 |
 |