All, We are using Mapguide 2.0.2 and a SQL Server 2008 SQLEXPRESS Database. Our problem is trying to join to a SDF data source. We get the connection fine now and the tables list in the join window, along with the fields. However, when we try to select on the parcel, it gives us an error (image attached) of "Object not found" and we can't figure out what we need to do. What we are trying to accomplish is the following:
-Database contains the major data that is dynamic (edited by client and is
NON spatial)
-One of the tables, tblLots, contains the lot data that is then linked
with the other tables in the DB
-SDF contains the parcel data and a field called "NUMBER" (Ex. 0010-A)
-I also tried separating it into "LotNumber" and "LotLetter" with both
the SDF and the DB with no success
-I am using the SQL Server Spatial provider
-I also tried connecting the DB to an ODBC and then connecting the
ODBC to Mapguide, and couldn't get it to connect using the ODBC provider
-I tried different types of Joins with no success
Does anyone have any ideas of where we can try next? If you need more
information, please let me know.
Rich
P.S. DB is on one server, same as the web, and Mapguide is on a different
server. We are editing using Maestro 2.0.
<<attachment: Mapguide Error.JPG>>
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
