[mapserver-users] - SQL Server 2008

[Eduardo Kanegae]

Sounds like no datasource was defined.

At windows boxes normally we use ODBC system manager to do that tasks.

Using Linux probably config files will be neessary. Check unixODBC docs



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


2011/12/13 <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