Apologies all, one last question... To retrieve attributes from MS SQL I thought something like the following would work: DATA "SitePoint1 from (select SiteID,SitePoint1,SiteName from Site) USING UNIQUE SiteID USING SRID=4326" However, the layer fails to draw. Am I in need of a newer MSSQL2008 driver or is it a poorly formed query? Thanks Chris
On 3 September 2012 20:27, Chris Jackson <webturt...@gmail.com> wrote: > Fixed it in the end. > > PLUGIN "C:\..\...\msplugin_mssql2008.dll" > CONNECTION "server=xxxxx;uid=xxxx;pwd=xxxxxx;database=xxxxx;Integrated > Security=false" > > What is odd is I can only get a geometry type to work, my driver is dated > Jan-10, maybe pre-geography datatype support - all I can think of. > > DATA "SitePoint1 from Site USING UNIQUE SiteID USING SRID=4326" > #DATA "SitePoint (geography) from Site USING UNIQUE SiteID USING > SRID=4326" - throws an error about not finding geometry type > > Chris > > On 3 September 2012 20:00, <mapserver-users-requ...@lists.osgeo.org>wrote: > >> Send mapserver-users mailing list submissions to >> mapserver-users@lists.osgeo.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> or, via email, send a message with subject or body 'help' to >> mapserver-users-requ...@lists.osgeo.org >> >> You can reach the person managing the list at >> mapserver-users-ow...@lists.osgeo.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of mapserver-users digest..." >> >> >> Today's Topics: >> >> 1. SQL Server 2008 layer (Chris Jackson) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Mon, 3 Sep 2012 15:51:33 +0100 >> From: Chris Jackson <webturt...@gmail.com> >> To: mapserver-users@lists.osgeo.org >> Subject: [mapserver-users] SQL Server 2008 layer >> Message-ID: >> <CACU1gf7PSCZ25axKSJwwPCcD-Y= >> fnb1dht2x-_g_eseiygc...@mail.gmail.com> >> Content-Type: text/plain; charset="iso-8859-1" >> >> Hi all >> >> Sorry for this v.basic question. Trying to load a layer from SQL 2008 R2 >> 64bit using the msplugin_mssql2008.dll and when running shp2image it just >> bombs out on that layer saying neither DSN nor Server keyword supplied. >> Two things I can see could be the issue - accessing the plugin itself (any >> way to test if that is actually loaded okay?) or that the connection >> string >> is duff. >> The SQL instance is the default instance on the same box as the web >> application, I have seen various flavours of connections out there,with >> different starts to the string and ways to define instance. Below is what >> I went with.... >> >> PLUGIN "msplugin_mssql2008.dll" >> CONNECTION >> "MSSQL:Server=SERVER1;uid=user1;pwd=qwerty1234;database=name1;Integrated >> Security=True" >> >> I have the dll in the data folder for the mapfile (it does live in the >> mapfile folder and system32 just in case - hardwiring the path using >> c:\...\...\msplugin_mssql2008.dll didn't work either) >> >> I am unsure about the beginning of the connection string and the server >> reference (I am using the server name (as it is a default instance - >> works >> in my web apps)). >> >> Any clues much appreciated >> >> Thanks >> Chris >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: < >> http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120903/84d3118f/attachment-0001.html >> > >> >> ------------------------------ >> >> _______________________________________________ >> mapserver-users mailing list >> mapserver-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> >> >> End of mapserver-users Digest, Vol 56, Issue 1 >> ********************************************** >> > >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users