Today I was playing with the new geo location column. I added the Bing maps key, created a custom list and added the geo location column via code to that list. Upon submitting a new listitem, I received an error, mentioning that a component was not installed, to be able to use geolocation. This is a strange error, because I was able to add the column programmatically, while adding content to the list, is not possible. After checking the Diagnostic log, I noticed the following error:
A required component for using a geolocation field is not installed: Microsoft SQL Server System CLR Types
This remembered me that I had read somewhere (this means: It’s not in the geo location MSDN documentation.It’s written in the documenation on mobile apps and geolocation) that the Sql Server System CLR Types needed to be installed on the Web Front End servers. The package that needs to be installed is called “SqlSysClrTypes.msi”, and depending on the version of SQL that is used, one of the following feature pack needs to be installed:
After the installation, I still couldn’t add any items to the list. An IIS Reset didnt work for me but a reboot did the trick.
Update: I found the place where I read about the installation package