Bug #106172 ODBC Connection through Crystal Report

• Submitted: 14 Jan 2022 17:50
• Modified: 8 Feb 2022 14:04
• Reporter: Francesco Tagliento
• Status: Closed
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: 8.0.27
• OS: Windows
• CPU Architecture: x86

[14 Jan 2022 17:50] Francesco Tagliento

Description:
Hello,
Configuration used
- Windows OS (x64)
- MySQL Server 8.0.26 (x&4)
- ODBC Connector 8.0.27 (x86)
- Crystal Report 13.0.22
- Visual Studio 2017

Creating new report adding Stored Procedure I receive an error. I see all Tables, Views and Stored Procedure and selecting one stored procedure I receive prompt to set paramaters but after I receive following error:
"HY000:[MYSQL][ODBC 8.0(w) Driver][mysqld-8.0.26]Support for schemas is disabled by NO_SCHEMA option, but non-empty schema is specified."

What does it means?

Thanks
Regards
Francesco

How to repeat:
As described above, the error occurs everytime I try to add a Stored Procedure in a report.
Before, with MySQL 5.x and ODBC 5.x everithing was fine.

[14 Jan 2022 17:52] Francesco Tagliento

error message

Attachment: error2_cr-mysql.png (image/png, text), 9.15 KiB.

[8 Feb 2022 13:28] MySQL Verification Team

Hello Francesco Tagliento,

Thank you for the bug report.
Did you enable NO_SCHEMA option? If yes, could you please clear the option and try again?

Regards,
Ashwini Patil

[8 Feb 2022 13:38] Francesco Tagliento

Hello,

yes sorry I solved day after and forgot to update ticket: I confirm, solved clearing NO_SCHEMA option.

Thanks for Support
Best Regards

[8 Feb 2022 14:04] MySQL Verification Team

Thank you , signor Tagliento for your feedback.