Prev: Error 5149 Trying to expand transaction log (not enough space)
Next: Calling SSIS package from TSQL
From: Dark on 29 Jan 2009 09:28
I have problem with SOAP toolkit and authorization web service

--************* Utworzenie obiektu CDO.Message ************************

EXEC @hr = sp_OACreate 'MSSOAP.SoapClient30', @iMsg OUT
print @hr

-- testowo na moim serwerze
EXEC @hr = sp_OAMethod @iMsg,'MSSoapInit',NULL,'c:\test.wsdl'
print @hr


EXEC @hr = sp_OASetProperty @iMsg, 'ConnectorProperty("AuthUser")', "test"
print @hr

EXEC sp_oageterrorinfo @iMsg ,@Source OUT , @Description OUT
print @Source
print @Description

EXEC @hr = sp_OASetProperty @iMsg,
'ConnectorProperty("AuthPassword")',"test"
print @hr

EXEC sp_oageterrorinfo @iMsg ,@Source OUT , @Description OUT
print @Source
print @Description


EXEC @hr = sp_OAMethod @iMsg,'getData',@post OUT,'asd'
print @hr
print @post

This generate error

Connection failure.
Connection failure.:No matching authorization scheme enable on connector.
HRESULT=0x80004005: Nieokre�lony b��d.
- Client:An unanticipated error occurred during the processing of this
request. HRESULT=0x80004005: Nieokre�lony b��d.
- Client:Sending the So

authorization is problem ?

EXEC @hr = sp_OASetProperty @iMsg,
'ConnectorProperty("WinHTTPAuthScheme")',1

This not work and I have error

Connector
Connector:The property WinHTTPAuthScheme cannot be read. HRESULT=0x80070005:
Access Denited.

Dark


 | 
Pages: 1
Prev: Error 5149 Trying to expand transaction log (not enough space)
Next: Calling SSIS package from TSQL