-none- 2007-09-04 - By Dennis Williams
Back
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
<div>Alvaro,<br><br>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.
</div>
<div> 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.</div>
<div> Perhaps someone else can provide more clarifying
details.</div>
<div> </div>
<div>Dennis Williams</div>
|
|
