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
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
Any ideas on how to remedy this issue?