Bing mapping API from SQL Server

I am trying to call Bing Mapping API from our SQL 2012 Server.  I started using this code:
https://alastaira.wordpress.com/2012/05/04/geocoding-in-sql-server-with-the-bing-maps-locations-api/

It does not seem to work anymore. I am getting the same .net errors that the other people are having.  It seems that the DLL may not execute properly.  When I manually call the constructed string from the server, I get the results.  I even hard coded the working URL strings into the C# but when called, the Dll returns only an error.

Does anyone know of a good library or code to call BING's API to lookup and calculate driving distance between points?  I am not 100% set on Bing, but do need to do it via SQL.
LVL 4
egarrisonCEO / CTOAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Microsoft Development and Miscellaneous Programming topics added.
0
egarrisonCEO / CTOAuthor Commented:
Secondary question then.  What is the best way to call WebServices via TSQL?

Calling SOAP / XML from Bing.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Since SQL Server 2005 that you can do that using Common Language Programming (CLR). I'm not expert in CLR but I think this article is a good start for you.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
egarrisonCEO / CTOAuthor Commented:
working on a new CLR / DLL to bing. That is where I started off and guess how I need to do it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.