Problems with SQl server CLR assembly after upgrade...

See more:

C#

ASP.NET

SQL-Server

Google-Maps

, +

Where I work we have a website that just launched. In the site there is a school sorter function that uses Google Maps API to find schools in a given radius based on the zip code and search distance that worked initially. It is a stored procedure that references a function that defined in a C# CLR assembly. It was stored in a 32 bit SQL Server 2005 server. we have since upgraded to SQL Server 2008 R2 64 bit, and the assembly stopped working after the upgrade. when the function is called that references Google maps it always returns status code 0, which I think means the request is not being sent. I put the code on my laptop yesterday and started playing with it, and some how got it to work, but sadly I am not sure of what I did so I have created a new database and I am trying to recreate what I did to make it work. It was a setting change I know, I am just not sure which one... I would be eternally grateful for any help.