Access java webservices from CLR function on sql server in DMZ

Access java webservices from CLR function on sql server in DMZ

Post by RHJhZ2d » Wed, 02 Aug 2006 18:01:01

Well, you in right

Thirst you need to deploy one script, in your front web server who just post
a soap message in the distant web services. In this script you need to return
the distant soap response with the methode of the reference of distant

for exemple in WEBMETHOD add :

public webreference.method distant_function(int param1, string param2) {

webreference.method Response = new

Response = distant_function(param1, param2);
return Response;

Well, now you just need to post the soap question on the web service hosted
in your web server from the private IP, from your CLR Sql server table valued
function, and to get the soap response in your CLR fonction directly.

this is a good way to do it :


1. Deploying CLR to SQL Server (2005) for accessing Project Server Interface (2007)

2. SQL Server Chat next Tuesday: SQL Server 2005 Beta 2 CLR Q & A

Come join the SQL Server and CLR teams in a chat session focusing on CLR
Integration in SQL Server 2005. You will be able to pose questions on all
aspects of CLR integration, including when and how to take advantage of it,
Visual Studio 2005 project support to write/debug/deploy managed code in SQL
Server, reliability/scalability/performance/troubleshooting of managed code
inside SQL Server and more.

October 12, 2004
1:00 - 2:00 P.M. Pacific time

Stephen Dybing

This posting is provided "AS IS" with no warranties, and confers no rights.

3. clr sql server function

4. CLR integration and User Defined functions in SQL Server 2005

5. Sql Server 2005 service stops due to CLR function

6. Application/Program/Product name no longer coming through in CLR SQL Server 2005 function

7. Specifying Precision and Scale for SQLDecimal in User Defined CLR SQL Server Function

8. Favorite Add on's/Add in's for FrontPage 2002

9. Access to SQL Server from DMZ - is Mixed Mode authentication required?

10. SQL server; put SQL in DMZ or internal network ?

11. VS CLR SQL Templates missing (File - New - Project -> Database -> SQL Server)

12. T-SQL vs. CLR/C# in SQL Server 2005

13. [OT] UDFs MS SQL Server 2005 Transact-SQL CLR C#.Net