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

[Jon Garrido]

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=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??

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20140203/9c60dcb7/attachment.html>