MySQL Bugs: #118525: MySQL ODBC 9.3 Unicode Driver not working with Microsoft Visual Studio Professional 2022

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:	9 Jul 10:21
Reporter:	Carlos Martinez Alvarez	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	9.3	OS:	Windows (Windows Server 2022 Datacenter)
Assigned to:		CPU Architecture:	x86
Tags:	MariaDB, MySQL, ODBC, Visual Studio

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.

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.

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.

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.

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!

Hi Carlos,

Thank you for your reply.

This problem has been checked using a MySQL Server. A problem was observed against Connector/ODBC 9.3.0, which has already been fixed in 9.4.0.

Connection with MariaDB server is unsupported and out of scope. 
Closing the report.

You are welcome to reopen this bug if the new version does not fix the issue.

Hello Bogdan, and than you for your answer!

Can I ask when is this 9.4 release going to be available for download and testing?

Thanks in advance,
best regards.

Hi Carlos,

the product release dates are disclosed in the official release announcement.
We cannot give information about 9.4.0 before the announcement is published.