[Mapserver-users] New User : Mapserver connection to Oracle 9i

Fri Oct 3 13:01:50 PDT 2003

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C389E9.2F2205D0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
=20
I'm new to Mapserver.  Could someone give me an example of simple but
complete Map File to connect to Oracle with Mapserver CGI?
=20
I tried this but Mapserver asked me for a Template file...
=20
# Mapserver test 1 for Oracle
# Nicolas Fortin, Env Can nicolas.foritn at ec.gc.ca
<mailto:nicolas.foritn at ec.gc.ca>=20
=20
NAME MS_ORA_TEST_1
EXTENT 330630 5097000 342000 5103000
SIZE 400 300
=20
LAYER # Test table
  NAME "PolygonTest"
  CONNECTIONTYPE oraclespatial
  CONNECTION "usr_lidar/******@bayfield =
<mailto:usr_lidar/******@bayfield> "
  DATA "GEOLOC FROM USR_LIDAR.POLY1"
  STATUS DEFAULT
  TYPE POLYGON
 =20
  PROJECTION
    "init=3Depsg:2144"
  END
=20
  CLASS # PolyClass
    NAME "Polygon"
    COLOR 240 240 240
    OUTLINECOLOR 0 0 0
  END # end of PolyClasse
END # end of layer object
END # end of map file

=20

Nicolas Fortin=20
Math=E9maticien, Programmeur, Analyste de donn=E9es=20
SMC-Qu=E9bec Hydrologie, Environnement Canada=20
1141, Rte de l'=C9glise, Sainte-Foy(QC) G1V 4H5=20
(418)648-2516=20
nicolas.fortin at ec.gc.ca <mailto:nicolas.fortin at ec.gc.ca
<mailto:nicolas.fortin at ec.gc.ca> >=20

=20

------_=_NextPart_001_01C389E9.2F2205D0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Message</TITLE>

<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial=20
size=3D2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial size=3D2>I'm =
new to=20
Mapserver.  Could someone give me an example of simple but =
complete Map=20
File to connect to Oracle with Mapserver CGI?</FONT></SPAN></DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial size=3D2>I =
tried this but=20
Mapserver asked me for a Template file...</FONT></SPAN></DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial size=3D2># =
Mapserver test 1=20
for Oracle<BR># Nicolas Fortin, Env Can <A=20
href=3D"mailto:nicolas.foritn at ec.gc.ca">nicolas.foritn at ec.gc.ca</A></FON=
T></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial size=3D2>NAME=20
MS_ORA_TEST_1<BR>EXTENT 330630 5097000 342000 5103000<BR>SIZE 400=20
300</FONT></SPAN></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial size=3D2>LAYER =
# Test=20
table<BR>  NAME "PolygonTest"<BR>  CONNECTIONTYPE=20
oraclespatial<BR>  CONNECTION "<A=20
href=3D"mailto:usr_lidar/******@bayfield">usr_lidar/******@bayfield</A>"=
<BR> =20
DATA "GEOLOC FROM USR_LIDAR.POLY1"<BR>  STATUS DEFAULT<BR>  =
TYPE=20
POLYGON<BR>  <BR>  PROJECTION<BR>   =20
"init=3Depsg:2144"<BR>  END</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial =
size=3D2>  CLASS #=20
PolyClass<BR>    NAME "Polygon"<BR>    =
COLOR 240=20
240 240<BR>    OUTLINECOLOR 0 0 0<BR>  END # end of =

PolyClasse<BR>END # end of layer object<BR>END # end of map=20
file<BR></FONT></SPAN></DIV>
<DIV> </DIV>
<P><B><I><FONT face=3D"Bookman Old Style" color=3D#000080 =
size=3D2>Nicolas=20
Fortin</FONT></I></B><I></I> <BR><B><FONT face=3DArial =
size=3D1>Math=E9maticien,=20
Programmeur, Analyste de donn=E9es</FONT></B> <BR><B><FONT face=3DArial =

size=3D1>SMC-Qu=E9bec Hydrologie, Environnement Canada</FONT></B> =
<BR><B><FONT=20
face=3DArial size=3D1>1141, Rte de l'=C9glise, Sainte-Foy(QC) G1V =
4H5</FONT></B>=20
<BR><B><FONT face=3DArial size=3D1>(418)648-2516</FONT></B> =
<BR><U><FONT face=3DArial=20
color=3D#0000ff size=3D1>nicolas.fortin at ec.gc.ca <<A=20
href=3D"mailto:nicolas.fortin at ec.gc.ca">mailto:nicolas.fortin at ec.gc.ca</=
A>></FONT></U>=20
</P>
<DIV> </DIV></BODY></HTML>

------_=_NextPart_001_01C389E9.2F2205D0--