You need to close the table and reopen it from the database. If you have opened the table and it wasn't mappable, MapInfo will not check to see if it has been mappable until you reopne the table from the database. It's not enough to close the table and reopen the table using the tab file.
Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: Alan Hale [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 7:03 PM To: Peter Horsbøll Møller; MapInfo-L Subject: RE: [MI-L] Unable to Make DBMS Table Mappable Peter Many thanks for this, it does away with the error message. However, I am still puzzled. I can't open a map window on the table, and Create Points is greyed out? What do I do after making the table mapapple? Regards Alan >>> Peter Horsbøll Møller <[EMAIL PROTECTED]> 27 March 2006 >>> Alan, I think the problem is that the table MapInfo_MapCatalog hasn't been created in the database. You can easily create this table using the DBMS Catalog tool that you'll find in the Tool Manager. HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Hale Sent: Monday, March 27, 2006 3:30 PM To: MapInfo-L Subject: [MI-L] Unable to Make DBMS Table Mappable I have an ODBC data source to a SQL Server DB and am able to open a connection and a table successfully in MapInfo via DBMS. But when I try to make the table mappable (using Lat/Long fields and index type XYCoordinates) I get an error back from the ODBC driver "Invalid Object name 'MAPINFO.MAPINFO_MAPCATALOG", followed by "The table you have chosen cannot be made mappable. To be made mappable the table must contain a spatial column or at least 2 numeric columns". Any help please? _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
