We are using AutoCAD Map 3D 2011, MapGuide Studio 2011 and SQL Server 2008. In AutoCAD we select Microsoft OLE DB Provider for SQL Server, and can see the three tables that we are using to link to the DB. Out of the three, we can link two of these and the third one comes up with this error (image error1.jpg).
When we output the dwgs into MapGuide using an SDF format only one of the two files work. In AutoCAD we can see that the items are linked together, but it will not transfer over to MapGuide, also while the SDF files are being created, It usually shows how many line entities are being exported. This one does not show anything, the dialog box just flashes. When we do a load procedure to add the SDF, this error (image error2.jpg)
The OLE Db provider does not understand Spatial data (Geometry etc.) you need to use the provider for SQL Server Spatial