What is the difference between a Provider and a Connector in database world?
I create an new text file, rename it to test.udl and double click on the file. This brings up the OLE DB connection string dialog box. The first tab shows a list of providers installed on my machine. I need a MySQL Connection string, but I do not have a MySql provider in the list. So I download MySql ADO.NET Connector from the internet and install it, but it still does not show up as a provider. 

What is a Provider and what is a Connector?
What is the difference between a Provider and a Connector in database world?
===

I create an new text file, rename it to test.udl and double click on the file. This brings up the OLE DB connection string dialog box. The first tab shows a list of providers installed on my machine. I need a MySQL Connection string, but I do not have a MySql provider in the list. So I download MySql ADO.NET Connector from the internet and install it, but it still does not show up as a provider. 

What is a Provider and what is a Connector?