Joining tables from different databases

Article View: borland.public.cppbuilder.database.ado

Article #1027

Back to borland.public.cppbuilder.database.ado Previous Next

#1027

From: Patrick Wong
Date: Wed, 15 Dec 2004 02:30

19 lines
1557 bytes

Dear all,

I don't know whether this is the right place to post this message, since the
problem is not specific to ADO.

This is an existing application that requires data from two different
databases, Informix and MSSQL Server.  Informix provides a view for MSSQL
server to fetch required dataset.  MSSQL constructs its own records

A new requirement is that based on the records in one of the MSSQL table, I
need to get extra data from Informix's view, which having matched fields in
two.  Since VCL data access components (TQuery, TADOQuery, etc.) have one
database name only, how can I specify to join two tables in these separated
databases?

Thanks for any kind advice.

Best regards,
Patrick

Technical Details

Message-ID: <41bfa1cc$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newsread.com!newsprint.newsread.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,a37be4c1a4c96948,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Patrick Wong" <patrickwong@computer.org>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Joining tables from different databases
Date: Wed, 15 Dec 2004 10:30:36 +0800
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 203.82.252.252
Message-ID: <41bfa1cc$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1103077836 203.82.252.252 (14 Dec 2004 18:30:36 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newsread.com!newsprint.newsread.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail