Subject | Re: Is it possible to implement OPENROWSET (SQL server 7) in IB 7? |
---|---|
Author | Clément Doss |
Post date | 2000-12-30T11:10:57Z |
Hi C.
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
> 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/DBoutside
> Windows. Otherwise, correct me.because they don't
> MsSql is able to implement any OLE/DB feature they like,
> have to worry about portability: MsSql is a Windows beast andperiod.
> However, given that IB once supported up to 18 platforms,including Cray
> (although some *unnamed* company didn't sell them) and that wemight be in
> the broad platform support avenue again, are you suggesting afeature that
> would work exclusively on IB for Windows?from being
> Maybe it's time to start thinking in pluggable modules... or
> able to select from a UDF. Otherwise, the solution is more IFDEFsin 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