Using Microsoft SQL Server?

[Van Ulden, Joost]

Hi Chip, here are some snippets you can use:
 
#-----------------------------------------------------------------------
----------------
# Microsoft SQL Server
#-----------------------------------------------------------------------
----------------

 LAYER
  NAME [insert your layer name without spaces (eg. my_layer)]
  TYPE POINT
  CONNECTIONTYPE OGR
  CONNECTION 
  
  '<OGRVRTDataSource>
       <OGRVRTLayer name="[insert your layer name]">
        <SrcDataSource>ODBC:[insert user_name]/[insert password]@[insert
dsn name],[insert table name]</SrcDataSource> 
         <SrcLayer>[insert table name]</SrcLayer> # OR <SrcSQL>[insert
your sql statement (eg. SELECT Longitude,Latitude,... FROM
MyTable)]</SrcSQL>
        <GeometryType>wkbPoint</GeometryType> 
        <LayerSRS>WGS84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="[insert field name
(eg. Longitude)]" y="[insert field name (eg. Latitude)]"/> 
      </OGRVRTLayer>
  </OGRVRTDataSource>'

  DUMP TRUE # for WFS only
  DATA "[insert your layer name]"
  STATUS default
  CLASS
    SYMBOL 'circle'
    SIZE 25
    COLOR 255 0 0
  END
 END

#-----------------------------------------------------------------------
----------------
# FileMaker
#-----------------------------------------------------------------------
----------------

 LAYER
  NAME [insert your layer name without spaces (eg. my_layer)]
  TYPE POINT
  CONNECTIONTYPE OGR
  CONNECTION 
  
  '<OGRVRTDataSource>
     <OGRVRTLayer name="[insert your layer name]">
       <SrcDataSource>ODBC:[insert your dsn name],[insert your database
name]</SrcDataSource> 
       <GeometryType>wkbPoint</GeometryType> 
       <SrcSQL>[insert your sql statement (eg. SELECT
Longitude,Latitude,... FROM Earthquake)]</SrcSQL>
       <GeometryField encoding="PointFromColumns" x="[insert field name
(eg. Longitude)]" y="[insert field name (eg. Latitude)]"/> 
     </OGRVRTLayer>
  </OGRVRTDataSource>'

  DUMP TRUE # for WFS only
  DATA "[insert your layer name]"
  STATUS default
  CLASS
    SYMBOL 'circle'
    SIZE 25
    COLOR 255 0 0
  END
 END

#-----------------------------------------------------------------------
----------------
# Microsoft Access
#-----------------------------------------------------------------------
----------------

 LAYER
  NAME [insert your layer name without spaces (eg. my_layer)]
  TYPE POINT
  CONNECTIONTYPE OGR
  CONNECTION 
  
  '<OGRVRTDataSource>
       <OGRVRTLayer name="[insert your layer name]">
        <SrcDataSource>ODBC:[insert your dsn name],[insert your table
name]</SrcDataSource> 
        <SrcLayer><insert your table name></SrcLayer> 
        <GeometryType>wkbPoint</GeometryType> 
        <GeometryField encoding="PointFromColumns" x="[insert field name
(eg. Longitude)]" y="[insert field name (eg. Latitude)]"/> 
      </OGRVRTLayer>
  </OGRVRTDataSource>'

  DUMP TRUE # for WFS only
  DATA "[insert your layer name]"
  STATUS default
  CLASS
    SYMBOL 'circle'
    SIZE 25
    COLOR 255 0 0
  END
 END

#-----------------------------------------------------------------------
----------------
# GML
#-----------------------------------------------------------------------
----------------

 LAYER
  NAME [insert your layer name without spaces (eg. my_layer)]
  TYPE POINT
  CONNECTIONTYPE OGR
  CONNECTION '[insert your directory path here]\[insert your filename
here].gml'
  
  DUMP TRUE # for WFS only
  DATA "[insert the featureType here (eg. point | line | polygon)]"
  STATUS default
  CLASS
    SYMBOL 'circle'
    SIZE 25
    COLOR 255 0 0
  END
 END
 
 

________________________________

From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Chip Taylor
Sent: Friday, March 24, 2006 7:19 PM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] Using Microsoft SQL Server?



Can I integrate a layer in Mapserver using a connection to Microsoft SQL
Server 2005, pulling XY (lat long) points and text, and plot these?  How
would I do that?

 

 

Chip Taylor

Prepared Response, Inc