[mapserver-users] SQL Server 2008 layer
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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] mapserver-users Digest, Vol 56, Issue 1
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.org wrote: 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
Re: [mapserver-users] mapserver-users Digest, Vol 56, Issue 1
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
[mapserver-users] How to manage the map after build the mapserver app?any API
I have build a mapserver app. I want to know besides the .mapfile, how I could manage the map. I mean ,some api to control map, marker and such as. Thks. Phpmapscript, any other ways, I am not very understand these methods. -- Yang Li GIS Developer P.R.China ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users