Re: [mapguide-users] Connect to MS SQL Server - problems
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 Viewer127.0.0.1Administrator 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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
RE: [mapguide-users] Connect to MS SQL Server
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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Connect to MS SQL Server
sl-king provider should work.. there is no oder provider as far as i know for SQL 2005 -- View this message in context: http://n2.nabble.com/Connect-to-MS-SQL-Server-tp2371943p2371996.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] Connect to MS SQL Server
Hi all, 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? I saw SL-king have a provider but the latest release there is for MGOS 1.2 (FDO 3.2.2) and I would like to use it with MGOS 2.0 - I have both installations, but I would use 1.2 only if all other options fail? Any help will be appreciated Stefan Dalakov ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users