Setup Linked Server in MSSQL Server with ODBC MySQL driver
currently I'm trying to setup a linked server connection in Microsoft SQL Server 2019 to access a MySQL Database via the ODBC driver.
When I try to add the linked server via dialog and press <okay> the whole SSMS application *freezes*.
It's actually possible to create the server per t-sql. But if sp_testlinkedserver is started, the query tab *freezes* as well. The query doesn't timeout. The only solution is to kill the SSMS application with the Task Explorer.
Any idea whats going wrong or what I might do wrong?
ODBC (x64) Connection setup
SQL Server Linked Server setup:
Microsoft SQL Server 2019 (RTM-GDR) (KB5014356) - 15.0.2095.3 (X64) Apr 29 2022 18:00:13 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 22000: ) (Hypervisor)
Devart ODBC Driver for MySQL 4.3.0