I'm using Crystal7 with VB6.  I have a report that has connections to Oracle
and SQLServer7.

In the VB code I want the login prompt to these systems to be invisiable to
the user when they run their report.  How do I tell Crystal to login to each
of these 2 systems without user intervention.  Login into a single db is
fine but when I introduct 2, I get a login failure.  Here is the vb code:

Tx1 = "driver={Microsoft ODBC for Oracle};uid=WEB1;pwd=PAS2;server=PTSDEVX;"
'Tx2 = "dsn=INT1;uid=Auc;pwd=1234;DSQ=NET_DB"

CRW.Connect = Tx1&T2

CRW.ReportFileName = ReportPath & ReportPrefix & Trim$(REPNAME) & ".RPT"
CRW.ReportTitle = "For The" & ACD & " Auction"
'
CRW.WindowControlBox = True
CRW.Action = 1

How do I combine both of the TX strings?  Any help would be appreciated.
Thanks.