<!DOCTYPE html><html><head><title></title><style type="text/css">#qt p.qt-MsoNormal{margin-top:0cm;margin-right:0cm;margin-left:0cm;margin-bottom:0.0001pt;font-size:12pt;font-family:"Times New Roman", serif;}
#qt a:link{color:blue;text-decoration-color:currentcolor;text-decoration-line:underline;text-decoration-style:solid;text-decoration-thickness:auto;}
#qt a:visited{color:purple;text-decoration-color:currentcolor;text-decoration-line:underline;text-decoration-style:solid;text-decoration-thickness:auto;}
#qt p.qt-qt-msonormal2{margin-top:0cm;margin-right:0cm;margin-left:0cm;margin-bottom:0.0001pt;font-size:11pt;font-family:"Calibri", sans-serif;}
p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div>Hi,<br></div><div><br></div><div>I'd first try to get your Mapfile working using map2img (see <a href="https://mapserver.org/utilities/map2img.html">https://mapserver.org/utilities/map2img.html</a>), remembering to set the -conf parameter to point to your CONFIG file.<br></div><div><br></div><div>It looks like you are displaying data through MapScript, so once map2img is working you may want to share your <span class="rynqvb"><span lang="EN">quickmap_geometry.php script as the error shows:</span></span><br></div><div><span class="rynqvb"><span lang="EN"></span></span><br></div><div><span class="rynqvb"><span lang="EN">D:\www\cgi-bin\ms5\quickmap_geometry.php(13): mapObj->draw() #1 {main} thrown in D:\www\cgi-bin\ms5\quickmap_geometry.php on line 13</span></span><br></div><div><br></div><div>I've created a pull request with updated docs for the MSSQL driver at <a href="https://github.com/MapServer/MapServer-documentation/pull/967">https://github.com/MapServer/MapServer-documentation/pull/967</a><br></div><div><br></div><div>Seth<span class="rynqvb"><span lang="EN"></span></span><br></div><div><br></div><div id="sig62266145"><div class="signature">--<br></div><div class="signature">web:<a href="https://geographika.net">https://geographika.net</a> & <a href="https://mapserverstudio.net">https://mapserverstudio.net</a><br></div><div class="signature">mastodon: @<a href="mailto:geographika@mastodon.social">geographika@mastodon.social</a><br></div></div><div><br></div><div>On Sat, Sep 21, 2024, at 11:13 AM, Liandres, Valeri wrote:<br></div><blockquote type="cite" id="qt" style=""><div class="qt-WordSection1"><p class="qt-MsoNormal"><span class="qt-rynqvb"><span lang="EN">Hello, Seth! Thank you for such a quick reply! We have tried the changes - key "mssql" in MAP and PLUGIN - in the config file.</span></span><span class="qt-hwtze"><span lang="EN"> </span></span><span class="qt-rynqvb"><span lang="EN">Unfortunately, a new error message appeared: "Failed to load dynamic Layer LIB: mssql".</span></span><br></p><p class="qt-MsoNormal"><span class="qt-rynqvb"><span lang="EN">Here are my data:</span></span><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"></span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">------------------------------------------</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">Environment Variables: MAPSERVER_CONFIG_FILE D:\WWW\cgi-bin\etc\mapserver.conf</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">-----------------------------------------mapserver.conf----------------------</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">CONFIG</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> ENV</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> MS_MAP_NO_PATH "foo" </span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> END</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> PLUGIN</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> "mssql" "d:\www\cgi-bin\ms5\msplugin_mssql2008.dll" # <b>New</b></span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> END</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> MAPS</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> MAP1 "d:/www/local-demo/local.map"</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> END</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">END</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">----------------------------------------------------------------------------</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">MAP</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> EXTENT 4.9159680 46.7707244 15.8416465 55.0837406</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> UNITS dd</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> LAYER</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> NAME "Bundeslaender"</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> CONNECTIONTYPE PLUGIN</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> <b>PLUGIN "mssql"</b> <b># this should be the key used in the CONFIG file</b></span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> # PLUGIN "D:\www\cgi-bin\ms5\msplugin_mssql2008.dll" </span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> CONNECTION "server=SErvername;uid=_user;pwd=pass;database=DB;Integrated Security=false"</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> DATA "GEOMETRY_LL84 from GEOM_VG_BULA using unique ID using SRID=4326"</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> TYPE POLYGON</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> STATUS ON</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">..... </span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> END</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">END</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">--------------------------------------------------tabelle "GEOM_VG_BULA"---------------------------------------</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">// </span></span></span><span class="qt-rynqvb"><span lang="EN">Example query the table</span></span><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">:"GEOM_VG_BULA"</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">$sql = "SELECT ID, GEOMETRY_LL84.ToString() AS GeometryData FROM GEOM_VG_BULA Where ID = 9";</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> </span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">ID; NAME; TYPE; GEOMETRY_UTM32; GEOMETRY_GK3; GEOMETRY_LL84; GEOGRAPHY_LL84; LEV; MAXLEV; RS; RS_GEKUERZT; GF; SHAPE_LEN; SHAPE_AREA;
VATER_ID;</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">ID: 9 Geometry Spalte GEOMETRY_LL84: MULTIPOLYGON (((8.5046081667131244 53.228919296139416, 8.5058996910812716 53.2278613377389, ...............,
8.616166313122319 53.197993104637327)))</span></span></span><br></p><p class="qt-MsoNormal"><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">--------------------------------------------------------------------------------------------------------------------------</span></span></span><br></p><p class="qt-MsoNormal"><span class="qt-rynqvb"><span lang="EN">Error message: Fatal error: Uncaught Exception: msDrawMap(): Image handling error. Failed to draw layer named 'Bundeslaender'.;loadCustomLayerDLL: General error message.</span></span><br></p><p class="qt-MsoNormal"><span class="qt-rynqvb"><span lang="EN">Failed to load dynamic Layer LIB: mssql;msGetSymbol(): General error message.</span></span><br></p><p class="qt-MsoNormal"><span class="qt-rynqvb"><b><span lang="EN">Can't load requested dynamic library</span></b></span><span class="qt-rynqvb"><span lang="EN">: mssql in D:\www\cgi-bin\ms5\quickmap_geometry.php:13</span></span><br></p><div style="border-top-width:medium;border-top-style:none;border-top-color:currentcolor;border-right-width:medium;border-right-style:none;border-right-color:currentcolor;border-left-width:medium;border-left-style:none;border-left-color:currentcolor;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;border-bottom-width:1pt;border-bottom-style:solid;border-bottom-color:windowtext;padding-top:0cm;padding-right:0cm;padding-bottom:1pt;padding-left:0cm;"><p class="qt-MsoNormal" style="border-top-width:medium;border-top-style:none;border-top-color:currentcolor;border-right-width:medium;border-right-style:none;border-right-color:currentcolor;border-bottom-width:medium;border-bottom-style:none;border-bottom-color:currentcolor;border-left-width:medium;border-left-style:none;border-left-color:currentcolor;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;padding-top:0cm;padding-right:0cm;padding-bottom:0cm;padding-left:0cm;"><span class="qt-rynqvb"><span lang="EN">Stack trace: #0 D:\www\cgi-bin\ms5\quickmap_geometry.php(13): mapObj->draw() #1 {main} thrown in D:\www\cgi-bin\ms5\quickmap_geometry.php on line 13</span></span><br></p></div><p class="qt-MsoNormal"><span class="qt-rynqvb"><span lang="EN">I checked the permissions - full access What do you think is the cause?</span></span><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"></span></span></span><br></p><p class="qt-MsoNormal"><span class="qt-rynqvb"><span lang="EN">Best regards</span></span><br></p><p class="qt-MsoNormal"><span class="qt-rynqvb"><span lang="EN">Valeri</span></span><span style="color:rgb(31, 73, 125);"><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"></span></span></span><br></p><p class="qt-MsoNormal"><span style=""> </span><br></p><div><div style="border-right-width:medium;border-right-style:none;border-right-color:currentcolor;border-bottom-width:medium;border-bottom-style:none;border-bottom-color:currentcolor;border-left-width:medium;border-left-style:none;border-left-color:currentcolor;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;border-top-width:1pt;border-top-style:solid;border-top-color:rgb(225, 225, 225);padding-top:3pt;padding-right:0cm;padding-bottom:0cm;padding-left:0cm;"><p class="qt-MsoNormal"><b><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;">Von:</span></span></b><span class="font" style="font-family:"Calibri", sans-serif;"><span class="size" style="font-size:11pt;"> Seth G <sethg@geographika.co.uk> <br> <b>Gesendet:</b> Freitag, 20. September 2024 13:42<br> <b>An:</b> Liandres, Valeri <Valeri.Liandres@leibniz-liag.de>; MapServer Users <mapserver-users@lists.osgeo.org><br> <b>Cc:</b> Agemar, Thorsten <Thorsten.Agemar@leibniz-liag.de><br> <b>Betreff:</b> Re: [MapServer-users] das "PLUGIN -msplugin_mssql2008.dll" Problem bei Mapserver 8</span></span></p></div></div><p class="qt-MsoNormal"> <br></p><table class="qt-MsoNormalTable" border="1" cellspacing="3" cellpadding="0" style="border-top-width:1pt;border-top-style:solid;border-top-color:black;border-right-width:1pt;border-right-style:solid;border-right-color:black;border-bottom-width:1pt;border-bottom-style:solid;border-bottom-color:black;border-left-width:1pt;border-left-style:solid;border-left-color:black;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;"><tbody><tr><td style="border-top-width:medium;border-top-style:none;border-top-color:currentcolor;border-right-width:medium;border-right-style:none;border-right-color:currentcolor;border-bottom-width:medium;border-bottom-style:none;border-bottom-color:currentcolor;border-left-width:medium;border-left-style:none;border-left-color:currentcolor;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;background-color:rgb(169, 226, 243);background-position-x:0%;background-position-y:0%;background-repeat:repeat;background-attachment:scroll;background-image:none;background-size:auto;background-origin:padding-box;background-clip:border-box;padding-top:0.75pt;padding-right:0.75pt;padding-bottom:0.75pt;padding-left:0.75pt;"><p class="qt-MsoNormal"><span style="color:red;">ACHTUNG!!</span> Diese E-Mail erreicht Sie von einem Absender außerhalb der GZH-Infrastruktur. Bitte klicken Sie auf keine Links oder öffnen Sie keine E-Mail-Anhänge, falls Sie den Absender nicht kennen und nicht
wissen, ob der Inhalt sicher ist.<br></p></td></tr></tbody></table><p class="qt-MsoNormal" style="margin-bottom:12pt;"> <br></p><div><div><p class="qt-MsoNormal">Hi Valeri,<br></p></div><div><p class="qt-MsoNormal"> <br></p></div><div><p class="qt-MsoNormal">The docs at <a href="https://mapserver.org/input/vector/mssql.html#option-2-connect-through-mapserver-plugin"> https://mapserver.org/input/vector/mssql.html#option-2-connect-through-mapserver-plugin</a> are out of date since version 8 of MapServer.<br></p></div><div><p class="qt-MsoNormal">For all layers using a PLUGIN you have to add the plugin to your MapServer CONFIG file: <a href="https://mapserver.org/mapfile/config.html#config">https://mapserver.org/mapfile/config.html#config</a><br></p></div><div><p class="qt-MsoNormal"> <br></p></div><div><p class="qt-MsoNormal">For example:<br></p></div><div><p class="qt-MsoNormal"> <br></p></div><div><p class="qt-MsoNormal"> PLUGINS<br></p></div><div><p class="qt-MsoNormal"> "mssql" "d:\www\cgi-bin\ms5\msplugin_mssql2008.dll"<br></p></div><div><p class="qt-MsoNormal"> END<br></p></div><div><p class="qt-MsoNormal"> <br></p></div><div><p class="qt-MsoNormal">Then you use the key to the plugin in your Mapfile. This avoids MapServer loading possibly untrusted DLLs:<br></p></div><div><p class="qt-MsoNormal"> <br></p></div><div><p class="qt-MsoNormal"> LAYER<br></p></div><div><p class="qt-MsoNormal"> NAME "..."<br></p></div><div><p class="qt-MsoNormal"> CONNECTIONTYPE PLUGIN<br></p></div><div><p class="qt-MsoNormal"> PLUGIN "mssql" # this should be the key used in the CONFIG file - <br></p></div><div><p class="qt-MsoNormal"> CONNECTION "server=ServName;uid=_user;pwd=pass;database=DB-Name;Integrated Security=false"<br></p></div><div><p class="qt-MsoNormal"> DATA "GEOMETRY_LL84 from GEOM_VG_BULA using unique ID using SRID=4326"<br></p></div><div><p class="qt-MsoNormal"> TYPE POLYGON<br></p></div><div><p class="qt-MsoNormal"> STATUS OFF<br></p></div><div><p class="qt-MsoNormal"> <br></p></div><div><p class="qt-MsoNormal">When using the Mapfile through MapScript you will need to pass the path to your CONFIG file. See <a href="https://github.com/MapServer/MapServer/pull/6646">https://github.com/MapServer/MapServer/pull/6646</a> for details.<br></p></div><div><p class="qt-MsoNormal"> <br></p></div><div><p class="qt-MsoNormal">This may resolve your current issue, unless you already use the DLL path a key, in which case it could be something else such as an extra double-quote in the CONNECTION string. <br></p></div><div><p class="qt-MsoNormal"> <br></p></div><div><p class="qt-MsoNormal">Seth<br></p></div><div><p class="qt-MsoNormal"> <br></p></div><div id="qt-sig62266145"><div><p class="qt-MsoNormal">--<br></p></div><div><p class="qt-MsoNormal">web:<a href="https://geographika.net">https://geographika.net</a> & <a href="https://mapserverstudio.net">https://mapserverstudio.net</a><br></p></div><div><p class="qt-MsoNormal">mastodon: @<a href="mailto:geographika@mastodon.social">geographika@mastodon.social</a><br></p></div></div><div><p class="qt-MsoNormal"> <br></p></div><div><p class="qt-MsoNormal">On Fri, Sep 20, 2024, at 12:08 PM, Liandres, Valeri via MapServer-users wrote:<br></p></div><blockquote style="margin-top:5pt;margin-bottom:5pt;" id="qt-qt"><div><p class="qt-qt-msonormal2"><span class="qt-size"><span class="font" style="font-family:"Times New Roman", serif;"><span class="size" style="font-size:12pt;">Hello,</span></span></span><br></p><p class="qt-qt-msonormal2"><span class="qt-size"><span class="font" style="font-family:"Times New Roman", serif;"><span class="size" style="font-size:12pt;">we are migrating our project with Mapserver 7 to Mapserver 8.0. Our project has been working stably under Mapserver 7 for a long time.</span></span></span><br></p><p class="qt-qt-msonormal2"><span class="qt-size"><span class="font" style="font-family:"Times New Roman", serif;"><span class="size" style="font-size:12pt;">One component of the project is DB query MSSQL - Server using MAP file and PLUGIN routine.</span></span></span><br></p><p class="qt-qt-msonormal2"><span class="qt-size"><span class="font" style="font-family:"Times New Roman", serif;"><span class="size" style="font-size:12pt;">Although we are using the latest version of "msplugin_mssql2008.dll", we always get an error message that the query is wrong. The table "GEOM_VG_BULA"
and permissions are OK.</span></span></span><br></p><p class="qt-qt-msonormal2"><span class="qt-size"><span class="font" style="font-family:"Times New Roman", serif;"><span class="size" style="font-size:12pt;">The call is in the PHP file as:</span></span></span><br></p><p class="qt-qt-msonormal2">$oMap = new mapObj(MAPFILE);$oMap->setSize(1990, 1160);.... $oImage = $oMap->draw();<br></p><p class="qt-qt-msonormal2">-------<br></p><p class="qt-qt-msonormal2">MAP<br></p><p class="qt-qt-msonormal2">...<br></p><p class="qt-qt-msonormal2"> LAYER<br></p><p class="qt-qt-msonormal2"> NAME "..."<br></p><p class="qt-qt-msonormal2"> CONNECTIONTYPE PLUGIN<br></p><p class="qt-qt-msonormal2"> PLUGIN "d:\www\cgi-bin\ms5\msplugin_mssql2008.dll"<br></p><p class="qt-qt-msonormal2"> CONNECTION "server=ServName;uid=_user;pwd=pass;database=DB-Name;Integrated Security=false"<br></p><p class="qt-qt-msonormal2"> <b>DATA "GEOMETRY_LL84 from GEOM_VG_BULA using unique ID using SRID=4326" <<<<< </b><span class="qt-qt-rynqvb"><span lang="EN">here table </span></span><b>GEOM_VG_BULA</b><span class="qt-qt-rynqvb"><span lang="EN"> , column </span></span><b>GEOMETRY_LL84</b><br></p><p class="qt-qt-msonormal2"> TYPE POLYGON<br></p><p class="qt-qt-msonormal2"> STATUS OFF<br></p><p class="qt-qt-msonormal2">...<br></p><p class="qt-qt-msonormal2">END<br></p><p class="qt-qt-msonormal2">-------<br></p><p class="qt-qt-msonormal2"><span class="qt-qt-rynqvb"><span lang="EN">The error message:</span></span><br></p><p class="qt-qt-msonormal2">Fatal error: Uncaught Exception: msDrawMap(): Image handling error. Failed to draw layer named 'Bundeslaender'.;msMSSQL2008LayerOpen():<br></p><p class="qt-qt-msonormal2"> <b>Query error</b>. Error with MSSQL2008 data variable. You specified 'Error parsing MSSQL2008 <b>data variable: nothing specified in DATA statement</b>.<br></p><p class="qt-qt-msonormal2"><br><br> More Help:<br><br> '.<br> Standard ways of specifying are : <br> (1) 'geometry_column from geometry_table' <br> (2) 'geometry_column from (<sub query>) as foo using unique <column name> using SRID=<srid#>'
<br><br> Make sure you utilize the 'using unique <column name>' and 'using with <index name>' clauses in. <br><br>For more help, please see <a href="http://www.mapdotnet.com">http://www.mapdotnet.com</a> <br><br>mapmssql2008.c - version of 2007/7/1. in D:\www\cgi-bin\ms5\quickmap_geometry.php:13<br></p><p class="qt-qt-msonormal2"> Stack trace: #0 D:\www\cgi-bin\ms5\quickmap_geometry.php(13): mapObj->draw() #1 {main} thrown in D:\www\cgi-bin\ms5\quickmap_geometry.php on line<br></p><p class="qt-qt-msonormal2"> <br></p><p class="qt-qt-msonormal2"><span class="qt-qt-rynqvb"><span lang="EN">Is this a problem only with version 8.0?</span></span><br></p><p class="qt-qt-msonormal2"><span class="qt-qt-rynqvb"><span lang="EN">Unfortunately, we cannot use "Connection type OGR" in our project structure.</span></span><br></p><p class="qt-qt-msonormal2"><span class="qt-qt-rynqvb"><span lang="EN"> </span></span><br></p><p class="qt-qt-msonormal2"><span class="qt-qt-rynqvb"><span lang="EN">Can anyone help us?</span></span><br></p><p class="qt-qt-msonormal2"><span class="qt-qt-rynqvb"><span lang="EN">Valeri</span></span><br></p></div><div><p class="qt-MsoNormal">_______________________________________________<br></p></div><div><p class="qt-MsoNormal">MapServer-users mailing list<br></p></div><div><p class="qt-MsoNormal"><a href="mailto:MapServer-users@lists.osgeo.org"><span style="color:rgb(5, 99, 193);">MapServer-users@lists.osgeo.org</span></a><br></p></div><div><p class="qt-MsoNormal"><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users"><span style="color:rgb(5, 99, 193);">https://lists.osgeo.org/mailman/listinfo/mapserver-users</span></a><br></p></div><div><p class="qt-MsoNormal"> <br></p></div></blockquote><div><p class="qt-MsoNormal"> <br></p></div></div></div></blockquote><div><br></div></body></html>