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, <[email protected]> wrote: > Send mapserver-users mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: [email protected] > Subject: [mapserver-users] SQL Server 2008 layer > Message-ID: > <CACU1gf7PSCZ25axKSJwwPCcD-Y= > [email protected]> > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > End of mapserver-users Digest, Vol 56, Issue 1 > ********************************************** >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
