<div>Does the information show up in your Data Source when you preview?</div><div> </div><div>If so, do you have a coordinate system set so that MG can reference it to the map? If not, make sure to set it.</div><div> </div>
<div>If so, I would suspect that the primary key as int64 may be the issue. I think you would be safer with int32. Given the FDO error message, I am thinking this is the culprit...</div><div> </div><div>Regards,</div><div>
Jonathon<br><br></div><div class="gmail_quote">On Thu, Mar 15, 2012 at 8:28 AM, von Wartburg, Jan BKSD <span dir="ltr"><<a href="mailto:Jan.vonWartburg@bl.ch">Jan.vonWartburg@bl.ch</a>></span> wrote:<br><blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
<u></u>
<div>
<div><span><font face="Arial">Hello
all,</font></span></div>
<div><span><font face="Arial"></font></span> </div>
<div><span><font face="Arial">I have connected to
a SQL server 2000 database using the ODBC provider. I have configured the tables
in order to get the right columns for the X and Y values (stored as "double" in
the database, primary key is int64). </font></span><span><font face="Arial">After creating a layer using
this feature source, the points should show up in my map, but they don't. I'm
using MGOS 2.2 and Maestro 4.0.0 on Windows XP.</font></span></div>
<div><span><font face="Arial">In the server error
log I have the following entry:</font></span></div>
<div><span><font face="Arial"></font></span> </div>
<div><span><font face="Arial"><2012-03-15T15:41:00> 1712 Ajax
Viewer 127.0.0.1 Administrator<br> Error: Failed to stylize
layer: test<br> An exception occurred
in FDO component.<br> Internal error
<br> StackTrace:<br> - MgMappingUtil.StylizeLayers() line 831 file
c:\builds\mg22win32\mgdev\server\src\services\mapping\MappingUtil.cpp</font></span></div>
<div><span><font face="Arial"></font></span> </div>
<div><span><font face="Arial">The feature xml
looks like this:</font></span></div>
<div><span><font face="Arial"></font></span> </div>
<div><span><font face="Arial"><?xml
version="1.0" encoding="utf-8"?><br><FeatureSource xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>"
xmlns:xsd="<a href="http://www.w3.org/2001/XMLSchema" target="_blank">http://www.w3.org/2001/XMLSchema</a>"
xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd"><br>
<Provider>OSGeo.ODBC</Provider><br>
<Parameter><br>
<Name>ConnectionString</Name><br>
<Value>DSN=ADAM;Uid=sd3;Pwd=adff;</Value><br>
</Parameter><br>
<SupplementalSpatialContextInfo><br>
<Name>Default</Name><br>
<CoordinateSystem>PROJCS["CH1903 /
LV03",GEOGCS["CH1903",DATUM["CH1903",SPHEROID["Bessel
1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84[674.374,15.056,405.346,0,0,0,0],AUTHORITY["EPSG","6149"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4149"]],PROJECTION["Hotine_Oblique_Mercator"],PARAMETER["latitude_of_center",46.95240555555556],PARAMETER["longitude_of_center",7.439583333333333],PARAMETER["azimuth",90],PARAMETER["rectified_grid_angle",90],PARAMETER["scale_factor",1],PARAMETER["false_easting",600000],PARAMETER["false_northing",200000],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AUTHORITY["EPSG","21781"]]</CoordinateSystem><br>
</SupplementalSpatialContextInfo><br>
<ConfigurationDocument>config.xml</ConfigurationDocument><br></FeatureSource></font></span></div>
<div><span><font face="Arial"></font></span> </div>
<div><span><font face="Arial">Can anyone
help?</font></span></div>
<div><span><font face="Arial"></font></span> </div>
<div><span><font face="Arial">Thanks&Regards,</font></span></div>
<div><span><font face="Arial">Jan</font></span></div>
<div><span><font face="Arial"></font></span> </div></div>
<br>_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></blockquote></div><br>