Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Call Cfusion web page/webserice from stored proc

Author  Topic 

ramu_anu
Starting Member

3 Posts

Posted - 2008-06-12 : 13:54:52
I am trying to call a CF web page/web service from a SQL 2005 stored proc and getting proxy info cannot be created. I cannot use stored proc 2005 CLR assembly because it will help us in creating only .asmx proxy not CFC proxy , any help would be appreciated.

exec master..xp_cmdshell 'http://wifi.abctest.com/Test/lartnerCall.cfm

Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1
The xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the '##xp_cmdshell_proxy_account##' credential exists and contains valid information.

ramu_anu
Starting Member

3 Posts

Posted - 2008-06-12 : 16:53:48
create a batch job
start \b "iexplore.exe location" url
exec master..xp_cmdshell 'bat file'

ramu
Go to Top of Page
   

- Advertisement -