[Mapserver-users] No Map Appear via ODBC

Fri Jun 4 04:38:40 EDT 2004

This is a multi-part message in MIME format.

------=_NextPart_000_00A6_01C44A4A.02A17EB0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear all,

I created LAYER like this :

LAYER
  NAME indo_wells
  TYPE POINT
  CONNECTIONTYPE OGR
  CONNECTION "ODBC:sa/kalpin at MSQL"
  DATA "SELECT * FROM TbWell"
  STATUS ON
  CLASS
    NAME 'WELLS'
    MAXSCALE 2000000
    SYMBOL 'circle'
    OUTLINECOLOR 128 128 128
    SIZE 10
    TEMPLATE "indo_wells.html"
  END
  HEADER "indo_wells_header.html"
  FOOTER "indo_wells_footer.html"
  TOLERANCE 5
  METADATA
    WMS_TITLE "Wells"
    WMS_ABSTRACT "Wells data for Indonesia region."
    WMS_SRS "EPSG:26915"
  END
END=20

But, No map appear at my browser. I think I make mistake with SQL =
command ? It's seem unsuccessfull query the data.

I have table TbWell at my MSSQL.

Anyone can help me please.

Best regards,

Kalpin Erlangga Silaen
------=_NextPart_000_00A6_01C44A4A.02A17EB0
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>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I created LAYER like this =
:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>LAYER<BR>&nbsp; NAME =
indo_wells<BR>&nbsp; TYPE=20
POINT<BR>&nbsp; CONNECTIONTYPE OGR<BR>&nbsp; CONNECTION=20
"ODBC:sa/kalpin at MSQL"<BR>&nbsp; DATA "SELECT * FROM TbWell"<BR>&nbsp; =
STATUS=20
ON<BR>&nbsp; CLASS<BR>&nbsp;&nbsp;&nbsp; NAME =
'WELLS'<BR>&nbsp;&nbsp;&nbsp;=20
MAXSCALE 2000000<BR>&nbsp;&nbsp;&nbsp; SYMBOL =
'circle'<BR>&nbsp;&nbsp;&nbsp;=20
OUTLINECOLOR 128 128 128<BR>&nbsp;&nbsp;&nbsp; SIZE =
10<BR>&nbsp;&nbsp;&nbsp;=20
TEMPLATE "indo_wells.html"<BR>&nbsp; END<BR>&nbsp; HEADER=20
"indo_wells_header.html"<BR>&nbsp; FOOTER =
"indo_wells_footer.html"<BR>&nbsp;=20
TOLERANCE 5<BR>&nbsp; METADATA<BR>&nbsp;&nbsp;&nbsp; WMS_TITLE=20
"Wells"<BR>&nbsp;&nbsp;&nbsp; WMS_ABSTRACT "Wells data for Indonesia=20
region."<BR>&nbsp;&nbsp;&nbsp; WMS_SRS "EPSG:26915"<BR>&nbsp; END<BR>END =

</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>But, No map appear at my browser. I =
think I make=20
mistake with SQL command ? It's seem unsuccessfull query the =
data.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I have table TbWell at my =
MSSQL.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Anyone can help me please.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Best regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Kalpin Erlangga =
Silaen</FONT></DIV></BODY></HTML>

------=_NextPart_000_00A6_01C44A4A.02A17EB0--