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 list item, 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 documentation 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
After the installation, I still couldn’t add any items to the list. An IIS Reset didn't work for me but a reboot did the trick.
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 documentation 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
After the installation, I still couldn’t add any items to the list. An IIS Reset didn't work for me but a reboot did the trick.
