Loading line shapes from database

[cesar.schneider]

I'm using Mapguide Enterprise and SQL Server 2008 and I want to create a layer with some lines using coordinates from database.

I've tried using OSGeo FDO Provider for ODBC, but I can only create points, not lines.

After setup a data connection, I'm able to set a table to use as geometry feature class, but when I'm creating the layer, it recognizes that data resource only as POINT and not as LINE.

I also tried to create a table with a geometry column and added a line record, but I'm not able to create a line using this table.

I would appreciate any ideas and suggestions about how to implement this.

Thank you.