 | | | -none- | -none- 2007-09-05 - By Alvaro Jose Fernandez
Back
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
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
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas
-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
address
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
font-style:italic;}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EstiloCorreo17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@(protected) Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=ES link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi Dennis,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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.<o:p></o:p></span><
/font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Anyway, thanks for your comments.<o:p></o
:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>alvaro<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>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. <o:p></o:p><
/span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> 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.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> Perhaps someone else can provide more
clarifying details.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Dennis Williams<o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>
|
|
|