You should be able to make the connection; you just need to get the right
combination of keywords and values in your connection  string. On
connectionstrings.com/?carrier=mysql, a simple sample it provides is:



Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;



The Port keyword is optional, since you're using the default port. Possibly
you can only use "User Id", and not "User" as you did. And apparently you
should use "Data Source" instead of "Database". So in your case I would try:



Provider=MySQLProv;Data Source=NIFTY;User Id=root;Password=pl;



In my experience, your selection of either the use of "Provider" or "Driver"
or neither determines which other set of keywords you should use, and I
think your mixing and matching, which might be part of the issue.

I haven't tested an OLE DB mysql  connection just now, but have in the past
without difficulty.

I think the Data Source value should be equal to localhost isn't it?

The setting for the table "Initial Catalog = myDB"

But still these settings don't work.

I managed  to connect  using the ODBC drivers smoothly, experimentd a lot with
OleDB but could not find anythign off the net for MySQL.

The pursuit for the OLEDB drivers is just for academic purposes. But I would
really like to know how to go about doing it.