geography datatype not supported by mylittleadmin in sql 2008?

Discussion in 'Databases' started by helpforhorm, Jan 7, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. helpforhorm

    helpforhorm Guest

    Is it broken or not supported?

    I have a table with a field in the geography data type.

    nothing works with this table.

    1) Adding a new record fails. the data in the geography field is not even included in the insert string that created and executed, thus producing the error: "error near ," and looking at the statement is simple joins 2 commas together instead of including the data for the field. e.g column (geo,f1,f2) values (,1,1)

    2) navigating to the table and pressing the "open" button doesn't open the table and show the records, it simply says 0 out of 0. And yes there is data in the table, it works fine when i write my own code to view the table contents.

    3) Nothing ever exports. Doesn't matter which export type I choose, it returns an error that it has crashed and provides the stack trace. it indicates than a null value was not handled.

    I've sent a suport ticket but got no where...

    So I'm posing the question in here... does this work, or will it ever work?
    If it doesnt work, why bother saying we can use mylittleadmin to edit our sql 2008 tables? since this is pretty much the main feature upgrade from 2005
     
  2. Hi! Could you please send us some screenshots of the error you get as well as a dump of your table? (support [at] mylittletools.net)

    Thanks in advance
     
  3. JorgeR

    JorgeR DiscountASP.NET Staff

    The issue has been resolved. The myLittleTools now correctly reads the geography data type
     
  4. Any chance to have some feedback about what was wrong?
    TIA (support [at] mylittletools.net)
     
  5. JorgeR

    JorgeR DiscountASP.NET Staff

    We updated to version 5.3a to fix the problem.
     
  6. 3.5a

    Thanks for the info.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page