[mapserver-users] Mapserver SQL Server 2008 R2 connection

[Tamas Szekeres]

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 <mgebreab at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20101110/df85bf22/attachment.htm>