[mapserver-users] mapserver-users Digest, Vol 56, Issue 1

[Chris Jackson]

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-request at lists.osgeo.org> wrote:

> Send mapserver-users mailing list submissions to
>         mapserver-users at 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-request at lists.osgeo.org
>
> You can reach the person managing the list at
>         mapserver-users-owner at 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 <webturtles at gmail.com>
> To: mapserver-users at lists.osgeo.org
> Subject: [mapserver-users] SQL Server 2008 layer
> Message-ID:
>         <CACU1gf7PSCZ25axKSJwwPCcD-Y=
> FNB1dht2X-_G_eSEiYGCWDQ at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
> End of mapserver-users Digest, Vol 56, Issue 1
> **********************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120903/f91c2f66/attachment.html>