[mapguide-users] ODBC Sql Server 2008 Connection configuration.

[GordonL]

Since ODBC is so slow, I would recommend adding a Geometry column to your
table and using the SQL Server FDO Connection.

If you add the Geometry column, say call it GEOM.

Then populate the X and Y columns by:

update CUENTA_USOS set GEOM = geometry::Point(X, Y, 4326);  

The 4326 is the SRID, LL but it could be anything...

gordon






--
View this message in context: http://osgeo-org.1560.x6.nabble.com/ODBC-Sql-Server-2008-Connection-configuration-tp5279538p5280105.html
Sent from the MapGuide Users mailing list archive at Nabble.com.