[mapserver-users] Empty query results with SQL2008 datasource

Thu Dec 11 09:54:36 PST 2008

Hello,

I'm doing a simple spatial query:  
http://server/cgi-bin/mapserv.exe?mode=query&img.x=290&img.y=210&imgext=-92.999302+44.952982+-92.998070+44.954215&map=..\..\apps\myapp\mapfile.map

This returns my layer's specified template when datasource is shapefile or 
geodatabase.   When I use the SQL2008 plugin for the layer's data I only 
get this query result:

Content-type: text/html

<HTML>
<HEAD><TITLE>MapServer Message</TITLE></HEAD>
<!-- MapServer version 5.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP 
OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG 
SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=FRIBIDI SUPPORTS=WMS_SERVER 
SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT 
SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS 
SUPPORTS=GEOS SUPPORTS=RGBA_PNG INPUT=JPEG INPUT=POSTGIS INPUT=OGR 
INPUT=GDAL INPUT=SHAPEFILE -->
<BODY BGCOLOR="#FFFFFF">
</BODY></HTML>

Mapserver renders the data from SQL Server in a map just fine.   I'm using 
Mapserver 5.2.1 from MS4W 2.3.1

Is anyone able to get query results from SQL2008? 

Jeff Coate
GIS Specialist
Roadway Maintenance Services
Traffic Safety Systems Division
3M Company

office: 651-733-3027
cell: 612-720-8463

Jeff Coate
GIS Specialist
Roadway Maintenance Services
Traffic Safety Systems Division
3M Company

office: 651-733-3027
cell: 612-720-8463
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20081211/55d1a273/attachment.htm>