Re: OLEDB internal queries - last try
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: alvaro.fernandez@xxxxxxxxx
- Date: Tue, 4 Sep 2007 21:42:43 -0500
Alvaro,
I am not an OLE / ADO programmer so I can't explain this properly. At a
previous job I had a good VB programmer accompany me and explain this
situation in terms that other VB programmers could understand. Here is what
I understand: ADO / OLE / VB can connect to many different data sources.
These sources can even be simple flat files. By default, it assumes the data
source is very simple, so it deals with it in a simple manner. For Oracle,
this works out to being asked to download the entire table, which clogs the
network.
My understanding is this isn't a bug, but a matter of choosing ADO /
OLE / VB options to let it know that it is dealing with something more
sophisticated than a flat file.
Perhaps someone else can provide more clarifying details.
Dennis Williams
Other related posts:
