[fdo-users] MSSQLServerSpatial(2008) can't enum all tables ofdatabase?

[Carl]

the problem is resolved. please refer to

http://www.nabble.com/Maestro%3A-can%27t-find-the-table-containing-the-geometry-field-with-SQLServerSpatial-td19977173.html#a20015778

In my case, all tables, including non-spatial tables, can be listed. I
couldn't know why non-spatial tables can't be read in Matt's case. maybe
somebody can give much help.



Matt Winger wrote:
> 
> I have had the same issue with the MSSQL 2008 spatial provider.
> My connection only seems to read the spatial tables and doesn't the
> Non-spatial tables.
> Any reason why?
> 
> Matt Winger
> GIS Application Engineer
> mwinger at rand.com
> T: 866-485-5220 x203|C: 517-781-0216
> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org
> [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Carl
> Sent: Wednesday, October 15, 2008 9:33 AM
> To: fdo-users at lists.osgeo.org
> Subject: [fdo-users] MSSQLServerSpatial(2008) can't enum all tables
> ofdatabase?
> 
> 
> I need to add a SQL Server 2008 Spatial Data Layer to MapGuide OS Map
> and
> meet a problem as described in follow link:
> 
> http://www.nabble.com/Maestro%3A-can%27t-find-the-table-containing-the-g
> eometry-field-with-SQLServerSpatial-td19977173.html
> http://www.nabble.com/Maestro can't find the table containing the
> geometry
> field with SQLServerSpatial td19977173.html 
> 
> I tried 'DescribeSchema' of 'Feature' of
> http://localhost/mapguide/mapagent/index.html. the returned XML for a
> SQL
> server 2008 spatial database covers only partial tables.
> 
> It seems the FDO provider for MS SQL Server 2008 can't iterate all
> tables of
> database.
> -- 
> View this message in context:
> http://www.nabble.com/MSSQLServerSpatial%282008%29-can%27t-enum-all-tabl
> es-of-database--tp19993482p19993482.html
> Sent from the FDO Users mailing list archive at Nabble.com.
> 
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> 
> 

-- 
View this message in context: http://www.nabble.com/MSSQLServerSpatial%282008%29-can%27t-enum-all-tables-of-database--tp19993482p20015849.html
Sent from the FDO Users mailing list archive at Nabble.com.