[mapguide-users] ODBC connection: No points shown

[von Wartburg, Jan BKSD]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20120315/780cf191/attachment.html