• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2517
  • 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?
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.
mjs4677Author Commented:
I set my data source up according the details provided in the screenshot and it worked!  Thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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