Report Builder/Model With Oracle

Hi,

My environment:
Computer A
- SQL 2005 SP2 (32 bits)
- Oracle 9i client
I am the local administrator

Server A
- Oracle 9i Enterprise Edition (64 bit)
I have read only access to Oracle DB.


I am able to create a report model with Oracle DB and deployed it successfully. In my report model (rmOracle), I named my data source: dsOracle and dsvOracle for my data source view which contains one named query. Then I set a logical primary key for the named query, everything is OK so far.

Now, in Report Builder (RB) I have created a simple report (table) based on the report model I created before. Then when I preview it, I got the following error message:

Microsoft Report Builder:

Report execution error
The report might not be valid or the server could not process the data.

Details:
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
----------------------------
Cannot create a connection to data source 'dataSource1'.
----------------------------
An error has occurred during report processing.

I tried to look more information by saving the report and run it from the report server directly. And I got the following error message:

An error has occurred during report processing.
Cannot create a connection to data source 'dataSource1'.
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

I open the RDL file and found that when creating a report with RB, it creates its own data source, which is fine. The problem here is that data source points to the wrong connection, which I thought it should point to the same connection of the report model its based on. In this case it should point to Oracle connection (dsOracle).

Anyone has any idea how to solve it? Or did I miss something here?


Thanks and Regards,
Uzzi