[mapserver-users] - SQL Server 2008

Hi, I would like to create a mapfile with SQL Server 2008 connection but i don't know how to configure it. With Windows, the driver is mssql2008.dll but my server run on Linux. How to do it ? When MapServer is running with fcgid mode, what's the best configuration ? Is it possible to have some

[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 (

Re: [mapserver-users] - SQL Server 2008

I'm sure about 2008 but 2000/2005 you can connect using FreeTDS client libs - and probably an ODBC connection. I also plan to publish more experiments using 2008/2005 http://blog.webmapit.com/2011/11/ms-sql-2008-spatial-experiments.html regards Eduardo Patto Kanegae http://www.webmapit.com | @we

Re: [mapserver-users] - SQL Server 2008

edi 26 Novembre 2011 00h00:11 GMT +01:00 Amsterdam / Berlin / > Berne / Rome / Stockholm / Vienne > Objet: Re: [mapserver-users] - SQL Server 2008 > > I'm sure about 2008 but 2000/2005 you can connect using FreeTDS client > libs - and probably an ODBC connection. > > I als

Re: [mapserver-users] - SQL Server 2008

specified What's the solution, environment variable ... ? Thanks - Mail Original - De: "Eduardo Kanegae" À: "MapServer Users" Envoyé: Samedi 26 Novembre 2011 15h49:27 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne Objet: Re: [mapserver-us

Re: [mapserver-users] - SQL Server 2008

t; specified > What's the solution, environment variable ... ? > > Thanks > > > - Mail Original - > De: "Eduardo Kanegae" > À: "MapServer Users" > Envoyé: Samedi 26 Novembre 2011 15h49:27 GMT +01:00 Amsterdam / Berlin / > Berne / Rome /

Re: [mapserver-users] - SQL Server 2008

> > - Mail Original - > De: "Eduardo Kanegae" > À: "MapServer Users" > Envoyé: Samedi 26 Novembre 2011 15h49:27 GMT +01:00 Amsterdam / Berlin / > Berne / Rome / Stockholm / Vienne > Objet: Re: [mapserver-users] - SQL Server 2008 > > The mapfile won&#x

Re: [mapserver-users] - SQL Server 2008

=[value from freetds.conf] scott - Mail Original - De: "Tamas Szekeres" À: scott...@free.fr Cc: "Eduardo Kanegae" , "MapServer Users" Envoyé: Mercredi 14 Décembre 2011 12h37:51 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne Objet: Re: [map

Re: [mapserver-users] - SQL Server 2008

Hi, I would like connect MapServer 6.0.1 to MS SQL Server 2008. To use OGR driver with FreeTDS I try : - to install FreeTDS from .\freetds-0.91 : ./configure --with-tdsver=7.2 sudo make make install make clean Configure with only --with-tdsver ? - to edit freetds.conf to configure MS Sql Serv

[mapserver-users] SQL Server 2008 and WFS Service

Hi, Has anyone successfully created a WFS service using the SQL Server 2008 plug in? I followed the steps at http://mapserver.org/ogc/wfs_server.html, and get no errors when running a SERVICE=WFS&VERSION=1.0.0&REQUEST=getcapabilities request. However when trying to retrieve the features u

[mapserver-users] SQL Server 2008 layer only partially displaying

Hi all, I have been trying to display a WMS layer from a SQL server database. Now, I managed successfully to connect to the database and some part of the layer appeared when Getmap requested but not all the polygons I should be seeing. The strange thing is every time I refresh the request differe

[mapserver-users] SQL Server 2008 driver and Reduce() Function

I've been trying to reduce some complex polygons(Washington State Census Tract Boundaries) so that I can improve the mapserver's response time in generating maps. This is a technique that works fine when taking the geometries directly from Sql Server and rendering them dynamically on the client.

Re: [mapserver-users] SQL Server 2008 and WFS Service

2010/7/24 geographika > > Has anyone successfully created a WFS service using the SQL Server 2008 > plug in? > > I followed the steps at http://mapserver.org/ogc/wfs_server.html, and get > no errors when running a SERVICE=WFS&VERSION=1.0.0&REQUEST=getcapabilities > request. > > However when tryin

Re: [mapserver-users] SQL Server 2008 and WFS Service

On 24/07/2010 23:25, Tamas Szekeres wrote: 2010/7/24 geographika > Has anyone successfully created a WFS service using the SQL Server 2008 plug in? I followed the steps at http://mapserver.org/ogc/wfs_server.html, and get no errors when running

Re: [mapserver-users] SQL Server 2008 and WFS Service

On 24/07/2010 23:25, Tamas Szekeres wrote: 2010/7/24 geographika > Has anyone successfully created a WFS service using the SQL Server 2008 plug in? I followed the steps at http://mapserver.org/ogc/wfs_server.html, and get no errors when running

Re: [mapserver-users] SQL Server 2008 layer only partially displaying

Milena, Could you inspect in the SQL Server Profiler what kind of SQL requests are happening in the subsequent requests? Best regards, Tamas 2011/1/10 Milena > > Hi all, > > I have been trying to display a WMS layer from a SQL server database. Now, > I > managed successfully to connect to t

[mapserver-users] SQL Server 2008 layer C# MapScript query help

Hi, I'm just starting out with MapServer / MapScript C#. I get "Attempted to read or write protected memory" when trying to retrieve the shape of the selection in a SQL Server layer. Code snippet below (adapted from example code): if (layer.queryByPoint(Map, point, mapscript.MS_SINGLE, tolera

Re: [mapserver-users] SQL Server 2008 driver and Reduce() Function

2010/2/26 jwschrader > > When using Shp2Img with the reduced geometries, I get a blank layer and the > debugging message is: > msMSSQLLayerGetShapeRandom bad shape: # > > Jeremy, This message reports your layer contains null shape(s) which doesn't explain why you get a blank image. It's more lik