Get Data from SqlServer via HTTP

From: rc <lol_at_lol.com>
Date: Mon, 20 Nov 2006 15:07:00 -0500
Message-ID: <12m42n5ih2rit43@corp.supernews.com>

I need to query an SS2k database - FROM package in 10gR2/Unix - result set mostly is just ***one single record***.
This is not a heavy-traffic OLTP application

I'm thinking of getting around all the "Gateway", "ODBC", "Generic Service", "this/that Client" crap (it's quite confusing) by getting that string of data via HTTP ---

so a few lines of SQL + ASP(or whatever Win guy decides on) on SS2K/Win end and I can read in the string via UTL_HTTP

What do you think...is this feasible ? do you see anything wrong with this approach ?

thanks Received on Mon Nov 20 2006 - 14:07:00 CST