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 !