|
Home > Archive > MS SQL XML > November 2006 > sql server agent xmlhttp
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql server agent xmlhttp
|
|
|
| Does anyone know if it is possible to create an xmlhttp object in sql server
agent?
Set GetConnection = CreateObject("Microsoft.XMLHTTP")
It seems to hang all the time when you try this, no matter what version of
the object or permission is used.
| |
|
| OK, i solved this myself, basically use sp_OACreate inside tsql agent
instead of a vbscript agent.
master.dbo.sp_OACreate 'MSXML2.ServerXMLHTTP', @xml OUTPUT
"b" wrote:
> Does anyone know if it is possible to create an xmlhttp object in sql server
> agent?
>
> Set GetConnection = CreateObject("Microsoft.XMLHTTP")
>
> It seems to hang all the time when you try this, no matter what version of
> the object or permission is used.
|
|
|
|
|