May 22, 2009 at 1:25 pm
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
May 22, 2009 at 2:17 pm
Have you verified that the ORACLE oledb provider is installed on the SQL Server? Have you checked for a 64 bit driver?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 22, 2009 at 2:22 pm
Can yo create a linked a server from the SQL Server to ORACLE using that driver?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 22, 2009 at 2:29 pm
Yes, I did check for the OLEDB provider and I can create a linked server using the Oracle 64 bit client. Yet, the issue remians unresolved. Is there anything else that needs to be checked ?
Thank you
May 22, 2009 at 2:40 pm
Have you verified that the Data Source was deployed? If it was deployed, was the User Name and Password saved?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 22, 2009 at 2:50 pm
Yes , I did check the username and password on the datasource after they were deployed. They are saved and they are correct. Yet, this issue still continues. Any thoughts ? Thank you,
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply