<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 '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">msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `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">'MSSQL:driver=FreeTDS;server=db-agribase-p.asurequality.com' does not contain the 'database' 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>