two odbc connect question!

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

Article #5518

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

#5518

From: zhjin
Date: Thu, 05 Apr 2001 09:30

14 lines
1137 bytes

hi
  i hava a question. i'm use c++build and want to build a query.
i have two ODBC source A and B.
now i want to build a query from table from two ODBC, if now i'm using ODBC
A,
how can i retrieve data from ODBC B in a select query?

i can't use: select * from a(in ODBC A) where id in (select id from b (ODBC
B))
help me please!

  thanks

  zhjin

Technical Details

Message-ID: <3acc3f8b_1@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!news.maxwell.syr.edu!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,81929595e13caa7d,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-04-05 03:00:06 PST
From: "zhjin" <zhjin@21ilink.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: two odbc connect question!
Date: Thu, 5 Apr 2001 17:30:35 +0800
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 202.110.53.68
Message-ID: <3acc3f8b_1@dnews>
X-Trace: dnews 986464139 202.110.53.68 (5 Apr 2001 02:48:59 -0700)
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!news.maxwell.syr.edu!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews