I have to configure linked server sql server 2000 to mysql,
OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified] Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' reported an error. When i am trying to test connection at systemDSN in administrative tools, it results connection failed to Mysql. Please any body help me to solve this problem. Thanks in advance.....
Hello, From the error message, it looks like you have an issue with the driver not being specified. I'm guessing you may not have properly installed [the driver]; as you are getting a failure from Windows it looks like your DSN isn't set up correctly. Two minutes with a search engine turned up [this tutorial to linking MSSQL server 2008 to MySQL] which I would suggest following in the first instance. I've linked SQL server to MySQL using a DSN to do it in the past, but this was sufficiently long ago that I wouldn't pretend to offer good troubleshooting for your specific error at this time. I hope this sets you on the right path to resolve your issue, but please do post back if it's something else that solves your problem, so that others can benefit. :