SSRS (SQL Server Reporting Services) and K1000 - unable to query the DB
Can I use SQL Server Reporting Services to access the K1000 Database and create reports? I have enabled database access and have installed the MySQL database connector. I can't seem to establish a connection to the DB. I get an ERROR IM002 error on SSRS.
I am able to access the database using MySQL Workbench without any issues. Also other reporting tools are able to access the database. I'm just having issues with SSRS. Any tips or suggestions to get it working with SSRS would be appreciated.