Problem with Extended Stored Procedure calling an WebService...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tommy Selggren - 24 Feb 2005 09:42 GMT

Hi all!

I have a problem with a Extended Stored Procedure that calls a
WebService...I'm using SOAP to call the WebService and I'm using an
TokenManager that I have written myself...I have WSE 2.0 installed...

It works fine when I'm calling it from my PC, but when I call it from the
SQL test server which is a Windows 2003 server with SQL Server 2000
installed.

The message we get when run the Extended Stored Procedure is.

ODBC: Msg 0, Level 16, State 1
Cannot load the DLL XpMQSQL.DLL, or one of the DLLs it references. Reason:
126(The specified module could not be found.).

Does anyone know what I'm missing? We tried to install WSE 2.0 runtime
version but that didn't help...

Regards,
Tommy Selggren
Mandator Sverige AB
http://www.mandator.com

Reply to this Message

Dilip Krishnan - 24 Feb 2005 13:55 GMT

Hello Tommy,
Looks like its a permissions issue. Try giving permissions to the sql
user/service account appropriately or running it under a different account

HTH
Regards,
Dilip Krishnan
MCAD, MCSD.net
dkrishnan at geniant dot com
http://www.geniant.com

> Hi all!
>
[quoted text clipped - 19 lines]
> Mandator Sverige AB
> http://www.mandator.com

Reply to this Message

John Bristowe - 25 Feb 2005 16:49 GMT

Agreed. It's either that, or you haven't deployed all of the required DLLs
to the test server.

John

> Hello Tommy,
> Looks like its a permissions issue. Try giving permissions to the sql
[quoted text clipped - 30 lines]
>> Mandator Sverige AB
>> http://www.mandator.com

Reply to this Message

Problem with Extended Stored Procedure calling an WebService...

Free Magazines