[mapguide-users] Connect to MS SQL Server - problems

[Stefan Dalakov]

Thank you, Jason.
SL King provider for SQL server does not recognize Map3D geometry 
columns, so I installed MS SQL server2008. Apart from the fact that 
installation of Server Management Studio did not install it correctly, I 
managed to transfer my 2005 database to 2008 - using FDO Bulk copy. Now 
MGOS is able to connect to data, geometry type of the data in tables is 
recognized  but I see nothing on screen.
The error log shows :

<2009-02-24T15:26:46>     Ajax Viewer    127.0.0.1    Administrator
 Error: Failed to stylize layer: sql2008layer2
        An exception occurred in FDO component.
        RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot 
call methods on image.
 StackTrace:
  - MgMappingUtil.StylizeLayers line 786 file 
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\mapping\MappingUtil.cpp    
Failed to stylize layer: sql2008layer2

An exception occurred in FDO component.

RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot call 
methods on image.



Anyone has ideas ?

Stefan Dalakov






Jason Birch wrote:
> The SQL Server 2005 provider that comes with Map 3D is proprietary, and
> not available in MapGuide Open Source.  If you want to display this data
> you will need to use MapGuide Enterprise.
>
> If it's an option, I would suggest using the open source SQL Server 2008
> provider.
>
> Jason
>
> -----Original Message-----
> From: Stefan Dalakov
> To: MapGuide Users Mail List
> Subject: [mapguide-users] Connect to MS SQL Server
>
> I have installed MS SQL Server Express Edition 2005 and have some tables
>
> there, created by Map3D 2009, containing lines and points.
> Which provider should I use to connect to this data as ODBC provider 
> allows only point features?
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>