[mapguide-users] ODBC connection: No points shown
von Wartburg, Jan BKSD
Jan.vonWartburg at bl.ch
Thu Mar 15 11:28:31 EDT 2012
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
More information about the mapguide-users
mailing list