[mapserver-users] MapServer and Guid USING UNIQUE

Thu Mar 17 13:19:13 PDT 2011

Sorry about that, I understand now. Development is trunk, -stable is fixes
to the official release. I do this all the time with GeoServer, so one would
think I'd learn.[?]

Roger

On Thu, Mar 17, 2011 at 9:08 PM, Tamas Szekeres <szekerest at gmail.com> wrote:

> Hi Roger,
>
> The package you mention contains the latest "official" release versions of
> MapServer and GDAL which has been released earlier and doesn't contain the
> fix, you should use the -stable branch versions instead.
>
>
> Best regards,
>
> Tamas
>
>
>
> 2011/3/17 Roger Bedell <sylvanascent at gmail.com>
>
>> Hi Tamas. I appreciate your help. I tried this one:
>>
>>
>> http://vbkto.dyndns.org/sdk/Download.aspx?file=release-1600-gdal-1-8-0-mapserver-5-6-6.zip
>>
>> It seemed to me to be the latest stable. It works fine, except the fix for
>> Guid doesn't seem to be in there.
>>
>> Roger
>>
>>
>> On Thu, Mar 17, 2011 at 5:16 PM, Tamas Szekeres <szekerest at gmail.com>wrote:
>>
>>> Roger,
>>>
>>> Which package did you try. The -stable branches (ie:
>>> http://vbkto.dyndns.org/sdk/PackageList.aspx?file=release-1600-gdal-1-8-mapserver-5-6.zip)
>>> should contain the fix.
>>>
>>> Best regards,
>>>
>>> Tamas
>>>
>>>
>>>
>>>
>>> 2011/3/17 Roger Bedell <sylvanascent at gmail.com>
>>>
>>>> Hi Tamas,
>>>> I'm trying to get this working and ran into a couple snags. We are
>>>> currently using mapscript_csharp.dll version 5.6.5 in a .NET program.
>>>>
>>>> 1) Tried to just copy just the msplugin_mssql2008.dll from your latest
>>>> build from http://vbkto.dyndns.org/sdk/ - this didn't work, must have
>>>> other dependencies, I didn't really think it would work.
>>>>
>>>> 2) Tried to use the latest build. Strangely, mapscript_csharp.dll
>>>> doesn't seem to have the same objects as 5.6.5, and I got a bunch of
>>>> unresolved references in the code.
>>>>
>>>> What do you think is the easiest way to get this working?
>>>>
>>>>
>>>> Thanks,
>>>> Roger Bedell
>>>> Coordinate Solutions Inc.
>>>>
>>>>
>>>> On Thu, Mar 10, 2011 at 12:56 PM, Tamas Szekeres <szekerest at gmail.com>wrote:
>>>>
>>>>> Hi Roger,
>>>>>
>>>>> Could you create a ticket with this issue (
>>>>> http://trac.osgeo.org/mapserver/newticket)? I'll take care of fixing
>>>>> this.
>>>>>
>>>>> Best regards,
>>>>>
>>>>> Tamas
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> 2011/3/10 Roger Bedell <sylvanascent at gmail.com>
>>>>>
>>>>>> Thanks Till, however, here is the trace from the ODBC tracer, pretty
>>>>>> obvious what is going on:
>>>>>>
>>>>>>           DIAG [42000] [Microsoft][ODBC SQL Server Driver][SQL
>>>>>> Server]Insufficient result space to convert uniqueidentifier value to char.
>>>>>> (8170)
>>>>>>
>>>>>> Guids generally take up 36 characters when converted to a string, and
>>>>>> the Select statement only has room for 20.
>>>>>>
>>>>>> Since this is a SQL specific query, my guess it is being generated in
>>>>>> the sql spatial driver?
>>>>>>
>>>>>> Roger
>>>>>>
>>>>>>
>>>>>>           HSTMT               0x0589B310
>>>>>>           UCHAR *             0x05E1A990 [      -3] "SELECT
>>>>>> Feature.STAsBinary(),convert(varchar(20), PKey) from MetesAndBoundsHeader
>>>>>> WHERE Feature.STIntersects(Geometry::STGeomFromText('POLYGON((-104.18599
>>>>>> 29.2473266843318,-93.22438 29.2473266843318,-93.22438
>>>>>> 41.3707663156682,-104.18599 41.3707663156682,-104.18599
>>>>>> 29.2473266843318))',4326)) = 1 \ 0"
>>>>>>           SDWORD                    -3
>>>>>>
>>>>>>           DIAG [42000] [Microsoft][ODBC SQL Server Driver][SQL
>>>>>> Server]Insufficient result space to convert uniqueidentifier value to char.
>>>>>> (8170)
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Thu, Mar 10, 2011 at 12:04 PM, adams <adams at terrestris.de> wrote:
>>>>>>
>>>>>>>  Dear Roger,
>>>>>>>
>>>>>>> if you get an empty image with no error, the first try would be to
>>>>>>> use a simple symbol and no expression in your layer.
>>>>>>> Also ensure, that your extent when querying the map is correct.
>>>>>>>
>>>>>>> So you make sure, that everything around your datasource is OK.
>>>>>>>
>>>>>>> Then use a datastring like this one:
>>>>>>>
>>>>>>>
>>>>>>> DATA "the_geom from (SELECT Feature from MetesAndBoundsHeader) as foo
>>>>>>> USING UNIQUE PKey USING SRID=4326"
>>>>>>>
>>>>>>> or however the geometry-column in mssql server is called ;-)
>>>>>>>
>>>>>>> Regards, Till
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Roger Bedell wrote:
>>>>>>>
>>>>>>> Good Morning.
>>>>>>> I am currently working with MapServer and the MSSQL Spatial driver. I
>>>>>>> am seeing that MS does not work with a DATA statement like this in the Map
>>>>>>> file:
>>>>>>>
>>>>>>> DATA "Feature from MetesAndBoundsHeader USING UNIQUE PKey USING
>>>>>>> SRID=4326"
>>>>>>>
>>>>>>> where PKey is defined like this:
>>>>>>>
>>>>>>> [PKey] [uniqueidentifier] DEFAULT NEWSEQUENTIALID() ROWGUIDCOL NOT
>>>>>>> NULL,
>>>>>>>
>>>>>>> No errors are triggered, however nothing is displayed, including all
>>>>>>> other layers. Is this an issue with the SQL Spatial driver or MapServer? Any
>>>>>>> ideas on how to fix it?
>>>>>>>
>>>>>>> Thanks!
>>>>>>> Roger Bedell
>>>>>>> Coordinate Solutions Inc.
>>>>>>>
>>>>>>> ------------------------------
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> mapserver-users mailing listmapserver-users at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> ---------------------------------------------------------
>>>>>>> terrestris GmbH & Co. KG
>>>>>>> Irmintrudisstrasse 17
>>>>>>> 53111 Bonn
>>>>>>> Germany
>>>>>>>
>>>>>>> Till Adams
>>>>>>> Geschäftsführung
>>>>>>>
>>>>>>> Tel:  <%2B49%20%280%29228%20%2F%20962%20899-52> <%2B49%20%280%29228%20%2F%20962%20899-52>+49 (0)228 / 962 899-52
>>>>>>> Fax:  <%2B49%20%280%29228%20%2F%20962%20899-57> <%2B49%20%280%29228%20%2F%20962%20899-57>+49 (0)228 / 962 899-57adams at terrestris.de http://www.terrestris.de
>>>>>>> Amtsgericht Bonn, HRA 6835
>>>>>>> ---------------------------------------------------------
>>>>>>>
>>>>>>> Komplementärin:
>>>>>>>
>>>>>>> terrestris Verwaltungs GmbH
>>>>>>>
>>>>>>> vertreten durch:
>>>>>>> Hinrich Paulsen, Till Adams
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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/20110317/de633843/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 330.gif
Type: image/gif
Size: 96 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110317/de633843/attachment.gif>