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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CR12 - connect to multi-DB in the same SQL instance
Well, I see nobody’s going to put up any thoughts here. NICE I finally resolved this last week, and thought I'd stop by and put up what I found out. Seems CR can pull data from multiple locations, just not in my case. Because I have multiple DB's within the same instance that ALL have an...- Vamps
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
CR12 - connect to multi-DB in the same SQL instance
One more piece of info. My ODBC lists the partial list of tables under "dbo". They also ALL have a prefix added to them 'zDP_'. There is not another level under dbo called "tables" like when I create an OLE DB connection, where it lists the three of five options that I have it set to show...- Vamps
- Post #2
- Forum: Business Objects: Crystal Reports 4 Other topics
-
CR12 - connect to multi-DB in the same SQL instance
Hello: My first post. :-) I'm new to CR, and marginal at best with DB's. I'm attempting to pull data from multiple (~20 or so) different DB's within the same instance of SQL. We have a second instance with historical data, but for now, I don't need to pull anything from the second...- Vamps
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 4 Other topics
