Does the information show up in your Data Source when you preview? 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.
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... Regards, Jonathon On Thu, Mar 15, 2012 at 8:28 AM, von Wartburg, Jan BKSD < [email protected]> wrote: > ** > Hello all, > > 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). 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. > In the server error log I have the following entry: > > <2012-03-15T15:41:00> 1712 Ajax Viewer 127.0.0.1 Administrator > Error: Failed to stylize layer: test > An exception occurred in FDO component. > Internal error > StackTrace: > - MgMappingUtil.StylizeLayers() line 831 file > c:\builds\mg22win32\mgdev\server\src\services\mapping\MappingUtil.cpp > > The feature xml looks like this: > > <?xml version="1.0" encoding="utf-8"?> > <FeatureSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > xmlns:xsd="http://www.w3.org/2001/XMLSchema"; > xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd"> > <Provider>OSGeo.ODBC</Provider> > <Parameter> > <Name>ConnectionString</Name> > <Value>DSN=ADAM;Uid=sd3;Pwd=adff;</Value> > </Parameter> > <SupplementalSpatialContextInfo> > <Name>Default</Name> > <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> > </SupplementalSpatialContextInfo> > <ConfigurationDocument>config.xml</ConfigurationDocument> > </FeatureSource> > > Can anyone help? > > Thanks&Regards, > Jan > > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > >
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
