[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 454
  • Last Modified:

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
0
rutledgj
Asked:
rutledgj
1 Solution
 
Nico BontenbalCommented:
You could use this technique:
http://www.packtpub.com/article/mysql-linked-server-on-sql-server-2008

Or you could use sp_OACreate with adodb that is somewhat described here:
http://support.microsoft.com/kb/295046

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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now