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 <[email protected]> > 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 <[email protected]>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 <[email protected]> >> >>> 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 <[email protected]> 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 >>>> [email protected]http://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 [email protected] http://www.terrestris.de >>>> Amtsgericht Bonn, HRA 6835 >>>> --------------------------------------------------------- >>>> >>>> Komplementärin: >>>> >>>> terrestris Verwaltungs GmbH >>>> >>>> vertreten durch: >>>> Hinrich Paulsen, Till Adams >>>> >>>> >>> >>> _______________________________________________ >>> mapserver-users mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>> >>> >> >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
