HOW TO ACCESS WEB SERVICE...

[SMS636]

I want to access a web service using TSQL code. Any solutions or examples?

 

[Catadmin]

Web applications can access T-SQL code if written correctly, but T-SQL code doesn't usually (as far as I know) access Web Services.

What services are you trying to access? What do you want to do with them?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

You can't access a web service directly via T/SQL. T/SQL is the SQL Server programming language. To access an externial web service you would need to use a CLR procedure or an extended stored procedure (depending on your SQL version and what features your DBAs have enabled).

Accessing a web service via the CLR may or may not be supported. Only the following assemblies are supported.
• Microsoft.VisualBasic.dll
• Mscorlib.dll
• System.Data.dll
• System.dll
• System.Xml.dll
• Microsoft.VisualC.dll
• CustomMarshalers.dll
• System.Security.dll
• System.Web.Services.dll
• System.Data.SqlXml.dll
• System.Transactions.dll
• System.Data.OracleClient.dll
• System.Configuration.dll
(See

http://support.microsoft.com/kb/922672/en-us)

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com