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=x;uid=;pwd=xx;database=x;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.orgwrote:
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