<div class="gmail_quote">Hi Tamas. I appreciate your help. I tried this one:<br><br><a href="http://vbkto.dyndns.org/sdk/Download.aspx?file=release-1600-gdal-1-8-0-mapserver-5-6-6.zip" target="_blank">http://vbkto.dyndns.org/sdk/Download.aspx?file=release-1600-gdal-1-8-0-mapserver-5-6-6.zip</a><br>
<br>It seemed to me to be the latest stable. It works fine, except the fix for Guid doesn't seem to be in there.<br><font color="#888888"><br>Roger</font><div><div></div><div class="h5"><br><br><div class="gmail_quote">
On Thu, Mar 17, 2011 at 5:16 PM, Tamas Szekeres <span dir="ltr"><<a href="mailto:szekerest@gmail.com" target="_blank">szekerest@gmail.com</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;">Roger,<br><br>Which package did you try. The -stable branches (ie: <a href="http://vbkto.dyndns.org/sdk/PackageList.aspx?file=release-1600-gdal-1-8-mapserver-5-6.zip" target="_blank">http://vbkto.dyndns.org/sdk/PackageList.aspx?file=release-1600-gdal-1-8-mapserver-5-6.zip</a>) should contain the fix.<br>
<br>Best regards,<br><font color="#888888"><br>Tamas</font><div><div></div><div><br><br><br><br><div class="gmail_quote">2011/3/17 Roger Bedell <span dir="ltr"><<a href="mailto:sylvanascent@gmail.com" target="_blank">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;">
Hi Tamas,<br>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.<br><br>1) Tried to just copy just the msplugin_mssql2008.dll from your latest build from <a href="http://vbkto.dyndns.org/sdk/" target="_blank">http://vbkto.dyndns.org/sdk/</a> - this didn't work, must have other dependencies, I didn't really think it would work.<br>
<br>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.<br><br>What do you think is the easiest way to get this working?<div>
<br>
<br>Thanks,<br>Roger Bedell<br>Coordinate Solutions Inc.<br><br><br></div><div class="gmail_quote"><div>On Thu, Mar 10, 2011 at 12:56 PM, Tamas Szekeres <span dir="ltr"><<a href="mailto:szekerest@gmail.com" target="_blank">szekerest@gmail.com</a>></span> wrote:<br>
</div><div><div></div><div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi Roger,<br><br>Could you create a ticket with this issue (<a href="http://trac.osgeo.org/mapserver/newticket" target="_blank">http://trac.osgeo.org/mapserver/newticket</a>)? I'll take care of fixing this.<br>
<br>Best regards,<br><font color="#888888"><br>
Tamas</font><div><div></div><div><br><br><br><br><div class="gmail_quote">2011/3/10 Roger Bedell <span dir="ltr"><<a href="mailto:sylvanascent@gmail.com" target="_blank">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><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: <a href="tel:%2B49%20%280%29228%20%2F%20962%20899-52" target="_blank"></a><a href="tel:%2B49%20%280%29228%20%2F%20962%20899-52" target="_blank"></a><a href="tel:%2B49%20%280%29228%20%2F%20962%20899-52" target="_blank">+49 (0)228 / 962 899-52</a>
Fax: <a href="tel:%2B49%20%280%29228%20%2F%20962%20899-57" target="_blank"></a><a href="tel:%2B49%20%280%29228%20%2F%20962%20899-57" target="_blank"></a><a href="tel:%2B49%20%280%29228%20%2F%20962%20899-57" target="_blank">+49 (0)228 / 962 899-57</a>
<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" target="_blank">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="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%;">
</div>
</div></div></blockquote></div></div></div><br>
</blockquote></div><br><div style="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%;">
</div>
</div></div></blockquote></div><br>
</div></div></div><br>