[mapserver-users] - SQL Server 2008

[scott159 at free.fr]

Hi,

I install and configure FreeTDS and unixodbc to connect to SQL Server 2008. Everything is ok when I request database with tsql. But when I launch "ogrinfo ODBC:user/pwd at DSN", I have this error message :
[unixodbc] [driver manager] data source name not found and no default driver specified
What's the solution, environment variable ... ?

Thanks


----- Mail Original -----
De: "Eduardo Kanegae" <eduardo.kanegae at gmail.com>
À: "MapServer Users" <mapserver-users at lists.osgeo.org>
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't change so much. Basically your layer will have layer
name, type, connection type and then in connection param something
like

"MSSQL:dsn=MY_DSN;server=(local);database=DBNAME_HERE;tables=myscheme.mytable;uid=USER_HERE;pwd=PWD_HERE"
mytable

Check OGR docs for more info http://www.gdal.org/ogr/drv_mssqlspatial.html

You might need freetds + unixodbc too

http://www.sommarskog.se/mssqlperl/unix.html
http://comments.gmane.org/gmane.comp.db.tds.freetds/13292

In advance I can tell what I got: I gave up using default
geometry/spatial types/functions from SQL 2008 - to slow, no official
docs is available.

To speed it up, I installed MsSqlSpatial lib (originally developed for
SQL 2005 but also works for 2008) on SQL 2008 database + ODBC OGR
driver on MapServer. And then spatial SQL speed gone 10-15 times over
standard ms sql 2008 types



Eduardo Patto Kanegae
http://www.webmapit.com | @webmapit


2011/11/26 <scott159 at free.fr>
>
> Ok but I try to use it on Linux. Do you have some examples of mapfile to specify a sql 2008 connection ?
>
> ----- Mail Original -----
> De: "Eduardo Kanegae" <eduardo.kanegae at gmail.com>
> À: "MapServer Users" <mapserver-users at lists.osgeo.org>
> Envoyé: Samedi 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 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 | @webmapit
>
>
> 2011/11/25 <scott159 at free.fr>
> >
> > 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 examples of fcgid.conf ?
> >
> > Thanks
> > _______________________________________________
> > mapserver-users mailing list
> > mapserver-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapserver-users
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users