[mapserver-users] Mapserver SQL Server 2008 R2 connection

[Milena]

Hi All, 

I really appricate any help on this. 

I am trying to create a WMS using mapserver and data from SQL 2008 R2. This
is what my map file looks like. 
SIZE 600 800 
  PROJECTION 
   "init=epsg:4326" #latlon on WGS84 
  END 
  EXTENT 113 -34 129 -14 
  # lon/lat extents of Spatial 
  WEB 
    IMAGEPATH "/tmp/ms_tmp/" 
    IMAGEURL "/ms_tmp/" 
    METADATA 
      "map" "C:/OSGeo4W/apps/Spatial/config.map" 
      "ows_schemas_location" "http://schemas.opengeospatial.net" 
      "ows_title" "Sample WMS" 
      "ows_abstract" "Sample WMS of Spatial" 
      "ows_keywordlist" "Spatial,WMS,Maxwell" 
      "ows_onlineresource"
"http://localhost:8080//Spatial?map=C:/OSGeo4W/apps/Spatial/config.map&" 
      "wms_srs" "EPSG:4326" #latlon       
      "wms_feature_info_mime_type" "text/plain" 
      "wms_feature_info_mime_type" "text/html" 
      "wms_server_version" "1.1.1" 
      "wms_formatlist" "image/png,image/gif,image/jpeg" 
      "wms_format" "image/gif" 
    END #metadata 
  END #web 
  LAYER 
  NAME "tenements" 
  CONNECTIONTYPE PLUGIN 
  PLUGIN "C:/OSGeo4W/specialplugins/msplugin_mssql2008.dll" 
  CONNECTION "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial   

Catalog=SpatialDB;Data Source=AU-FRE-L0217//SQL_2008R2" 
  DATA "SP_GEOMETRY from dbo.tenements" 
  TYPE POLYGON 
  STATUS ON 
  METADATA 
      "ows_title" "tenements" 
    END #metadata 
    PROJECTION 
      "init=epsg:4326" 
    END 
  END #Layer 
End #Map 

I am using msplugin_mssql2008.dll plugin. But I keep getting 500 internal
error: 
I checked the even view and the error there says: 
Faulting application name: mapserv.exe, version: 0.0.0.0, time stamp:
0x4ab3c473 
Faulting module name: libmap.dll, version: 0.0.0.0, time stamp: 0x4ab3c46e 
Exception code: 0xc0000005 
Fault offset: 0x000a7815 
Faulting process id: 0x178c 
Faulting application start time: 0x01cb80a63078252e 
Faulting application path: C:\OSGeo4W\bin\mapserv.exe 
Faulting module path: C:\OSGeo4W\bin\libmap.dll 
Report Id: 6f925ed2-ec99-11df-a20d-b8ac6f7484b2 

Appache error log error message is: 
[Wed Nov 10 13:56:35 2010] [error] [client 127.0.0.1] Premature end of
script headers: mapserv.exe 
[Wed Nov 10 13:59:04 2010] [error] [client 127.0.0.1] Premature end of
script headers: mapserv.exe 
[Wed Nov 10 15:09:21 2010] [error] [client 127.0.0.1] Premature end of
script headers: mapserv.exe 

Please help!! 

Thank you 

Milen 
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Mapserver-SQL-Server-2008-R2-connection-tp5723789p5723789.html
Sent from the Mapserver - User mailing list archive at Nabble.com.