[mapserver-users] - SQL Server 2008

[Tamas Szekeres]

Hi,

I think the OGR MSSQL Spatial driver would be a better choice than OGR ODBC
to connect to MS SQL Server 2008. You may however specify the driver in the
connection string explicitly. The default is driver={SQL Server} which may
not be sufficient in non Windows environments. You may probably use:

"MSSQL:driver=FreeTDS;..."

You may also require to use the latest SVN (trunk or branch-1-8) in order
to get it working.

Best regards,

Tamas



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
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111214/e5a52e37/attachment-0001.html