question

balakrishna avatar image
balakrishna asked

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.....
linked server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Dave_Green avatar image
Dave_Green answered
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][1]; 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][2] 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. [1]: http://dev.mysql.com/downloads/connector/odbc/ [2]: http://dbperf.wordpress.com/2010/07/22/link-mysql-to-ms-sql-server2008/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.