Calling a web service frin inside a extended stored procedure DLL

[mthomas]

Hi there,

I am using VS.net c++.

I created a test dialog box application. I added an addressing web reference. There is button on the dialog that executes the following code:

' m_lAddressID is the civic ID (text box)
' m_strAddress is where the address string will go (text box)
CAddresses* pAddressingSoap = new CAddresses;
if (pAddressingSoap)
{
BSTR bstrAddress;
lResult = pAddressingSoap->getAddressStringByID(m_lAddressID, &bstrAddress);
if (lResult == S_OK)
{
m_strAddress = bstrAddress;
}
else
{
char strString[256] = {0};
sprintf(strString, "%X",lResult);
m_strAddress = strString;
}
delete pAddressingSoap;
}
else
{
m_strAddress = "Unable to create Soap Address Object";
}

It all work good. When I enter an ID, and press the button, I get the address string from the web service.

I created an extended stored procedure project and added the same addressing web refence.
I added tyhe code from above to an exprosed mtheod.
Compiled it and copied it to the sql server (not my computer)
When I run the stored procedure the string that is returned is the error code from the getAddressStringByID function call.
I get 0x80004005 for the lResult. Which is a gereneral error of some sort.

I cannot find out why this is. I tried everything.

The computer running Windows server 2003 with SQL Server 2000 with SP3a.

Does anyone know what is going on?

Thanks
Michael