question

Ashru-8852 avatar image
0 Votes"
Ashru-8852 asked Yufeishao-msft commented

mySQL linked server access error

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-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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!)

0 Votes 0 ·

Thank you

0 Votes 0 ·

1 Answer

Yufeishao-msft avatar image
0 Votes"
Yufeishao-msft answered Yufeishao-msft commented

Hi @Ashru-8852,

  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.






· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.

0 Votes 0 ·