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