Thank you, Jonathon.
As long as i don't add a geometry i can preview the data correctly.
But the points don't show up in the preview when i added the geometry. It says:
"An exception occurred in FDO component. Internal error "
The corresponding log message looks like this:
<2012-03-16T10:12:47> 1240 MapGuide Developer 127.0.0.1 Administrator
Error: An exception occurred in FDO component.
Internal error
StackTrace:
- MgFeatureServiceHandler.ProcessOperation() line 83 file
c:\builds\mg22win32\mgdev\server\src\services\feature\FeatureServiceHandler.cpp
- MgOpSelectFeatures.Execute() line 109 file
c:\builds\mg22win32\mgdev\server\src\services\feature\OpSelectFeatures.cpp
- MgServerFeatureService.SelectFeatures() line 433 file
c:\builds\mg22win32\mgdev\server\src\services\feature\ServerFeatureService.cpp
- MgServerSelectFeatures.SelectFeatures() line 266 file
c:\builds\mg22win32\mgdev\server\src\services\feature\ServerSelectFeatures.cpp
I have set the same coordinate system as in my map. I also tried a X-Y Meter
coordinate system.
The primary key indeed should be int32. FDO Toolbox and Autocad Map show this
correctly, while Maestro is showing int64.
I have edited the config.xml. I deleted the primary key element and took
another suitable property as the primary key. It had no effect.
What could be done in addition to prevent this error?
In my view that i'm accessing there are also the tables dtproperties,
sysconstraints and syssegments next to the table that i need for the points.
Are they of any importance when accessing the table with the points? Just for
testing i deleted them in the config.xml so that only my points-table remained.
But still, the same error.
Regards,
Jan
________________________________
From: [email protected]
[mailto:[email protected]] On Behalf Of GIS4U
Sent: Thursday, March 15, 2012 7:30 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] ODBC connection: No points shown
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]<mailto:[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]<mailto:[email protected]>
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
