[DB-SIG] SQL bridging

[Luke Kenneth Casson Leighton]

On Wed, Feb 05, 2003 at 12:39:13AM -0600, Ian Bicking wrote:

> >  ian, what are you proposing that pyro be used for?
> > 
> >  as a gateway to run a local python ODBC client on the MS-SQL server
> >  that then passes the results over, with pyro doing all the
> >  communication and stuff?
> 
> Yes, you'd have a small program on the MS-SQL server that would create a
> connection.  That connection would be exported as a remote object, and
> that would be it.  There wouldn't be any layer between the client and
> the database connection (except the remote object system, but that would
> hopefully seem fairly transparent).

for the instance where i didn't have control over the MS-SQL
server and for political reasons there was a cat in hell's
chance of asking them to install a program, i had to plump for
the alternative method - match what they specified, and leave
it at that.

i was lucky enough to be able to ask them to switch on the
XML interface.

ODBC bridges _were_ available at the time, you see (commercially?)

if speed ever became an issue (it didn't) at production time
(which didn't happen) then yes, the bridging technique would
have been invaluable.

if i remember correctly, there were some such bridging projects
already under development or listed on parnassus at the time...
(18 months ago).

l.