| Bug #118525 | MySQL ODBC 9.3 Unicode Driver not working with Microsoft Visual Studio Professional 2022 - Version 17.11.5 | ||
|---|---|---|---|
| Submitted: | 25 Jun 11:05 | Modified: | 3 Jul 13:04 |
| Reporter: | Carlos Martinez Alvarez | Email Updates: | |
| Status: | Analyzing | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S2 (Serious) |
| Version: | 9.3 | OS: | Windows (Windows Server 2022 Datacenter) |
| Assigned to: | MySQL Verification Team | CPU Architecture: | x86 |
| Tags: | MariaDB, MySQL, ODBC, Visual Studio | ||
[25 Jun 11:05]
Carlos Martinez Alvarez
[26 Jun 9:05]
Carlos Martinez Alvarez
Description: While trying to connect to MariaDB using ODBC Connector in version 9.3, an error is received in Visual Studio. - SSL is being used in connection. - Connection works and tests successfully in ODBC Manager 64bits. - Connection can be found in available list inside Connection Manager in Visual Studio. - Error while testing connection: Test connection failed because of an error in initializing provider. Trying to focus on either Visual Studio or the Driver as the source of the error, a third-party ODBC connector for MySQL has been tested successfully. This leads to think that the source of error might be integration between driver and Visual Studio. How to repeat: 1. Create a ssl user for MariaDB. 2. Create a connection from ODBC Manager. Certs are generated with OpenSSL. 3. Test connection from within Visual Studio.
[27 Jun 2:16]
Bogdan Degtyariov
Hi Carlos, Thank you for the detailed report. When you mention a "Connection Manager" in Visual Studio, which component are you using? Is that SQL Server Integration Services (SSIS)? Normally SSIS has to be installed separately. The only "Connection Manager" found in Visual Studio by default is a Connection Manager for remote SSH connections. It is not for ODBC or another type of database connections. Please clarify. Thanks.
[1 Jul 15:19]
Carlos Martinez Alvarez
Hello Bogdan, Yes, we're using SSIS, which is installed and working in Visual Studio. Is from SSIS where we need to create an SSL connection to MariaDB. We haven't been able to do so using MySQL Connectors, but as I mentioned, we were able to do it using a third party driver, which lead us to believe we are facing a bug. Could we connect over teams so that I can share my screen and explain in more detail all our tests? Looking forward to hearing from you.
[3 Jul 13:04]
Carlos Martinez Alvarez
Hello Bogdan, I was wondering if you had a chance to see my answer, and if we could set up a short meeting to discuss this error? Looking forward to hearing from you. Thanks & regards!
