Re: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-19 Thread Carl
>>> obtained from the Windows SDK download at >>> http://fdo.osgeo.org/content/fdo-332-downloads. You'd just need to >>> extract >>> the following DLL's: >>> >>> SQLServerSpatialProvider.dll >>> SQLServerSpatialOverrides

Re: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-17 Thread Kenneth Skovhede, GEOGRAF A/S
com/Maestro%3A-can%27t-find-the-table-containing-the-geometry-field-with-SQLServerSpatial-tp19977173p19994687.html -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brent Robinson Sent: Wednesday, October 15, 2008 12:37 PM To: MapGuide Users Mail List Su

RE: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-16 Thread Brent Robinson
, October 16, 2008 11:38 AM To: mapguide-users@lists.osgeo.org Subject: RE: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial Exactly, the returned XML based on the new version of SQLSpatialProvider covers all tables. But now the root node name

RE: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-16 Thread Carl
erent. > > If you get a chance to try this out, please let me know if it fixes the > problem. > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Carl > Sent: Wednesday, October 15, 2008 10:28 AM > To: mapguide-users@lists

RE: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-16 Thread Carl
ld-with-SQLServerSpatial-tp19977173p19994687.html > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brent > Robinson > Sent: Wednesday, October 15, 2008 12:37 PM > To: MapGuide Users Mail List > Subject: RE: [mapguide-users] Maes

RE: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-15 Thread Brent Robinson
ssage- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brent Robinson Sent: Wednesday, October 15, 2008 12:37 PM To: MapGuide Users Mail List Subject: RE: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial This is a known d

RE: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-15 Thread Brent Robinson
08 10:28 AM To: mapguide-users@lists.osgeo.org Subject: RE: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial yes Brent Robinson-5 wrote: > > Hi Carl, > > Do any of your tables have a varchar(max) column? > > Brent. > >

RE: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-15 Thread Carl
yes Brent Robinson-5 wrote: > > Hi Carl, > > Do any of your tables have a varchar(max) column? > > Brent. > > > -- View this message in context: http://www.nabble.com/Maestro%3A-can%27t-find-the-table-containing-the-geometry-field-with-SQLServerSpatial-tp19977173p19994687.html Sent from

RE: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-15 Thread Brent Robinson
d the table containing the geometry field with SQLServerSpatial sometimes, while I choose the featuresoure, follow message is shown and Maestro stops. But if I re-choose the same featuresource, it works without any message: Failed to read schema from data source. The operation gave the error me

Re: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-15 Thread Carl
Yes, I tried http://localhost/mapguide/mapagent/index.html. the returned xml covers only fewer tables of database. Then I create a new database, add table one by one, and try 'describeschema' from above web page. I couldn't find the rule the FDO/MapGuide used to enum the tables. all the tables

Re: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-15 Thread Kenneth Skovhede, GEOGRAF A/S
Ok. That at least traces the problem away from Maestro. The problem is now, determining if it is in MapGuide or FDO. You can access the MSSql server without MapGuide, by using the FDO toolbox: http://code.google.com/p/fdotoolbox/ If you cannot see the schema's there, I recomend that you create a

Re: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-15 Thread Carl
sometimes, while I choose the featuresoure, follow message is shown and Maestro stops. But if I re-choose the same featuresource, it works without any message: Failed to read schema from data source. The operation gave the error message: remote server return error: (559) MgFdoException.: An Excep

Re: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-14 Thread Kenneth Skovhede, GEOGRAF A/S
I guess there should be an "unmapped type" - type, to deal with situations like this. You can set it to "string", and it should read out just fine. I have created a ticket for the problem: http://trac.osgeo.org/mapguide/ticket/724 As you may have noticed, Maestro issues calls to a web interface

Re: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-14 Thread Carl
yes, the exception is exactly fired because of the lost the type map. Then I tried to comment the follow bold line: / public class FeatureSetColumn { internal FeatureSetColumn(string name, int type) {

Re: [mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-14 Thread Carl
I traced into the code further more, and found the exception occurs while creating a featuresetcolumn with field type of 'varbinary': (as bold line of follow code) public FeatureSourceSchema(XmlNode node, XmlDocument doc, XmlNamespaceManager mgr) {

[mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

2008-10-14 Thread Carl
I don't know whether it is the issue of Maestro, or MGOS server, or even the FDO provider for SQL server 2008. I have a SQL server 2008 Database with more than 200 tables. some tables has the name with the max length of 64 alpha-beta letters. there is only one table, with name length of 35 letter