[mapguide-users] ODBC connection: No points shown

[GIS4U]

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 <
Jan.vonWartburg at bl.ch> 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
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20120315/41d0315c/attachment.html