|
Home > Archive > MS SQL Server New Users > April 2005 > Calling a web service from a CLR SQL stored procedure
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Calling a web service from a CLR SQL stored procedure
|
|
| Krishna 2005-04-22, 1:23 pm |
| Hi,
I am trying to call a remote webservice from within SQl server using CLR.
However, SQL Server gives me an error saying that load(), loadModule() etc
are disabled. Of what I can tell, C# needs to dynamically generate and load
the XML serialization for the web service call. Does anyone know how I can
get around this problem?
| |
| Adam Machanic 2005-04-22, 8:23 pm |
| Did you create the assembly with EXTERNAL permission?
Look up the CREATE ASSEMBLY syntax and you'll see what I'm talking about.
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Krishna" <Krishna@discussions.microsoft.com> wrote in message
news:D14843BB-02A9-497C-8D0C- 61D54984B6B1@microso
ft.com...
> Hi,
>
> I am trying to call a remote webservice from within SQl server using CLR.
> However, SQL Server gives me an error saying that load(), loadModule() etc
> are disabled. Of what I can tell, C# needs to dynamically generate and
load
> the XML serialization for the web service call. Does anyone know how I can
> get around this problem?
|
|
|
|
|