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
Linked server configuration:
But I am still getting
- 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?