How to add tables from different databases on same Server

[rahulroy08]

Hi,

I'm using CR version 8.5. I'm trying to pull two different tables using SQL Server 2005.I need two tables to generate my report, and those two are on different databases of the same server. Please help me how to add two tables on different databases to the report.


your help is appreciated.


Rahul.

 

[awise]

Rahul,
I have the same question. Has anyone responded to your post on how to create a report that utilizes (2) datbases running on the same server? Specifically, (2) identical
SQL views, each residing in a different database.

Then "union", if that's the correct concept, the two views in different databases.

If you have any knowledge on this request, I would greatly apreciate your input and assistance.

Thank you,

zaw

 

[Turkbear]

Hi,
Have you tried making 2 connections for your report ( 1 for each database) and selecting the views from each?




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

 

[rahulroy08]

Yes. I tried making two different ODBC connections and the CR it self links the tables. But when I use the fields in the report and try to associate them, then it gives me an ODBC DLL error.

But its fine as long as I use the fields from the same table. But if I drop two fields from differnt tables, it gives me the above mentioned error.

Does someone have any idea about it how it works ?


Thanks,


Rahul

 

[Turkbear]

Hi,
First, I never let CR itself link the tables..It is notoriously bad at that..Set the links yourself..

Is ODBC your only SqlServer conenction option? If not, use the OleDB method and choose the Sql Native Client provider..

What ODBC DLL error are you getting?




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

 

[rahulroy08]

yes, the only way I can connect is ODBC to my SQL Server, and the error is "ODBC error: Error detected by the Database DLL"....

Also I have never tried the OLEDB connection. Please help me with the error message.


Rahul

 

[Turkbear]

Hi,
Usually that message means that the database ( one or the other) cannot interpret the query being sent to it..Try using the 'Show Sql' option under the Database menu to see what is actually going to the database.

For the OleDb connection, see if under the Datasources list you have the OLE DB(ADO) option in Create New Datasource..If so, there should (may) be the sqlServer native connection.





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