MapInfo Pro

 View Only
  • 1.  Data in SQL server

    Posted 07-19-2021 07:21
    Hi,

    Client has data in SQL server that they can successfully connect too via ODBC and view, etc.  One particular dataset is giving them issues.  It opens OK but any save of edits returns the following error.

    The dataset has some multipoints in it which we feel is the issue as they have lots of other datasets working just fine.  This data wasn't loaded into SQL server using Easyloader (don't ask!).

    Any ideas?

    Thanks

    Nick




    ------------------------------
    Nick Hall
    Mapchester LTD
    Manchester
    ------------------------------


  • 2.  RE: Data in SQL server

    Posted 07-19-2021 09:44
    Hi Nick,

    Are you sure your client is using SQL Server?  Could they be using PostGIS instead?  From an internet search the error message seems to be common to PostGIS.

    If SQL Server, you can view the check constraints in SSMS:


    In your client's case, the check constraint is named "enforce_geotype_wkb_geometry".  You are probably on the right track in guessing that the multipoints have something to do with it.  Perhaps the constraint could be modified to accept multipoint geometries.


    ------------------------------
    James Nolet
    Dooley Mitchell & Morrison Pty Ltd
    Mentone, VIC, Australia
    ------------------------------



  • 3.  RE: Data in SQL server

    Posted 07-20-2021 09:24
    James,

    It deffo is in SQL server.  I'll get them to check the constraints thing.

    Much appreciated.

    Nick

    ------------------------------
    Nick Hall
    Mapchester LTD
    Manchester
    ------------------------------