[mapserver-users] Re: Getfeatureinfo and MSsql 2008 server

[Afroz Kannancheri]

Dear Tamaz,
   I copied the query from the sqlserver profile and ran it in the query
window, which displayed all the data corresponding to the polygon ID on
which I clicked.
Will post the query and the results once I reach office tommorow morning.

It seems like I m very close to the result, feels like I m missing some MAP
configuration.



Thnx a lot
Afroz

On Sun, Feb 28, 2010 at 9:22 PM, Tamas Szekeres [via OSGeo.org] <
ml-node+4649998-766492421-382940 at n2.nabble.com<ml-node%2B4649998-766492421-382940 at n2.nabble.com>
> wrote:

> How is the wkb result looking like when you execute the same query in a
> Query Analyzer session?
>
> Best regards,
>
> Tamas
>
>
>
> 2010/2/28 Afroz Kannancheri <[hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4649998&i=0>
> >
>
>>
>> Hi,
>>  Tried the Tolerance parameter,  now the previous error message is not
>> coming up anymore.
>>  Checked the sqlserver profiler and now it recieves a valid query, but I
>> still get the following error on my page for the
>> GetFeatureInfo results:
>>
>> Layer 'region1'
>> Content-type: application/vnd.ogc.se_xml
>> <?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
>> <!DOCTYPE ServiceExceptionReport SYSTEM
>> "http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd">
>> <ServiceExceptionReport version="1.1.1">
>> <ServiceException>
>> </ServiceException>
>> </ServiceExceptionReport>
>>
>>
>> I enabled DEBUG on the layer and it logs "msMSSQL2008LayerGetShapeRandom
>> bad
>> shape: 1" in the log file.
>>
>> Please find part of my layer information for your reference
>>
>>  LAYER
>>  NAME "region1"
>>  CONNECTIONTYPE PLUGIN
>>  PLUGIN "C:\Programs\ms4w\Apache\specialplugins\msplugin_mssql2008.dll"
>>
>>  CONNECTION "server=192.168.254.34;uid=uid;pwd=pwd;database=map;Integrated
>> Security=false"
>>
>>  DATA "geom from region1"
>>  TYPE POLYGON
>>
>>  DEBUG 0
>>  STATUS ON
>>  TOLERANCE 5
>>  METADATA
>>        'wms_feature_info_mime_type' "text/html"
>>        "ows_include_items" "all"
>>  END
>>  PROJECTION
>>      "init=epsg:4326"
>>  END
>>
>>
>>
>> Thanks and regards
>> Afroz
>> --
>> View this message in context:
>> http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4648413.html
>>    Sent from the Mapserver - User mailing list archive at Nabble.com.
>> _______________________________________________
>> mapserver-users mailing list
>> [hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4649998&i=1>
>>
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>
>
> _______________________________________________
> mapserver-users mailing list
> [hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4649998&i=2>
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
> ------------------------------
> View message @
> http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4649998.html
> To unsubscribe from Re: Getfeatureinfo and MSsql 2008 server, click here< (link removed) ==>.
>
>
>

-- 
View this message in context: http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631781p4650244.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100228/8dc020d2/attachment.htm>