folks ! I found a .Net provider executable which I installed and created a provider to MySql database...but now when I create the connection manager I am getting errors as follows....

Error : " Test connection failed because of an error in intitializing the provider

unable to connect to the specified MySql hosts "

I added a connection by right clicking on database connnections in server explorer which worked fine and it even displays the tables, SP, of that perticular MySql database but when I create a connection manager and specify the same server name uid and password I get that error i mentioned...

please advise !