MYSQL database query from MSSQL Windows10

Question

I have a MYSQL database that I would like to link to my MSSQL database.

This system used to work for me using the provider of the MSDASQL communication server and creating an ODBC data source using the latest odbc MYSQL driver.

Since my version of Windows 10 Upgrade has stopped working. Fortunately, it still runs on a Windows 2008 server.

ODBC Datasource connection testing also still works. When testing the connection in the sql management studio, it does not work with the Exception "Failed to initialize the MSDASQL provider, there was no specific information."

Datasource ODBC runs on Microsoft Access 2010.

As I understand it, the MSDASQL provider is now out of date? Which other provider should I use?

Answer 1

I also had this problem. I managed to get it to work with an instance of SQL 2014. Thus, it seems that the associated server provider MSDASQL in 2012 and earlier is not compatible with Windows 10 ODBC.

Can you try it on an instance of SQL 2014? Let me know how this happens!