Re: MSSQL 7.0 overview ...

No, OLEDB provider itself will do it for you, you do not need any middleware. They call it heterogenuos queries. To use it you have to create a Linked Server (cannot use Remote Server for this purpose - it kept for compatibility only and allows you to run stored procedures only, as opposite to direct access to any OLEDB datasource through Linked Server). I.e. you can use any OLEDB datasource in all of your queries directly using usual notation for remote servers (server.db.dbowner.table)

Ng K C Paul wrote in message <72bc71$uuh$1_at_imsp009a.netvigator.com>...
>I think this is not related to the backend databases. This works like
>Access link tables which can be any kind of data sources. There should
>be other middleware that can support multiple data sources query other
>than OLEDB.
>
>ªü¼Ö¥K (owenp_at_NO_geocities_SPAM.com) wrote:
>: hm ... yes, but the point is MSSQL 7.0 can join with two(or more)
 different
>: kind of datasources
>: which is OLEDB or ODBC supported and SQL 7.0 itself.
>: e.g. u can join two tables one from SQL 7.0 and one from ORACLE or even
 an
>: Excel file.
>:
>: Thanks in advice
>:
>: Arnox,
>: 8^)
>:
>:
>: Ng K C Paul wrote:
>:
>: > It looks like Oracle's inline VIEW subquery
>: >
>: > SELECT *
>: > FROM (SELECT ename FROM emp WHERE deptno = 10)
>: > WHERE job = 'CLERK'
>: >
>: > ªü¼Ö¥K (owenp_at_NO_geocities_SPAM.com) wrote:
>: > : Hi,
>: > : after a MSSQL 7.0 overview course, they introduced a very useful
 query
>: > : function.
>: > : it can 'select' from 'OLEDB' or 'ODBC' supported data source within
>: > : query.
>: > : e.g. select a.col1, a.col2, b.col3, b.col4
>: > : from ('OLESQL','dbname','sa','password',
>: > : 'select col1, col2 from oletbl') as a, localtb as b
>: > : where a.col1 = b.col1
>: > :
>: > : (not 100% correct syntax)
>: > :
>: > : it is not a offence, i just want to know does sybase (ASE 11.5 or
 11.9)
>: > : has a simular function ?
>: > :
>: > : Thanks in advice
>: > :
>: > : Arnox,
>: > : 8^)
>: > :
>:
>:
>:
Received on Thu Nov 12 1998 - 00:00:00 CST