<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML DIR=ltr><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"></HEAD><BODY>
<DIV id=idOWAReplyText46141 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi all,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>I've found references to this
problem in the list, but no solution:</FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>I've got an application
developed in our office that uses ODBC connections and OVF files to publish
several layers from an Oracle database. All is working well in our office;
however, this week I am implementing the app in the client's environment, and
mapserver is failing on trying to load the virtual layers (no mapserver error,
just never get a map back). </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Using OGRINFO I can see the
data, but I get an error message before the results are listed:<BR>ERROR1:
SetAttributeFilter() not supported on ExecuteSQL() results</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>I am presuming that this
error is also the reason why the layer doesn't draw in mapserver.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Does anyone have any insight
as to what this error means?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Thanks in
advance,</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Mark Adams<BR>DPRA
Canada</FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2></FONT> </DIV></DIV>
<DIV id=idSignature97294 dir=ltr><FONT face=Arial color=#000000 size=2><FONT
face="Times New Roman" color=navy size=2><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy">
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy; mso-ansi-language: EN-CA">------------------------------</SPAN><SPAN
style="COLOR: black"><?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy; mso-ansi-language: EN-CA">Mark
Adams</SPAN><SPAN style="COLOR: black"><o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy; mso-ansi-language: EN-CA">Senior Analyst
& Project Manager</SPAN><SPAN style="COLOR: black"><o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy; mso-ansi-language: EN-CA">Cuesta Systems
(DPRA <?xml:namespace prefix = st1 ns =
"urn:schemas-microsoft-com:office:smarttags" /><st1:country-region
w:st="on"><st1:place
w:st="on">Canada</st1:place></st1:country-region>)</SPAN><SPAN
style="COLOR: black"><o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><st1:Street
w:st="on"><st1:address w:st="on"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy; mso-ansi-language: EN-CA">5230 South
Service Road</SPAN></st1:address></st1:Street><SPAN
style="COLOR: black"><o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><st1:place w:st="on"><st1:City
w:st="on"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy; mso-ansi-language: EN-CA">Burlington</SPAN></st1:City><SPAN
lang=EN-CA style="FONT-SIZE: 10pt; COLOR: navy; mso-ansi-language: EN-CA">,
<st1:State w:st="on">ON</st1:State> <st1:PostalCode w:st="on">L7L
5K2</st1:PostalCode></SPAN></st1:place><SPAN
style="COLOR: black"><o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy; mso-ansi-language: EN-CA">Phone:
905-333-4544 x14</SPAN><SPAN style="COLOR: black"><o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy; mso-ansi-language: EN-CA">Fax:
905-333-0455</SPAN><SPAN style="COLOR: black"><o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy; mso-ansi-language: EN-CA">Email:
mark.adams@dpra.com</SPAN><SPAN style="COLOR: black"><o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal></SPAN></FONT> </DIV></FONT></DIV></BODY></HTML>