Jump to content

Linkedserver connection to MySQL database with ODBC driver connection issue

Guest binrip1

By Guest binrip1
in Microsoft Products Support & Discussions

 Share

Recommended Posts

Guest binrip1

Guest binrip1

Posted
Posted

I have setup SQL Server 2014 linked server to connect to MySQL 8 instance and when I run a single openquery insert statement like below it works fine. However, when I run multiple insert statement to insert data to multiple tables like below openquery insert statement it fails with this generic error majority of the time. If I run this statement at off-peak time sometimes it works without any error. Errror;OLE DB provider "MSDASQL" for linked server "LinkedServer" returned message "[MySQL][ODBC 8(w) Driver]Can't connect to MySQL server on 'ip:port' (10060)".Openquery Insert Statement Used:INSE

 

Continue reading...

  • Replies 0
  • Created
  • Last Reply

Popular Days

Popular Days

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...