sql server 2008 geography data type


sql server 2008 geography data type
View
Options
Author
Message
Fabian R Silva, -
Fabian R Silva, -
Fabian R Silva, -
posted 12 Years Ago
StrataFrame User (241 reputation)StrataFrame User (241 reputation)StrataFrame User (241 reputation)StrataFrame User (241 reputation)StrataFrame User (241 reputation)StrataFrame User (241 reputation)StrataFrame User (241 reputation)StrataFrame User (241 reputation)StrataFrame User (241 reputation)
Group: StrataFrame Users
Posts: 153, Visits: 1.2K
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
Reply Like 2
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...



Submit

Similar Topics

Post Quoted Reply
Reading This Topic

Powered by InstantForum 2017-1 Final © 2024
Execution: 0.000. 3 queries. Compression Disabled.

Login

Explore
Messages
Mentions
Search