May 14, 2013 at 3:47 am
Hi
I have created a DSN (using sybse db) and develop report in SSRS 2008R2. Reports working fine in BIDS. Now I have uploaded RDL in Report Manager. Create a ODBC DataSource in Report Manager.
I am getting below error message
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'dsTransaction'. (rsErrorOpeningConnection)
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Attached screnshot for reference.
Please guide to to create a DSN DataSource in SSRS Manager.
Do I have any permission issues in report server?
--
Thanks & Regards
Jayanta Sarkar
May 14, 2013 at 12:52 pm
Have you created the DSN on the report server?
Does the report server have the Sybase ODBC 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 15, 2013 at 12:38 pm
Hi
Thanks for your response.
Yes I have created DSN in Server. Now my problem is solved. It was due to access limitation
Thanks & Regards
Jayanta
June 10, 2013 at 5:30 pm
Deploy the Report as well as the data source from SSDT to report server.
2nd edition of my book on SSRS2012 to be released on June 20, 2013
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply