[mapserver-users] Connecting MSSQL from Mapserver on Linux fails

[Tamas Szekeres]

I don't see the driver section in your mssql connection string.

Tamas



2014-02-03 Jon Garrido <jgarrido at tracom.info>:

> I ‘ve finally conect with ogrifo with:
>
>
>
>
>
>
>
> ogrinfo
> "MSSQL:Server=xxxxxxxxx,1093;uid=xxxxx;pwd=xxxxxx;database=ancashesp;driver=freetds;tables=ancashjon.Tramos"
>
>
>
> Using this string connection in the mapfile the connections fails. I ‘ve
> realized that I must put a quote and double quote in the strig… but fails….
>
>
>
> CONNECTIONTYPE OGR
>
> CONNECTION
> '"MSSQL:server=xxxxxxxx,1093;uid=xxxxxx;pwd=xxxxxx;database=ancashesp;tables=ancashjon.Tramos"'
>
>
>
> Any idea?
>
>
>
>
>
> *De:* mapserver-users-bounces at lists.osgeo.org [mailto:
> mapserver-users-bounces at lists.osgeo.org] *En nombre de *Jon Garrido
> *Enviado el:* viernes, 17 de enero de 2014 9:08
> *Para:* mapserver-users at lists.osgeo.org
> *Asunto:* [mapserver-users] Connecting MSSQL from Mapserver on Linux fails
>
>
>
> Helo,
>
>
>
> I’m trying to connect to a MS Sql Server 2008 dabase from a Mapserver
> installed on a Ubuntu 12.04 machine.
>
>
>
> The fact is that when make de same connection test from another Mapserver
> on Windows I get no errors:
>
>
>
> From the OSGeo4W Shell from windows I type:
>
>
>
> C:>ogrinfo
> "MSSQL:server=Xxx.xxx.xx.xx,1093\MSSQL;uid=xxxxx;pwd=xxxxx;database=ancashesp;tables=admin.PKGeoLoc"
>
>
>
> And the response:
>
>
>
> INFO: Open of
> `MSSQL:server=209.236.114.58,1093\MSSQL;uid=ancashjon;pwd=xxxxx;database=ancashesp;tables=admin.PKGeoLoc'
> using driver `MSSQLSpatial' successful.
>
> 1: PKGeoLoc
>
>
>
> When I do the same from my linux terminal the response is:
>
>
>
> ERROR 1: Unable to initialize connection to the server for
> MSSQL:server=xxx.xx.
> xx.x,1093\MSSQL;uid=xxxxx;pwd=xxxxx;database=ancashesp;tables=admin.PKGeoLoc,
>
> [unixODBC][Driver Manager]Data source name not found, and no default
> driver specified
>
> ERROR 1: Unable to initialize connection to the server for
> MSSQL:server=xxx.xxx.xx,1093\MSSQL;uid=xxxxx;pwd=xxxxxx;database=ancashesp;tables=admin.PKGeoLoc,
>
> [unixODBC][Driver Manager]Data source name not found, and no default
> driver specified
>
> FAILURE:
>
> Unable to open datasource
> `MSSQL:server=xxx.xxx.xxx.xx,1093\MSSQL;uid=xxxx;
> pwd=xxxxx;database=ancashesp;tables=admin.PKGeoLoc' with the following
> drivers.
>
>   -> ESRI Shapefile
>
>   -> MapInfo File
>
>   -> UK .NTF
>
>   -> SDTS
>
>   -> TIGER
>
>   -> S57
>
>   -> DGN
>
>   -> VRT
>
>   -> REC
>
>   -> Memory
>
>   -> BNA
>
>   -> CSV
>
>   -> NAS
>
>   -> GML
>
>   -> GPX
>
>   -> KML
>
>   -> GeoJSON
>
>   -> Interlis 1
>
>   -> Interlis 2
>
>   -> GMT
>
>   -> SQLite
>
>   -> ODBC
>
>   -> PGeo
>
>   -> MSSQLSpatial
>
>   -> PostgreSQL
>
>   -> PCIDSK
>
>   -> XPlane
>
>   -> AVCBin
>
>   -> AVCE00
>
>   -> DXF
>
>   -> Geoconcept
>
>   -> GeoRSS
>
>   -> GPSTrackMaker
>
>   -> VFK
>
>   -> PGDump
>
>   -> OSM
>
>   -> GPSBabel
>
>   -> SUA
>
>   -> OpenAir
>
>   -> PDS
>
>   -> WFS
>
>   -> HTF
>
>   -> AeronavFAA
>
>   -> Geomedia
>
>   -> EDIGEO
>
>   -> GFT
>
>   -> SVG
>
>   -> CouchDB
>
>   -> Idrisi
>
>   -> ARCGEN
>
>   -> SEGUKOOA
>
>   -> SEGY
>
>   -> ODS
>
>   -> XLSX
>
>   -> ElasticSearch
>
>   -> PDF
>
>
>
>
>
> My gdal verion is GDAL 1.10.1, released 2013/08/26.
>
>
>
> Please I’m getting crazy!!! Any idea??
>
>
>
>
>
> _______________________________________________
> 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/20140203/3b27e662/attachment.htm>