[mapserver-users] MapServer and Guid USING UNIQUE

Thu Mar 17 15:53:44 EDT 2011

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/6e42a870/attachment-0001.html