Milen, According to the timestamps this compilation seems to be outdated and there have been lost of changes in the mssql2008 driver afterwards. I suggest to do a test with the daily build packages from http://vbkto.dyndns.org/sdk/ by replacing .exe and .dll files to the newer versions.
Best regards, Tamas 2010/11/10 Milena <mgebr...@maxgeo.com> > > 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. > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users