Linked servers - SQL2008 to MySql - error: 7303 - Data source

Question

Problem:

I use SQL Server 2008.

We have here a linked server, linking to a MySql Database.

But since today, when I click "test connection", it shows me this error:

( I can't post images yet):

The test connection to the linked server failed.


Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MANTIS".

OLE DB provider "MSDASQL" for linked server "MANTIS" returned message "[Microsoft][ODBC Driver  
Manager] Data source name not found and no default driver specified". (Microsoft SQL Server,  
Error: 7303)

What should I do?

It was working yesterday. I thought about "data sources ( ODBC)". Yes, There is no DataSources for MySql ( it doesn't even show me the option to add a mySql odbc when I click ADD), but it was working yesterday !!

I didn't find a reasonable solution from any post.

If it is solved why did you post ??? What you want to know ??? — royki
– royki, Commented Nov 28, 2014 at 15:42
What? it's not solved. it was working "yesterday". not today. — Racer SQL
– Racer SQL, Commented Nov 28, 2014 at 15:44
did you try all the solutions available in Stackoverflow. Nothing is working? — royki
– royki, Commented Nov 28, 2014 at 15:54

bummi · Accepted Answer · 2014-12-21 00:14:57Z

2

answer, taken from the question
Restart server + Install MYSQL ODBC DRIVER 51 ( MySql connector )

Start - control panel > Administrative Tools > Data Sources (ODBC) > System DSN > ADD MySql ODBC 501 Driver

Collectives™ on Stack Overflow

Linked servers - SQL2008 to MySql - error: 7303 - Data source

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related