Which driver are you using ? I had the same problem with the native SQL driver. The problem is solved by using the SQL Server driver.
WCT wrote: > > MGOS 1.2.0 RC1 / ODBC 3.2 Provider, WIN32 > > I am using Mapguide Studio 2007 1.0.0.17864. I am trying to create a Data > Connection to SQL Server 2005 database using ODBC provider. I can > successfully connect to the database but clicking the "Show Tables" button > returns no results. None of the tables have any features data (I am trying > to use the data for feature joins w/ existing features). I see errors in > the server log: > > <2007-07-13T12:56:44> Administrator > Error: An exception occurred in FDO component. > Invalid length 0 for column type VARCHAR, must be > 0 > StackTrace: > - MgFeatureServiceHandler.ProcessOperation line 83 file > c:\build_bond_area\mapguide_open_source_v1.2\build_17.4\mgdev\server\src\services\feature\FeatureServiceHandler.cpp > - MgOpDescribeSchemaAsXml.Execute line 107 file > c:\build_bond_area\mapguide_open_source_v1.2\build_17.4\mgdev\server\src\services\feature\OpDescribeSchemaAsXml.cpp > - MgServerDescribeSchema.DescribeSchema line 500 file > c:\build_bond_area\mapguide_open_source_v1.2\build_17.4\mgdev\server\src\services\feature\ServerDescribeSchema.cpp > - MgServerDescribeSchema.ExecuteDescribeSchema line 173 file > c:\build_bond_area\mapguide_open_source_v1.2\build_17.4\mgdev\server\src\services\feature\ServerDescribeSchema.cpp > An exception occurred in FDO component. > Invalid length 0 for column type VARCHAR, must be > 0 > > > Has anyone had success with this setup? My providers.xml looks proper: > > <FeatureProvider> > <Name>OSGeo.ODBC.3.2</Name> > <DisplayName>OSGeo FDO Provider for ODBC</DisplayName> > <Description>Read/write access to ODBC-based data store. Supports XYZ > point features.</Description> > <IsManaged>False</IsManaged> > <Version>3.2.2.0</Version> > <FeatureDataObjectsVersion>3.2.2.0</FeatureDataObjectsVersion> > <LibraryPath>C:\Program > Files\MapGuideOpenSource\Server\Bin\FDO\ODBCProvider.dll</LibraryPath> > </FeatureProvider> > > > -- View this message in context: http://www.nabble.com/SQL-Server-2005---OSGeo.ODBC-3.2-Features--Broken--tf4076323s16610.html#a11601509 Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
