MapInfo Pro

  • 1.  ODBC error - I deleted the spatial column

    Posted 24 days ago
    Hi,
    I've been linking Mapinfo to SQL (at the edge of my comfort zone here.)
    After doing some maintenance work I've now got this error message when I try to map my table.
    error messageYep, I've managed to deleted column MI MASTERMAP STYLE

    So how do I fix this? Can I just delete that entry in the mapcatalog and make it mappable again?

    That seems likely but SQL is unforgiving so thought it was best to ask first.

    Martin


    ------------------------------
    Martin Burroughs
    Oldham Council
    ------------------------------


  • 2.  RE: ODBC error - I deleted the spatial column

    Posted 24 days ago
    Edited by Peter Horsbøll Møller 24 days ago
    Hi Martin

    Did you have the column MI MASTERMAP STYLE in your data table in SQL Server? If so, one solution is to add it back as a character type column with a maximum length of 254 characters, ANSI type, not Unicode.

    You can also modify the record in the MapCatalog in SQL Server and remove the reference to this column.

    And finally, removing the entire entry from the MapCatalog and then making it mappable again is another solution.

    Note that if you had styling information in that column, this is of course lost if you deleted the column.

    It may not be the spatial column as such, you deleted. It might just have been the column holding styling information.

    ------------------------------
    Peter Horsbøll Møller
    Principal Presales Consultant | Distinguished Engineer
    Precisely | Trust in Data
    ------------------------------



  • 3.  RE: ODBC error - I deleted the spatial column

    Posted 23 days ago
    Hi Peter, thanks for that. I'm going to try the removing from mapcatalog route, thanks.

    ------------------------------
    Martin Burroughs
    Oldham Council
    ------------------------------



  • 4.  RE: ODBC error - I deleted the spatial column

    Posted 9 days ago
    Success!

    ------------------------------
    Martin Burroughs
    Oldham Council
    ------------------------------