[mapserver-users] mapserver-users Digest, Vol 56, Issue 1
Chris Jackson
webturtles at gmail.com
Mon Sep 3 12:27:37 PDT 2012
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.htm>
More information about the MapServer-users
mailing list