Re: Heterogeneous joins ?
From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 01/18/04
- Next message: Terence: "How can I display it in my WinForm application in Delphi 8?"
- Previous message: Viatcheslav V. Vassiliev: "Re: Problem with Jet 4 and Access Database"
- In reply to: M.Sameer: "Heterogeneous joins ?"
- Next in thread: Mike Collier: "Re: Heterogeneous joins ?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sun, 18 Jan 2004 16:44:47 +0300
You should use DBMS specific features. For example, linked server in MS SQL
Server. Look sp_addlinkedserver in BOL for more info.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"M.Sameer" <msameer1@hotmail.com> сообщил/сообщила в новостях следующее:
news:400a6f39@newsgroups.borland.com...
> Hi All,
> How can I make a heterogeneous join between two databases on different
> DBMSs (SQL Server and Oracle for example) using ADO?
> Thanks in advance,
> M.Sameer
>
>
- Next message: Terence: "How can I display it in my WinForm application in Delphi 8?"
- Previous message: Viatcheslav V. Vassiliev: "Re: Problem with Jet 4 and Access Database"
- In reply to: M.Sameer: "Heterogeneous joins ?"
- Next in thread: Mike Collier: "Re: Heterogeneous joins ?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
