Subject Re: Is it possible to implement OPENROWSET (SQL server 7) in IB 7?
Author Clément Doss
Hi C.

> Microsoft has succeeded pushing ODBC outside Windows realm.
However, for me
> at least, there's no clue that MS has been able to push OLE/DB
outside
> Windows. Otherwise, correct me.
> MsSql is able to implement any OLE/DB feature they like,
because they don't
> have to worry about portability: MsSql is a Windows beast and
period.
> However, given that IB once supported up to 18 platforms,
including Cray
> (although some *unnamed* company didn't sell them) and that we
might be in
> the broad platform support avenue again, are you suggesting a
feature that
> would work exclusively on IB for Windows?
> Maybe it's time to start thinking in pluggable modules... or
from being
> able to select from a UDF. Otherwise, the solution is more IFDEFs
in the
> code.

This function is very handy, and I use it every once in a while.
I was thinking about pluggable modules, or extending the UDF
capabilities to be able of such things (SELECT, INSERT, UPDATE,
DELETE).
Ok, I am being selfish here. But all the time I stumble, there's a
Windows nearby.

We could go a *few* steps further and
consider a heterogenious server connection?
Something like:

CREATE SERVER CONNECTION "SQLSERVER7" "SA" "MYPWD" AS MSSQL7
or CREATE SERVER CONNECTION "ORACLE8" "JOHN" "RAMBO" AS ORA8

and

SELECT * FROM MSSQL7.DBO.CUSTOMERS
or SELECT * FROM ORA8.JOHN.CUSTOMERS

Oú lá lá.. Now I did!

Happy New Year,

Clément