mySQL linked server access error

Ashru 41 Reputation points
2021-10-20T10:15:59.823+00:00

Hi,

I get the below error when test linked server. Can someone help me on this?

Created a DSN and referred it in the Linked Server.

Error:

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MySQLSrv".
OLE DB provider "MSDASQL" for linked server "MySQLSrv" returned message "[MySQL][ODBC 8.0(a) Driver]SSL connection error: SSL_CTX_set_default_verify_paths failed". (Microsoft SQL Server, Error: 7303)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,607 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. YufeiShao-msft 7,051 Reputation points
    2021-10-21T06:35:40.64+00:00

    Hi @Ashru ,

    1. If you use the 32-bit driver on a 64-bit machine, please run the 32bit version of "odbcad32.exe" by running "c:\Windows\SysWOW64\odbcad32.exe" from Start/Run menu and create your ODBC DSN. However, for the 64-bit driver, use c:\windows\system32\odbcad32.exe to create your ODBC DSN. For more details, please review this similar thread:https://www.reddit.com/r/SQLServer/comments/14t7on/creating_linked_server_to_mysql_what_am_i_missing/
    2. Expand the folder Providers under Linked server directory in SSMS and go to properties of MSDASQL provider and configure it properly as described in this blog: Creating Linked server to MYSQL from SQL Server.

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.