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.

Thanks!

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
I just set up a SSRS connection to Kace in my environment. (SQL Server 2008R2 SP1 and using ReportBuilder3 and the mySQL 3.51 drivers). There might be a way around this problem, but I have always had to add both the 64 bit and the 32 bit driver; reportbuilder3 likes 32bit for report setup, but 64bit for report execution. I created 2 identically named DSN's:
  • 64 bit in %windir%\system32\odbcad32.exe
  • 32 bit in %windir%\sysWOW64\odbcad32.exe (how's that for counter intuitive)


Then I created a datasource in SSRS, only mentioning the DSN in the connection string


Within 10 minutes, I was off to the races


**Please NOTE**
There is no visible difference between the 32 & 64 bit ODBC applications; Just make sure that you have a DSN in both locations. If you developing on your local machine and saving to the report server, you will need to install drivers and create DSN's on both the server (for subscribed reports) and on your development machine(s).

Answered 05/18/2015 by: thewruck
White Belt

Please log in to comment
1

ERROR IM002 means "Data source name not found and no default driver specified" so you likely just need to go into your ODBC settings and create an entry under System DSN that connects to your KBOX.

Answered 05/06/2014 by: BHC-Austin
Fourth Degree Black Belt

Please log in to comment
This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

Answer this question or Comment on this question for clarity