<div>
Microsoft Development and Miscellaneous Programming topics added.
</div>


Microsoft Development and Miscellaneous Programming topics added.

<div>
Secondary question then. &nbsp;What is the best way to call WebServices via TSQL? <br />
<br />
Calling SOAP / XML from Bing.
</div>


Secondary question then.  What is the best way to call WebServices via TSQL?

Calling SOAP / XML from Bing.

<div>
working on a new CLR / DLL to bing. That is where I started off and guess how I need to do it.
</div>


working on a new CLR / DLL to bing. That is where I started off and guess how I need to do it.

<div>
<div class="content wysiwyg-content">
I am trying to call Bing Mapping API from our SQL 2012 Server. &nbsp;I started using this code: <br />
<a href="https://alastaira.wordpress.com/2012/05/04/geocoding-in-sql-server-with-the-bing-maps-locations-api/" rel="ugc">https://alastaira.wordpress.com/2012/05/04/geocoding-in-sql-server-with-the-bing-maps-locations-api/</a><br />
<br />
It does not seem to work anymore. I am getting the same .net errors that the other people are having. &nbsp;It seems that the DLL may not execute properly. &nbsp;When I manually call the constructed string from the server, I get the results. &nbsp;I even hard coded the working URL strings into the C# but when called, the Dll returns only an error.<br />
<br />
Does anyone know of a good library or code to call BING's API to lookup and calculate driving distance between points? &nbsp;I am not 100% set on Bing, but do need to do it via SQL.
</div>
</div>


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.

Bing mapping API from SQL Server

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

A Web service is a method of communication between two electronic devices over a network. It is a software function provided at a network address over the Web with the service always on as in the concept of utility computing. A web service has an interface described in Web Services Description Language (WSDL). Other systems interact with the Web service in a manner prescribed by its description using SOAP (Simple Object Access Protocol) messages. There are two major classes of Web services: REST-compliant web services, and Arbitrary web services.

Web Services

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.