How to get data from mysql db inside a MS SQL Sever stored proc

Can someone show me how to, from inside a sql server stored proc, to select data from tables in a mysql database?  I've heard this can be done but can't find any examples of
Who is Participating?
Nico BontenbalConnect With a Mentor Commented:
You could use this technique:

Or you could use sp_OACreate with adodb that is somewhat described here:

(I'd go for the first one, this let you work with the MySQL as if it was an SQL server database.)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.