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

nicolas.fortin at ec.gc.ca nicolas.fortin at ec.gc.ca
Fri Oct 3 16:01:50 EDT 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>&nbsp;</DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial size=3D2>I'm =
new to=20
Mapserver.&nbsp; 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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial size=3D2>LAYER =
# Test=20
table<BR>&nbsp; NAME "PolygonTest"<BR>&nbsp; CONNECTIONTYPE=20
oraclespatial<BR>&nbsp; CONNECTION "<A=20
href=3D"mailto:usr_lidar/******@bayfield">usr_lidar/******@bayfield</A>"=
<BR>&nbsp;=20
DATA "GEOLOC FROM USR_LIDAR.POLY1"<BR>&nbsp; STATUS DEFAULT<BR>&nbsp; =
TYPE=20
POLYGON<BR>&nbsp; <BR>&nbsp; PROJECTION<BR>&nbsp;&nbsp;&nbsp;=20
"init=3Depsg:2144"<BR>&nbsp; END</FONT></SPAN></DIV>
<DIV>&nbsp;</DIV>
<DIV><SPAN class=3D826265519-03102003><FONT face=3DArial =
size=3D2>&nbsp; CLASS #=20
PolyClass<BR>&nbsp;&nbsp;&nbsp; NAME "Polygon"<BR>&nbsp;&nbsp;&nbsp; =
COLOR 240=20
240 240<BR>&nbsp;&nbsp;&nbsp; OUTLINECOLOR 0 0 0<BR>&nbsp; END # end of =

PolyClasse<BR>END # end of layer object<BR>END # end of map=20
file<BR></FONT></SPAN></DIV>
<DIV>&nbsp;</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 &lt;<A=20
href=3D"mailto:nicolas.fortin at ec.gc.ca">mailto:nicolas.fortin at ec.gc.ca</=
A>&gt;</FONT></U>=20
</P>
<DIV>&nbsp;</DIV></BODY></HTML>

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



More information about the mapserver-users mailing list