Perhaps you could query the Oracle DB, insert or update the results to
a temporary SQL7 table and then query it back out.
Not a pretty work around and it carries overhead but it could work.
Yours In Conservation,
Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262
www.OFAH.org
P.S.
Want to get a bargain on great outdoors items and support
conservation? www.AuctionForWildlife.com
> -----Original Message-----
> From: Eli Shechter [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 13, 2000 12:26 PM
> To: CF-Talk
> Subject: query between 2 database types
>
>
> Hi
>
> I recently started using a program that runs off a oracle database,
and my
> website runs off SQL server 7.0
>
> how can I run a query so that within one query I can pull data from
both
> databases?
>
>
> Thank You
>
> Eli Shechter
>
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
