Using mulitple databases in one Report

[hayjude]

Hi all.

I have a situation where I need to link tables form two databases. One is SQL Server and the other may be SQLServer or may be Interbase.

My plan is to create a FileDSN for each database.

Is this possible? Assuming it is, then how would I set the location of the DSNs in my calling application (in this instance Visual Foxpro).

For my reports based on just one DSN I use the .Connect property of the Crystal OCX. How can I do this for two DSNs?

Any help would be great.

Jude

 

[rogar]

Can you create a view in one database of the table(s) in the other daatabase?