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

[Ismael Cams]

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