<div dir="ltr">I think you should specify the ODBC driver name in the connection string (driver=[driver name]). I've never tested the connection on linux, though.<div><br></div><div>Best regards,</div><div><br></div><div>
Tamas</div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014/1/17 Jon Garrido <span dir="ltr"><<a href="mailto:jgarrido@tracom.info" target="_blank">jgarrido@tracom.info</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="ES" link="blue" vlink="purple"><div><p class="MsoNormal"><span lang="EN-US">Helo,<u></u><u></u></span></p><p class="MsoNormal">
<span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">I’m trying to connect to a MS Sql Server 2008 dabase from a Mapserver installed on a Ubuntu 12.04 machine.<u></u><u></u></span></p><p class="MsoNormal">
<span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">The fact is that when make de same connection test from another Mapserver on Windows I get no errors:<u></u><u></u></span></p><p class="MsoNormal">
<span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">From the OSGeo4W Shell from windows I type:<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal">
<span lang="EN-US">C:>ogrinfo "MSSQL:server=Xxx.xxx.xx.xx,1093\MSSQL;uid=xxxxx;pwd=xxxxx;database=ancashesp;tables=admin.PKGeoLoc"<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">And the response:<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">INFO: Open of `MSSQL:server=209.236.114.58,1093\MSSQL;uid=ancashjon;pwd=xxxxx;database=ancashesp;tables=admin.PKGeoLoc' using driver `MSSQLSpatial' successful.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">1: PKGeoLoc<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">When I do the same from my linux terminal the response is:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">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,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[unixODBC][Driver Manager]Data source name not found, and no default driver specified<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">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,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[unixODBC][Driver Manager]Data source name not found, and no default driver specified<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">FAILURE:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">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.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> ESRI Shapefile<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> MapInfo File<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> UK .NTF<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> SDTS<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> TIGER<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> S57<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> DGN<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> VRT<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> REC<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> Memory<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> BNA<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> CSV<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> NAS<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> GML<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> GPX<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> KML<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> GeoJSON<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> Interlis 1<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> Interlis 2<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> GMT<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> SQLite<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> ODBC<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> PGeo<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> MSSQLSpatial<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> PostgreSQL<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> PCIDSK<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> XPlane<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> AVCBin<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> AVCE00<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> DXF<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> Geoconcept<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> GeoRSS<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> GPSTrackMaker<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> VFK<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> PGDump<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> OSM<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> GPSBabel<u></u><u></u></span></p><p class="MsoNormal"> -> SUA<u></u><u></u></p><p class="MsoNormal"> -> OpenAir<u></u><u></u></p><p class="MsoNormal"> -> PDS<u></u><u></u></p>
<p class="MsoNormal"> -> WFS<u></u><u></u></p><p class="MsoNormal"> -> HTF<u></u><u></u></p><p class="MsoNormal"> -> AeronavFAA<u></u><u></u></p><p class="MsoNormal"> -> Geomedia<u></u><u></u></p><p class="MsoNormal">
-> EDIGEO<u></u><u></u></p><p class="MsoNormal"> <span lang="EN-US">-> GFT<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> SVG<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> CouchDB<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> Idrisi<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> ARCGEN<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> SEGUKOOA<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> SEGY<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> ODS<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> XLSX<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> -> ElasticSearch<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"> -> PDF<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">My gdal verion is GDAL 1.10.1, released 2013/08/26.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Please I’m getting crazy!!! Any idea??<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
</div></div><br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></blockquote></div><br></div>