Hi Roger,<br><br>Could you create a ticket with this issue (<a href="http://trac.osgeo.org/mapserver/newticket">http://trac.osgeo.org/mapserver/newticket</a>)? I'll take care of fixing this.<br><br>Best regards,<br><br>
Tamas<br><br><br><br><div class="gmail_quote">2011/3/10 Roger Bedell <span dir="ltr"><<a href="mailto:sylvanascent@gmail.com">sylvanascent@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Thanks Till, however, here is the trace from the ODBC tracer, pretty obvious what is going on:<br><br><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; font-size: medium;"> DIAG
[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Insufficient
result space to convert uniqueidentifier value to char. (8170) <br><br>Guids generally take up 36 characters when converted to a string, and the Select statement only has room for 20.<br><br>Since this is a SQL specific query, my guess it is being generated in the sql spatial driver?<br>
<br>Roger<br></span>
<div><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; font-size: medium;"><br>
</span></div><br><div><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; font-size: medium;"> HSTMT 0x0589B310<br>
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"<br>
SDWORD -3<br><br>
DIAG [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Insufficient result space to convert uniqueidentifier value to char. (8170) </span></div><div><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; font-size: medium;"><br>
</span></div>
<br><br><br><br><br><br><div class="gmail_quote">On Thu, Mar 10, 2011 at 12:04 PM, adams <span dir="ltr"><<a href="mailto:adams@terrestris.de" target="_blank">adams@terrestris.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
Dear Roger,<br>
<br>
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. <br>
Also ensure, that your extent when querying the map is correct.<br>
<br>
So you make sure, that everything around your datasource is OK. <br>
<br>
Then use a datastring like this one:<br>
<br>
<br>
DATA "the_geom from (SELECT Feature from MetesAndBoundsHeader) as foo
USING UNIQUE PKey USING SRID=4326"<br>
<br>
or however the geometry-column in mssql server is called ;-)<br>
<br>
Regards, Till<br>
<br>
<br>
<br>
<br>
Roger Bedell wrote:
<blockquote type="cite"><div><div></div><div class="h5"><div><div></div><div>Good Morning.<br>
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:<br>
<br>
DATA "Feature from MetesAndBoundsHeader USING UNIQUE PKey USING
SRID=4326"<br>
<br>
where PKey is defined like this:<br>
<br>
[PKey] [uniqueidentifier] DEFAULT NEWSEQUENTIALID() ROWGUIDCOL NOT NULL,<br>
<br>
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?<br>
<br>
Thanks!<br>
Roger Bedell<br>
Coordinate Solutions Inc.<br>
</div></div></div></div><pre><hr size="4" width="90%">
_______________________________________________
mapserver-users mailing list
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
</pre>
</blockquote>
<br>
<pre cols="72">--
---------------------------------------------------------
terrestris GmbH & Co. KG
Irmintrudisstrasse 17
53111 Bonn
Germany
Till Adams
Geschäftsführung
Tel: +49 (0)228 / 962 899-52
Fax: +49 (0)228 / 962 899-57
<a href="mailto:adams@terrestris.de" target="_blank">adams@terrestris.de</a> <a href="http://www.terrestris.de" target="_blank">http://www.terrestris.de</a>
Amtsgericht Bonn, HRA 6835
---------------------------------------------------------
Komplementärin:
terrestris Verwaltungs GmbH
vertreten durch:
Hinrich Paulsen, Till Adams
</pre>
</div>
</blockquote></div><br>
<br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br></blockquote></div><br><div style="visibility: hidden; left: -5000px; position: absolute; z-index: 9999; padding: 0px; margin-left: 0px; margin-top: 0px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 130%;" id="avg_ls_inline_popup">
</div>