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: [email protected] [mailto:[email protected]] En nombre de Jon Garrido Enviado el: viernes, 17 de enero de 2014 9:08 Para: [email protected] 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=ancashes p;tables=admin.PKGeoLoc" And the response: INFO: Open of `MSSQL:server=209.236.114.58,1093\MSSQL;uid=ancashjon;pwd=xxxxx;database=anc ashesp;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;t ables=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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
