I have a problem with adding MySQL server via linked server to my SQL Server Database

Following this instruction unfortunately just does not work out for me.

I added four data sources, 2 using 64-bit mySQL ODBC drivers and 2 using 32-bit drivers:


Test connection brings me success

from each one source.

Linked server configuration:

Configuration screen 1

Configuration screen 2

But I am still getting

this error.

Software used:

  • Windows Server 2012 R2 64bit
  • MySql Connector/ODBC 8.0 32bit/64bit
  • Microsoft ODBC Driver 17 for SQL Server
  • Microsoft SQL Server Managment Studio 2018

What am I doing wrong?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.