SQL 2005 CLR SP calling external Web Services problem

  • Greetings,

    I am working on a CLR stored procedure that calls a web service to upload files to a 3rd party server using MTOM, but my SQL Server 2005 Stanard Edition errors out pointing to the following sqlserver.exe.config section:

    webServices

    soapExtensionImporterTypes

    add type="Microsoft.Web.Services3.Description.WseExtensionImporter, Microsoft.Web.Services3, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"

    The SQL Sever is running on Windows 2003 Server 64-bit Edition, and a console implementation of the same logic works fine.

    The error I am getting is:

    The value of the property 'type' cannot be parsed. The error is: Could not load file or assembly 'Microsoft.Web.Services3, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe.Config line 26)

    Line 26 is "add type="Microsoft.Web.Services3.Description.WseExtensionImporter" as provided above.

    Any ideas as to what this issue may be?

    Thanks in advance.

  • Sounds to me like you are going to need to set up the assembly as unsafe. I don't believe you can access those libraries without it.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • Thanks Matt for the reply.

    The assembly is signed and set to Unsafe. BTW, other such code which calls external web services works fine.

    The implementation in question is using MTOM for binary file uploads and that is the only difference.

    On the otherhand, the same assembly has other methods which works fine if I commented out the secion of sqlserver.exe.config file that it complains about.

  • Hmm, you'd probably get more nibbles if you spelled out MTOM at least once. (I apologize if I missed it :-))

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • seena (6/23/2009)


    sqlserver.exe.config

    ...

    The system cannot find the file specified. (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe.Config line 26)

    Just to ensure, do you have a typo in your file name?

    You:

    sqlserver.exe.config

    Error:

    sqlservr.exe.Config

    Did you buy one "e" too much?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply