ODBC Connection - Server has several DBs only seeing one in CR

[samurrai]

Hello,

I have been working with CR XI pulling data from a SQL server database (SQL Server 2005). I actually have 2 databases on the same server that I need to access for one report. I've read that only one connection is necessary for this, but I am only seeing one database when I open the Database expert. How can I access 2 databases via CR with one ODBC connection? (Or is this not possible?)

Thank you!

 

[Turkbear]

Hi,
I believe that ODBC limits you to one database per connection - try the native SqlServer driver or maybe the ADO one..Not sure if that will make any difference, however, so you may need to use a subreport for the second database ( or create a link between the databases in one or the other)



To Paraphrase:"The Help you get is proportional to the Help you give.."