Re: One SQR routine connecting to two different databases - ??

["Brown, Bryan" <bbrown2@ACSALASKA.COM>]

Franck,
Thanks for the information (just one of many reasons to upgrade...).

Bryan

-----Original Message-----
From: Franck Masson [mailto:franck.masson@BRIO.COM]
Sent: Thursday, August 03, 2000 10:04 PM
To: SQR-USERS@list.iex.net
Subject: Re: One SQR routine connecting to two different databases - ??


Brown,

if you use a version of SQR <= 5.2  then you have to use SQR with ODBC
as database midleware.

In version 6 of sqr, it is possible .

Franck,

Brown, Bryan wrote:
>
> Hi everyone,
>
> I know that I should do the research...but I thought one question
> "shouldn't" hurt too much :-)
>
> I have been tasked with combing data from an SQL Server database and an
> Oracle database. Either by itself (usually in Oracle) shouldn't be a
> problem...connecting to both within the same routine, I'm not too sure
about
> - any thoughts?
>
> The other option is to build an input file with one routine to be used
with
> the second...
>
> Thanks,
> Bryan
>
> The