• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2483
  • Last Modified:

Need help setting up MySQL data source in SSRS 2008

We are trying to setup a new data source on our SSRS Report Portal.  The data source will connect to a MySQL Database.

We've already installed the MySQL Connector 64-bit ODBC 5.1 driver on the report server.  We successfully created the DSN in the Data Source Administrator and successfully tested the connection.

We created the data source on the report server using ODBC as our data source type.  The connection string we used was as follows:

DSN=MySQL_DB; server=<server IP>; port=3306; database=ticket

Open in new window


We verified the correct credentials to connect to the server.  When we attempt to test the connection, we get the following error:

ERROR[IM002][ODBC Driver Manager] Data source name not found and no default driver specified

Open in new window


Any ideas on how to remedy this issue?
0
mjs4677
Asked:
mjs4677
1 Solution
 
Guru JiCommented:
I assume your report is working fine on BIDS, I was just working with this and what I did I had MySQL 5.1 driver as well as 3.51 Driver installed. I did deployed the data source on the reporting server and then configured it again right on the reporting server.

Please see screen shot attached with my settings as its working fine with this. Before I was supplying database credentials which was not working. Please see my screenshot and I really hope it will help you.
ssrs.png
0
 
mjs4677Author Commented:
I set my data source up according the details provided in the screenshot and it worked!  Thank you!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now