Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

what driver to choose for mySQL Expand / Collapse
Author
Message
Posted Tuesday, October 29, 2013 4:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 4:31 AM
Points: 27, Visits: 189
Hi all,

I am new to SQL Server and a bit shaky about the operation I would like to do.
What I want to do is to query, using SQL Server 2012, a database that is created in mySQL. Apparently a linked server is the solution.

I have read a few articles and I believe that I have to start with installing an ODBC driver (SQL Server <--> mySQL).

I searched on the mysql.com site for such an ODBC driver.
This search results in 938 hits.

The question now is: which 1 to take?
Maybe I am looking at the wrong place, if so, what are my options?

Maybe some additional information:
I have a 64 bits machine
I Use SQL Server 2012
I have Windows 7 Home premium

If more info is needed please let me know

Thanks in advance
Hein
Post #1509256
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse