[mapserver-users] Mapserver - connection to MSSQL

[Robert Sanson]

Hi

I manually retyped the connection string into my Mapfile and still get the same error. The exact same connection string works fine in ogrinfo, the only error message is something about OGC Metadata table missing, however, it proceeds to give me the correct information.

Thanks,

Robert
From: Rahkonen Jukka (MML) [mailto:jukka.rahkonen at maanmittauslaitos.fi]
Sent: Wednesday, 11 May 2016 7:28 p.m.
To: geographika at gmail.com; Robert Sanson <Robert.Sanson at asurequality.com>; mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] Mapserver - connection to MSSQL
Hi,
The connection string in the mapfile does look perfect but something that happens for me is that if I copy and paste text the copy may  contain invisible characters which make troubles. I would rewrite the CONNECTION again by hand from keyboard and try if it helps.
-Jukka Rahkonen-
Seth G wrote:
Hi,

The error message indicates there is a problem with your connection string:

'MSSQL:driver=FreeTDS;server=db-agribase-p.asurequality.com' does not contain the 'database' portion

If the database part is not missing, maybe there is a missing semi-colon, or special character ending the database connection string?

Regards,

Seth

On 10/05/2016 23:54, Robert Sanson wrote:
Hi

I am trying to create a Mapserver (v 6.4.1 on Ubuntu) layer based on a MSSQL table with native geometry.

I have tested the connection via ogrinfo (based on gdal v 2.0.2) and it works:

ogrinfo -sql "select * from par_table where par_no = 6777887" "MSSQL:driver=FreeTDS;server=myserver,1433;uid=xx;pwd=xxx;database=mydb;trusted_connection=no;tables=par_table(geom)"

This is my layer section:

LAYER
  NAME par_direct
  GROUP "CRS"
  STATUS ON
  CONNECTIONTYPE ogr
  CONNECTION "MSSQL:driver=FreeTDS;server=myserver,1433;uid=xx;pwd=xxx;database=mydb;trusted_connection=no;tables=par_table(geom)"
  FILTER "WHERE date_dropped is null"
  TYPE POLYGON
  PROCESSING 'CLOSE_CONNECTION=DEFER'
  MAXSCALE 275000
  CLASS
    STYLE
      WIDTH 0.25
      OUTLINECOLOR 0 0 255
    END
  END
  METADATA
    "ows_title" "par_direct"
    "wms_group_title" "CRS"
    "wms_exceptions_format" "application/vnd.ogc.se_xml"
    "wms_abstract"    "This is the LINZ parcel layer in NZTM"
    "wms_keywordlist"    "LINZ,CRS"
    "wms_extent" "1114412.940 4793178.168 2089186.204 6190213.601"
  END
END

When I try a WMS getmap call I get this error message:

<?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE ServiceExceptionReport SYSTEM "http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd"<http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd>>
<ServiceExceptionReport version="1.1.1">
<ServiceException>
msDrawMap(): Image handling error. Failed to draw layer named 'par_direct'.
msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `par_direct'.
'MSSQL:driver=FreeTDS;server=db-agribase-p.asurequality.com' does not contain the 'database' portion
</ServiceException>
</ServiceExceptionReport>


Many thanks,

Robert L. Sanson



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160512/edd5d585/attachment.htm>