[Mapserver-users] Mapserver using MSSQL

Thu Jun 3 03:07:08 PDT 2004

This is a multi-part message in MIME format.

------=_NextPart_000_0065_01C4498D.33F16150
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear all,

Today, I am trying run MapServer under windows using MSSQL 2000. I have =
read previous thread/mails and try to follow every step but I got error =
like below :

msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_1'. =

msOGRFileOpen(): OGR error. Open failed for OGR connection `layer1.ovf'. =
File not found or unsupported format.=20

My Layer code :=20

LAYER
  NAME LAYER_1
  TYPE POLYGON
  STATUS DEFAULT
  CONNECTIONTYPE OGR
  CONNECTION "layer1.ovf"
  DATA "layer1"
  CLASS
    NAME 'My City'
    OUTLINECOLOR 128 128 128
    COLOR 225 225 185
    TEMPLATE "layer1.html"
  END
  HEADER "layer_1_header.html"
  FOOTER "layer_1_footer.html"=20
  METADATA
    WMS_TITLE "My City"
    WMS_ABSTRACT "Layer Shapefile."
    WMS_SRS "EPSG:26915"
  END
END

and my layer1.ovf :

<OGRVRTDataSource>
    <OGRVRTLayer name=3D"LAYER_1">
        <SrcDataSource>ODBC:sa/kalpin at mstest</SrcDataSource>=20
  <SrcLayer>River</SrcLayer>=20
 <GeometryType>wkbPoint</GeometryType>=20
        <LayerSRS>LAYER_1</LayerSRS>
 <GeometryField encoding=3D"PointFromColumns" x=3D"x" y=3D"y"/>=20
    </OGRVRTLayer>
</OGRVRTDataSource>

Help me please

Thank you

Kalpin Erlangga Silaen
------=_NextPart_000_0065_01C4498D.33F16150
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=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Dear all,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Today, I am trying run MapServer under =
windows=20
using MSSQL 2000. I have read previous thread/mails and try to follow =
every step=20
but I got error like below :</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV>msDrawMap(): Image handling error. Failed to draw layer named =
'LAYER_1'.=20
<BR>msOGRFileOpen(): OGR error. Open failed for OGR connection =
`layer1.ovf'.=20
File not found or unsupported format. <BR></DIV>
<DIV><FONT face=3DArial size=3D2>My Layer code : </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>LAYER<BR>  NAME LAYER_1<BR>  =
TYPE=20
POLYGON<BR>  STATUS DEFAULT<BR>  CONNECTIONTYPE OGR<BR> =20
CONNECTION "layer1.ovf"<BR>  DATA "layer1"<BR> =20
CLASS<BR>    NAME 'My City'<BR>    =
OUTLINECOLOR=20
128 128 128<BR>    COLOR 225 225 =
185<BR>   =20
TEMPLATE "layer1.html"<BR>  END<BR>  HEADER=20
"layer_1_header.html"<BR>  FOOTER "layer_1_footer.html" <BR> =20
METADATA<BR>    WMS_TITLE "My City"<BR>    =

WMS_ABSTRACT "Layer Shapefile."<BR>    WMS_SRS=20
"EPSG:26915"<BR>  END<BR>END</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>and my layer1.ovf :</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial =
size=3D2><OGRVRTDataSource><BR>   =20
<OGRVRTLayer =
name=3D"LAYER_1"><BR>       =20
<SrcDataSource>ODBC:sa/kalpin at mstest</SrcDataSource>=20
<BR>  <SrcLayer>River</SrcLayer>=20
<BR> <GeometryType>wkbPoint</GeometryType>=20
<BR>       =20
<LayerSRS>LAYER_1</LayerSRS><BR> <GeometryField=20
encoding=3D"PointFromColumns" x=3D"x" y=3D"y"/> =
<BR>   =20
</OGRVRTLayer><BR></OGRVRTDataSource></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Help me please</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thank you</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Kalpin Erlangga =
Silaen</FONT></DIV></BODY></HTML>

------=_NextPart_000_0065_01C4498D.33F16150--