Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connection to two databases
- Thread starter antmoe3
- Start date
synapsevampire
Programmer
Never heard of a pre-created SQL statenment that connects to two databases, please share how this is done from whatever tool you were using to pre-create it.
You can connect to multiple data sources using the Add Command and then link them, but it'll be slow and your limited to fewer join types. You can also just use the Crystal Database Expert GUI.
You might be able to link the Oracle and DB2 servers, or a common means of accomplishing the equivalent is to LINK the disparate data sources into MS Access and create an Access query as the data source for Crystal.
-k
You can connect to multiple data sources using the Add Command and then link them, but it'll be slow and your limited to fewer join types. You can also just use the Crystal Database Expert GUI.
You might be able to link the Oracle and DB2 servers, or a common means of accomplishing the equivalent is to LINK the disparate data sources into MS Access and create an Access query as the data source for Crystal.
-k
- Status
Similar threads
- Locked
- Question