[mapguide-users] SQL Server 2005 & OSGeo.ODBC 3.2 Features -Broken?

[WCT]

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 &gt; 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 &gt; 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#a11585579
Sent from the MapGuide Users mailing list archive at Nabble.com.