Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2009-05-22 : 15:23:23
|
| Here is the question. I’ve created Sql server 2005 reports in BIDS where the database is Oracle 10g. I have created the datasource using OLEDB , Provider=MSDAORA.1;Data Source=XXX;Persist Security Info=True;User ID=XXXXX under shared datasource. I can preview the reports and deploy them without any issues.But, the problem is when I execute the report in the Report Manager I keep getting the following error as shown below and in the attachment.An error has occurred during report processing. Cannot create a connection to data source 'SM_OrderDataSet'. For more information about this error navigate to the report server on the local server machine, or enable remote errors The reports are developed on 32 bit machine on Windows 2000. I’ve Oracle client installed on my desktop and on the Server. The server is 64 bit, Windows 2003, Sql Server 2005 Server, Reporting services are all installed, configured correctly. IIS also has been configured correctly. I have all the permissions on report manager. I’ve tried all the possible solutions to resolve the issue. Can you throw in some light to resolve ?Thank you |
|
|
sachya45
Starting Member
25 Posts |
Posted - 2009-05-22 : 15:35:53
|
| check if default user of report manager has all the permissions to execute that datasource. you have to grant execute permission to default user in report manager. i hope this may help |
 |
|
|
swenri
Yak Posting Veteran
72 Posts |
Posted - 2009-05-22 : 16:25:47
|
| I have all the required permissions for the datasources yet it fails. Do you think it's because of the report created in 32 bit and the server is 64 bit. Any thoughts are appreciated. Thank you |
|
|
|
|
|
|
Urgent help with reports!!