Reportbuilder mysql connection ODBC

[squevedo]

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

[v-heq-msft · Accepted solution]

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

[squevedo]

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

[lbendlin]

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]

which MySQL driver version are you using?

[squevedo]

I´m using the MySQL ODBC 8.0 ANSI Driver