<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;
        color:black;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;
        color:black;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";
        color:black;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:Consolas;
        color:black;}
span.EmailStyle20
        {mso-style-type:personal;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
span.EmailStyle21
        {mso-style-type:personal;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
span.EmailStyle22
        {mso-style-type:personal;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
p.HTML-esimuotoiltu, li.HTML-esimuotoiltu, div.HTML-esimuotoiltu
        {mso-style-name:HTML-esimuotoiltu;
        mso-style-link:"HTML-esimuotoiltu Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;
        color:black;}
span.HTML-esimuotoiltuChar
        {mso-style-name:"HTML-esimuotoiltu Char";
        mso-style-priority:99;
        mso-style-link:HTML-esimuotoiltu;
        font-family:Consolas;
        color:black;}
span.EmailStyle25
        {mso-style-type:personal;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
span.EmailStyle26
        {mso-style-type:personal-reply;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-NZ" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">I retyped the connection string into my Mapfile and I still get the same error.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">The exact same connection string works fine via ogrinfo on the command line:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">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)"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">The only error message is:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">ERROR 1: Error initializing the metadata tables<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">However, it then proceeds to give me the answer correctly.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">INFO: Open of `MSSQL:driver=FreeTDS;server=myserver,1433;uid=xx;pwd=xxx;database=mydb;trusted_connection=no;tables=par_table(geom)'<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">      using driver `MSSQLSpatial' successful.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Layer name: SELECT<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Geometry: Unknown (any)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Feature Count: 1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Layer SRS WKT:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">PROJCS["NZGD2000 / New Zealand Transverse Mercator 2000",<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">    GEOGCS["NZGD2000",<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">        DATUM["New_Zealand_Geodetic_Datum_2000",<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">            SPHEROID["GRS 1980",6378137,298.257222101,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">                AUTHORITY["EPSG","7019"]],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">            TOWGS84[0,0,0,0,0,0,0],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">            AUTHORITY["EPSG","6167"]],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">        PRIMEM["Greenwich",0,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">            AUTHORITY["EPSG","8901"]],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">        UNIT["degree",0.0174532925199433,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">            AUTHORITY["EPSG","9122"]],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">        AUTHORITY["EPSG","4167"]],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">    PROJECTION["Transverse_Mercator"],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">    PARAMETER["latitude_of_origin",0],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">    PARAMETER["central_meridian",173],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">    PARAMETER["scale_factor",0.9996],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">    PARAMETER["false_easting",1600000],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">    PARAMETER["false_northing",10000000],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">    UNIT["metre",1,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">        AUTHORITY["EPSG","9001"]],<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">    AUTHORITY["EPSG","2193"]]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">etc.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><br>
Robert<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"> Rahkonen Jukka (MML) [mailto:jukka.rahkonen@maanmittauslaitos.fi]
<br>
<b>Sent:</b> Wednesday, 11 May 2016 7:28 p.m.<br>
<b>To:</b> geographika@gmail.com; Robert Sanson <Robert.Sanson@asurequality.com>; mapserver-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [mapserver-users] Mapserver - connection to MSSQL<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext">Seth G wrote:<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="FI"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-US">Hi,<br>
<br>
The error message indicates there is a problem with your connection string:<br>
<br>
'MSSQL:driver=FreeTDS;server=db-agribase-p.asu</span><span lang="FI">requality.com' does not contain the 'database' portion</span><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><br>
<br>
If the database part is not missing, maybe there is a missing semi-colon, or special character ending the database connection string?<br>
<br>
Regards,<br>
<br>
Seth<br>
<br>
</span><span lang="FI">On 10/05/2016 23:54, Robert Sanson wrote:<o:p></o:p></span></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Hi</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I am trying to create a Mapserver (v 6.4.1 on Ubuntu) layer based on a MSSQL table with native geometry.</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I have tested the connection via ogrinfo (based on gdal v 2.0.2) and it works:</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">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)"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">This is my layer section:</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">LAYER</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  NAME par_direct</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  GROUP "CRS"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  STATUS ON</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  CONNECTIONTYPE ogr</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  CONNECTION "MSSQL:driver=FreeTDS;server=myserver,1433;uid=xx;pwd=xxx;database=mydb;trusted_connection=no;tables=par_table(geom)"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  FILTER "WHERE date_dropped is null"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  TYPE POLYGON</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  PROCESSING 'CLOSE_CONNECTION=DEFER'</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  MAXSCALE 275000</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  CLASS</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    STYLE</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">      WIDTH 0.25</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">      OUTLINECOLOR 0 0 255</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    END</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  END</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  METADATA</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    "ows_title" "par_direct"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    "wms_group_title" "CRS"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    "wms_exceptions_format" "application/vnd.ogc.se_xml"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    "wms_abstract"    "This is the LINZ parcel layer in NZTM"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    "wms_keywordlist"    "LINZ,CRS"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    "wms_extent" "1114412.940 4793178.168 2089186.204 6190213.601"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    "gml_include_items"     "all"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    "gml_exclude_items"     ""</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    "ows_include_items"     "all"</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">    "ows_exclude_items"     ""
</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">  END</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">END</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">When I try a WMS getmap call I get this error message:</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?></span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><!DOCTYPE ServiceExceptionReport SYSTEM
<a href="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"</a>></span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><ServiceExceptionReport version="1.1.1"></span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><ServiceException></span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">msDrawMap(): Image handling error. Failed to draw layer named &#39;par_direct&#39;.</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `par_direct&#39;.</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">&#39;MSSQL:driver=FreeTDS;server=db-agribase-p.asurequality.com&#39; does not contain the &#39;database&#39; portion</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"></ServiceException></span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"></ServiceExceptionReport></span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Any clues?</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Many thanks,</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Robert L. Sanson</span><span lang="FI"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="FI"><br>
<br>
<o:p></o:p></span></p>
<pre><span lang="FI">_______________________________________________<o:p></o:p></span></pre>
<pre><span lang="FI">mapserver-users mailing list<o:p></o:p></span></pre>
<pre><span lang="FI"><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><o:p></o:p></span></pre>
<pre><span lang="FI"><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><o:p></o:p></span></pre>
</blockquote>
<p><span lang="FI"><o:p> </o:p></span></p>
</div>
</body>
</html>