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)
The error comes from the MySQL ODBC driver, and appears to be a login error. You might have better chances to get help with this in a MySQL forum. (It may help when asking in a MySQL forum, to be quiet on the SQL Server part, so that you are not pointed back here!)
Hi @Ashru-8852,
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/
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.
If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.
15 people are following this question.
