<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.21299" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2>Thank you, Jonathon.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012>
<DIV dir=ltr align=left><SPAN class=831201409-16032012></SPAN><SPAN
class=831201409-16032012><FONT face=Arial size=2>As long as i don't add a
geometry i can preview the data correctly.</FONT></SPAN></DIV></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2>But the points don't show up in the preview when i added the geometry. It
says: "<FONT face="Times New Roman" size=3>An exception occurred in FDO
component. Internal error "</FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2>The corresponding log message looks like this:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial size=2>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2><2012-03-16T10:12:47> 1240 MapGuide
Developer 127.0.0.1 Administrator<BR> Error: An exception
occurred in FDO component.<BR>
Internal error <BR> StackTrace:<BR> -
MgFeatureServiceHandler.ProcessOperation() line 83 file
c:\builds\mg22win32\mgdev\server\src\services\feature\FeatureServiceHandler.cpp<BR>
- MgOpSelectFeatures.Execute() line 109 file
c:\builds\mg22win32\mgdev\server\src\services\feature\OpSelectFeatures.cpp<BR>
- MgServerFeatureService.SelectFeatures() line 433 file
c:\builds\mg22win32\mgdev\server\src\services\feature\ServerFeatureService.cpp<BR>
- MgServerSelectFeatures.SelectFeatures() line 266 file
c:\builds\mg22win32\mgdev\server\src\services\feature\ServerSelectFeatures.cpp </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT
color=#0000ff></FONT></SPAN> </DIV></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012>I have set the same
coordinate system as in my map. I also tried a X-Y Meter coordinate
system.</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012></SPAN><SPAN
class=831201409-16032012></SPAN><SPAN class=831201409-16032012><FONT face=Arial
size=2>The primary key indeed should be int32. FDO Toolbox and Autocad Map show
this correctly, while Maestro is showing int64.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2>What could be done in addition to prevent this error?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2>Regards,<BR>Jan</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=831201409-16032012><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of
</B>GIS4U<BR><B>Sent:</B> Thursday, March 15, 2012 7:30 PM<BR><B>To:</B>
MapGuide Users Mail List<BR><B>Subject:</B> Re: [mapguide-users] ODBC
connection: No points shown<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Does the information show up in your Data Source when you preview?</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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...</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV>Jonathon<BR><BR></DIV>
<DIV class=gmail_quote>On Thu, Mar 15, 2012 at 8:28 AM, von Wartburg, Jan BKSD
<SPAN dir=ltr><<A
href="mailto:Jan.vonWartburg@bl.ch">Jan.vonWartburg@bl.ch</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"><U></U>
<DIV>
<DIV><SPAN><FONT face=Arial>Hello all,</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial>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). </FONT></SPAN><SPAN><FONT face=Arial>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.</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial>In the server error log I have the following
entry:</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial><2012-03-15T15:41:00> 1712 Ajax
Viewer 127.0.0.1 Administrator<BR> Error: Failed to stylize
layer: test<BR> An exception
occurred in FDO component.<BR>
Internal error <BR> StackTrace:<BR> - MgMappingUtil.StylizeLayers()
line 831 file
c:\builds\mg22win32\mgdev\server\src\services\mapping\MappingUtil.cpp</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial>The feature xml looks like
this:</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial><?xml version="1.0"
encoding="utf-8"?><BR><FeatureSource xmlns:xsi="<A
href="http://www.w3.org/2001/XMLSchema-instance"
target=_blank>http://www.w3.org/2001/XMLSchema-instance</A>" xmlns:xsd="<A
href="http://www.w3.org/2001/XMLSchema"
target=_blank>http://www.w3.org/2001/XMLSchema</A>"
xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd"><BR>
<Provider>OSGeo.ODBC</Provider><BR>
<Parameter><BR>
<Name>ConnectionString</Name><BR>
<Value>DSN=ADAM;Uid=sd3;Pwd=adff;</Value><BR>
</Parameter><BR>
<SupplementalSpatialContextInfo><BR>
<Name>Default</Name><BR>
<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><BR>
</SupplementalSpatialContextInfo><BR>
<ConfigurationDocument>config.xml</ConfigurationDocument><BR></FeatureSource></FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial>Can anyone help?</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN><FONT face=Arial>Thanks&Regards,</FONT></SPAN></DIV>
<DIV><SPAN><FONT face=Arial>Jan</FONT></SPAN></DIV>
<DIV><SPAN><FONT
face=Arial></FONT></SPAN> </DIV></DIV><BR>_______________________________________________<BR>mapguide-users
mailing list<BR><A
href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR><A
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users"
target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>