Thanks Tamas! It is ticket 3722
Roger On Thu, Mar 10, 2011 at 12:56 PM, Tamas Szekeres <szeker...@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 <sylvanasc...@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 <ad...@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@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: +49 (0)228 / 962 899-52 >>> Fax: +49 (0)228 / 962 899-57ad...@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@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> >> >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users