question

Am trying to create a connection between mysqlserver(version 5.2 community server) and MYSQL SERVER 2008R2.I install odbc drivers 5.2 for mysql and created the odbc connection called:MYSQL and productionName MYSQL. The provider string: DRIVER={MySQL ODBC 5.2 Driver};SERVER=localhost;PORT=3306;DATABASE=mydbname; USER=defaut;PASSWORD=mypassword;OPTION=3; I provider the default login credential i using in mysql workbench in the remote longin credential under the security tab. but i still get this error: The linkserver has been created but failed a connection test. Additional information: Name Pipes Provider:Could not open a connection to Sqlserver[53] OLEDB provider "SQLNCLI10:for linked server"MYSSQL_MSSQL_CONNECTION" retuned message "login timeout expired' "A network-related or instance specific error has occurred whilse establishing a connection to SQLSERVER. Server not found or accessible.