Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
squevedo
New Member

Reportbuilder mysql connection ODBC

Hi,

I have a problem with the connection from report builder to a mysql base with the ODBC option. I have created the dns and has no problems, but when I try to use this connection in my report appear an error IM002

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

Hi @squevedo ,
Based on the error code IM002 you've encountered, it appears there's an issue with the Data Source Name (DSN) not being found or the default driver not being specified correctly.
Ensure that the DSN you've created is correctly configured. You mentioned creating the DSN without problems, but it's worth double-checking both the User DSN and System DSN tabs in the ODBC Data Source Administrator tool to ensure your MySQL DSN is listed there.
Confirm that you're using the correct version of the ODBC Data Source Administrator tool (32-bit vs. 64-bit) that matches the version of Report Builder you are using. If you're unsure, you might want to configure the DSN in both versions of the tool.
The error might also occur if the ODBC driver for MySQL is not installed on your system or if an outdated version is being used. Ensure that you have the latest MySQL ODBC driver installed.

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

5 REPLIES 5
v-heq-msft
Community Support
Community Support

Hi @squevedo ,
Based on the error code IM002 you've encountered, it appears there's an issue with the Data Source Name (DSN) not being found or the default driver not being specified correctly.
Ensure that the DSN you've created is correctly configured. You mentioned creating the DSN without problems, but it's worth double-checking both the User DSN and System DSN tabs in the ODBC Data Source Administrator tool to ensure your MySQL DSN is listed there.
Confirm that you're using the correct version of the ODBC Data Source Administrator tool (32-bit vs. 64-bit) that matches the version of Report Builder you are using. If you're unsure, you might want to configure the DSN in both versions of the tool.
The error might also occur if the ODBC driver for MySQL is not installed on your system or if an outdated version is being used. Ensure that you have the latest MySQL ODBC driver installed.

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Thanks, my DNS has a similiar architecture to this exmple: Dns=dns_created;database=example;db=example_base;no_schema=1;password=****;port=9999;server=example;user=example_user

 

The version of the ODBC and the Report Builder is 32 bit

Should be dsn, not dns.

Please be more specific on the version. Recommendation is to use 8.0.28

Why port 9999 rather than the default port?

lbendlin
Super User
Super User

which MySQL driver version are you using?

I´m using the MySQL ODBC 8.0 ANSI Driver

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.