<div dir="ltr">I don't see the driver section in your mssql connection string.<div><br></div><div>Tamas</div><div><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-02-03 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" style="color:#1f497d">I ‘ve finally conect with ogrifo with:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">ogrinfo "MSSQL:Server=xxxxxxxxx,1093;uid=xxxxx;pwd=xxxxxx;database=ancashesp;driver=freetds;tables=ancashjon.Tramos"<u></u><u></u></span></p><p class="MsoNormal">
<span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">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….<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">CONNECTIONTYPE OGR<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">CONNECTION '"MSSQL:server=xxxxxxxx,1093;uid=xxxxxx;pwd=xxxxxx;database=ancashesp;tables=ancashjon.Tramos"'<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">Any idea?<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p><div><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>] <b>En nombre de </b>Jon Garrido<br>
<b>Enviado el:</b> viernes, 17 de enero de 2014 9:08<br><b>Para:</b> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br><b>Asunto:</b> [mapserver-users] Connecting MSSQL from Mapserver on Linux fails<u></u><u></u></span></p>
</div></div><div><div class="h5"><p class="MsoNormal"><u></u> <u></u></p><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></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></div>