Thanks for providing the detailed instructions. But are these instructions for SQL 2005 32 bit or 64 bit. Because I tried it on SQL 2005 64 bit and I still get the following errors -
OLE DB provider "SQLNCLI" for linked server returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server .
Another thing is, when i go to set up the linked server in SSMS, i don't even see the Provider "Microsoft OLE DB Provider for ODBC Drivers" in the drop down list. So i was selecting SQL Native Client as the provider. FYI, I have installed the MySQL 64 bit version driver donwloaded from MySQL site. Please advise if these instructions are for SQL 2005 32 bit or 64 bit?