use ADO/html in SQL 2000

[Christopher]

Hi!

I want to write a function or stored procedure such that it will use
ADO2.6 or better so I can use the XMLhttpServer.

When this function is invoked it will execute a URL and gather the
html code and store it in the Db.

So one thought would be how can I write a Stored Proc or function in
SQL to instantiate a DLL and use it? In this case I want to use ADO
dll and use the xmlhttp functions. I pass some parameters to this dll
and it will return data and the SP will store the results in the DB.

Thanks

[Hal Berenson]

On Tue, 12 Aug 2003 19:21:30 -0700, Christopher wrote:

Hi!

I want to write a function or stored procedure such that it will use
ADO2.6 or better so I can use the XMLhttpServer.

When this function is invoked it will execute a URL and gather the
html code and store it in the Db.

So one thought would be how can I write a Stored Proc or function in
SQL to instantiate a DLL and use it? In this case I want to use ADO
dll and use the xmlhttp functions. I pass some parameters to this dll
and it will return data and the SP will store the results in the DB.

Thanks

Take a look at Extended Stored Procedures. But beware, calling external
logic from within SQL Server is a great way to compromise the reliability
of the server and the integrity of your data.

Hal