[mapguide-users] SQL Server Provider vs. FDO Provider for a feature join...

[Warren Medernach]

Correction...
Subject should read:  SQL Server FDO Provider vs. ODBC Provider...
 
Warren

________________________________

From: Warren Medernach [mailto:warren.medernach at imaginit.ca] 
Sent: Friday, October 27, 2006 9:01 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] SQL Server Provider vs. FDO Provider for a
feature join...


Hello all,
 
I want to create a join from and SDF feature source, to a SQL Server
database.
I read in the list that the SQL Server FDO Provider is only for
accessing datastores within SQL Server (datastores created with Autodesk
Map).  
 
So, that would leave the ODBC Provider to connect to SQL Server for the
join.  However, I cannot get this to work...  I can choose the ODBC
Provider, and specify the DSN to my SQL Server, Test Connection is
successful, but when I try to set the coordinate system, this is never
'saved'.  This causes a problem, as it seems to give an error anytime
you try to join a feature source that doesn't have a coordinate system
assigned.
 
Btw, I was successful in getting this to function with an Access
dbase...
Any help and/or guidance would be greatly appreciated.
 
Warren Medernach
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20061027/7b08968c/attachment.html