Go Premium for a chance to win a PS4. Enter to Win

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

OPENROWSET to connect from SQL Server 2005 to MySQL

I am trying to use OPENROWSET to connect from SQL Server 2005 to MySQL.  Has anyone been able to do that before?
0
NurveTech
Asked:
NurveTech
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, I have done that.
you need:
? to install the mysql odbc driver on the ms sql server machine
? create a linked server using that (i used a odbc administrator dsn entry to simplify the linked server config.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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