I don't see the driver section in your mssql connection string. Tamas
2014-02-03 Jon Garrido <[email protected]>: > 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=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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
