There is a complete step-by-step guide here:

http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

Be sure to follow the steps exactly, especially the part concerning the MSDASQL provider properties 😉