• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

connecting mysql to mssql 2012

trying to connect from SSMS for MS SQL 2012 to MySQL 5.521
in order to run a stored procedure to pull data from MySQL and process it in SQL 2012

i believe i need a linked server.
to get a linked server i believe i need an ODBC connection.

i am running windows 7 professional 64 bit

when creating the linked server, not sure what to put into the provider string or location...   catalog i am assuming is the database i want to connect tol
0
CASorter
Asked:
CASorter
  • 3
  • 3
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, you need to set a linked server using ODBC but don't forget that you need to install the MySQL client in the SQL Server machine so it can has the necessary driver.
Here's a step by step on how to do it.
0
 
CASorterAuthor Commented:
when trying to connect the ODBC i get

Connection using old (pre-4.1.1) authentication protocol refudsed (client option 'secure_auth' enabled).

i am using mySQL connector/ODBC v 5.3
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Which version of MySQL are you connecting to? The driver and the MySQL server should has the same versions.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
CASorterAuthor Commented:
5.3 is the highest version of the odbc driver i could find.

initial queston has version of mysql in it..   5.521
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, MySQL 5.3.4 connector for ODBC.
Looks to me that the error that you are getting now it's a bug. Check this thread in MySQL blog.
0
 
CASorterAuthor Commented:
very cumbersome...

not the answer..
the ability to connect.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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