[mapserver-users] Mapserver - connection to MSSQL

[Robert Sanson]

Hi Tamas

That was it. I inserted the appropriate values into geometry_columns and spatial_ref_sys.

All working now.

Many thanks,

Robert

From: Tamas Szekeres [mailto:szekerest at gmail.com]
Sent: Wednesday, 1 June 2016 9:23 a.m.
To: Robert Sanson <Robert.Sanson at asurequality.com>
Cc: mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] Mapserver - connection to MSSQL

Probably the referred table is not enumerated in the geometry_columns metadata table of the database.

Best regards,

Tamas


2016-05-31 23:04 GMT+02:00 Robert Sanson <Robert.Sanson at asurequality.com<mailto:Robert.Sanson at asurequality.com>>:
Hi Tamas

Thanks for that. I tried that but now the response is:

<?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">
<ServiceExceptionReport version="1.1.1">
<ServiceException>
msDrawMap(): Image handling error. Failed to draw layer named 'par_direct'.
msOGRFileNextShape(): OGR error. Error initializing the metadata tables :
</ServiceException>
</ServiceExceptionReport>

Any way I can get around this issue?

Robert

From: Tamas Szekeres [mailto:szekerest at gmail.com<mailto:szekerest at gmail.com>]
Sent: Wednesday, 1 June 2016 6:36 a.m.
To: Robert Sanson <Robert.Sanson at asurequality.com<mailto:Robert.Sanson at asurequality.com>>
Cc: mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Subject: Re: [mapserver-users] Mapserver - connection to MSSQL

Robert,

It looks like the port number portion in the connection string causes the issue, specifically the comma is not being interpreted correctly by the parser. I guess this is similar to an earlier issue reported to gdal: https://trac.osgeo.org/gdal/ticket/4885

That time quoting the connection string provided a workaround as far as I remember.

Best regards,

Tamas


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