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

[Franck Masson <franck.masson@BRIO.COM>]

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
begin:          vcard
fn:             Franck Masson
n:              ;Franck Masson
org:            Brio Technology EMEA
adr;dom:        Le capitol;;55 av. des champs Pierreux;Nanterre;92000;;
email;internet: franck.masson@brio.com
title:          Sales Manager Northern Europe
tel;work:       33 1 55 69 36 00
tel;fax:        33 1 47 25 02 59
tel;home:       Mobile : 33 6 84 80 17 05
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard