<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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>Hi all,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>I've been trying to publish an oracle spatial layer
in mapserver/mapscript using OGR, with no success. Mapserver tells me
"file not found or unsupported format"; running ogrinfo I get:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>"C:\Inetpub\mapserver>ogrinfo --debug on
oci:minfwhse_p1/minfwhse_p1@normin.ad.dp<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>ra.com references<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>OCI: Userid=minfwhse_p1, Password=minfwhse_p1,
Database=normin.ad.dpra.com<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>OCI: OCIEnvCreate() failed with status 2083788472.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>Presumably Oracle is not properly installed,
skipping.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>OGR:
OGROpen(oci:minfwhse_p1/minfwhse_p1@normin.ad.dpra.com) failed.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>OCI: Userid=minfwhse_p1, Password=minfwhse_p1,
Database=normin.ad.dpra.com<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>OCI: OCIEnvCreate() failed with status 2083788472.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>Presumably Oracle is not properly installed,
skipping.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>OGR:
OGROpen(oci:minfwhse_p1/minfwhse_p1@normin.ad.dpra.com) failed.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>FAILURE:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>Unable to open datasource
`oci:minfwhse_p1/minfwhse_p1@normin.ad.dpra.com' with<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>the following drivers.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'> -> OCI" etc<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>Any ideas about what OGR is looking for here?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>-Thanks in advance<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=navy
face="Times New Roman"><span lang=EN-CA style='font-size:10.0pt;color:navy'>------------------------------</span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=navy
face="Times New Roman"><span lang=EN-CA style='font-size:10.0pt;color:navy'>Mark
Adams</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=navy
face="Times New Roman"><span lang=EN-CA style='font-size:10.0pt;color:navy'>Senior
Analyst & Project Manager</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=navy
face="Times New Roman"><span lang=EN-CA style='font-size:10.0pt;color:navy'>Cuesta
Systems (DPRA Canada)</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=navy
face="Times New Roman"><span lang=EN-CA style='font-size:10.0pt;color:navy'>5230
South Service Road</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=navy
face="Times New Roman"><span lang=EN-CA style='font-size:10.0pt;color:navy'>Burlington,
ON L7L 5K2</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=navy
face="Times New Roman"><span lang=EN-CA style='font-size:10.0pt;color:navy'>Phone:
905-333-4544 x14</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=navy
face="Times New Roman"><span lang=EN-CA style='font-size:10.0pt;color:navy'>Fax:
905-333-0455</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=navy
face="Times New Roman"><span lang=EN-CA style='font-size:10.0pt;color:navy'>Email:
mark.adams@dpra.com</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-CA
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>