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 14 Years Ago
Advanced StrataFrame User (809 reputation)Advanced StrataFrame User (809 reputation)Advanced StrataFrame User (809 reputation)Advanced StrataFrame User (809 reputation)Advanced StrataFrame User (809 reputation)Advanced StrataFrame User (809 reputation)Advanced StrataFrame User (809 reputation)Advanced StrataFrame User (809 reputation)Advanced StrataFrame User (809 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 6
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...



Submit

Threaded View
Threaded View
sql server 2008 geography data type
Fabian R Silva, - - 14 Years Ago

Similar Topics

Post Quoted Reply
Reading This Topic

Powered by InstantForum 2017-1 Final © 2026
Execution: 0.000. 1 query. Compression Enabled.

Login

Explore
Messages
Mentions
Search