Forum Discussion
Reportbuilder mysql connection ODBC
Hi Anonymous ,
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
Hi Anonymous ,
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?
