Invoking a SQL Server Webservice

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » CLR Integration and Programming. » Invoking a SQL Server Webservice

Invoking a SQL Server Webservice

Rate Topic

Display Mode

Topic Options

Author

Message

coboljobs2003

Posted Tuesday, October 20, 2009 8:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, March 13, 2010 11:26 AM
Points: 4, Visits: 2

I am new to SQL server 2005 and I am trying to work on a project to invoke an existing webservice from SQL server 2005.

(This webservice which is a .WSDL file is already being used by another Java application and this webservice connects to mainframe and brings data back from Mainframe).

Can anybody guide me (preferably step by step) how I would go about doing this.

Note: We do not have .net environment.

Post #805754

RBarryYoung

Posted Tuesday, October 20, 2009 4:24 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

I would be very interested in the answer to this also. Smile

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #806164

Paul White

Posted Monday, October 26, 2009 12:43 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:03 AM
Points: 10,990, Visits: 10,543

coboljobs2003 (10/20/2009)

The absolute best method is to use a CLR function or procedure - see http://www.databasejournal.com/features/mssql/article.php/3821271/Calling-a-Web-Service-from-within-SQL-Server.htm for a good walkthrough.

If you insist on not using .NET (why?!) ...you'd end up doing it the SQL 2000 way: using sp_OACreate and the MSXML2.XMLHTTP library. There are examples all over Google, but here's one: http://blog.davebouwman.com/index.php/2008/07/call-geonames-web-services-from-a-sql-stored-procedure/

Though not relevant to your needs, I'm also going to link to Adam Machanic's interesting blog entry on validating URLs: http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/validate-a-url-from-sql-server.aspx

But please, especially as someone new to SQL Server, please, please, please don't go down this track (sp_OA methods). The way to do it is from a CLR component. If your boss won't let you use the correct tool, tell him it's impossible - you will save yourself considerable frustration and pain that way. Using sp_OA stuff to do this would be ~~retarded~~ masochistic in the extreme.

Paul

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #808504

« Prev Topic | Next Topic »

Permissions