StrataFrame Forum

sql server 2008 geography data type

http://forum.strataframe.net/Topic30904.aspx

By Fabian R Silva, - - 2/9/2012

I have a table that have a geography column, when try to update this column (existent data) the next exception shows:

{"An error occurred while saving an the data to the server."}

InnerException:
{"Operand type clash: sql_variant is incompatible with geography"}

I Can't use this data type (geography)with sql server 2008 r2 tables that was serialized with strataframe BOM?

In that case I can use a point data or another recomeended data type or have to use 2 fields 1 for latitude and another for longitude? 

Thanks