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

WCT stephen.park at westerncorrosion.com
Mon Jul 16 13:39:24 EDT 2007


Thanks. Yes I was using the native driver. Changing this to {driver=SQL
Server} I can see the underlying tables at this point. FWIW I'm fairly
certain the native driver used to work (I have an old data source in my
library that works on 1.0.1 and no longer works on 1.2.0 version). 




Ismael Cams wrote:
> 
> 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#a11624192
Sent from the MapGuide Users mailing list archive at Nabble.com.



More information about the mapguide-users mailing list