MapInfo Pro

 View Only
  • 1.  ODBC error - I deleted the spatial column

    Posted 11-04-2021 13:56
    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

    Employee
    Posted 11-04-2021 14:58
    Edited by Peter Møller 11-04-2021 14:58
    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 11-05-2021 10:17
    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 11-19-2021 12:31
    Success!

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