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.
我创建一个新的文本文件,将其重命名为test.udl并双击该文件。这将打开OLE DB连接字符串对话框。第一个选项卡显示我的计算机上安装的提供程序列表。我需要一个MySQL连接字符串,但我没有列表中的MySql提供程序。所以我从互联网上下载MySql ADO.NET Connector并安装它,但它仍然没有显示为提供者。
What is a Provider and what is a Connector?
什么是提供商,什么是连接器?
1 个解决方案
#1
The Connector will allow you to connect in a ".Net" way, while the provider will allow you to connect via OLEDB interface.
连接器允许您以“.Net”方式连接,而提供程序允许您通过OLEDB接口连接。
The MySql connector will give you access to classes as MySqlConnection, MySqlCommand, etc, and all the ADO.Net paradigm objects, while with OLEDB you will connect via OleDbConnection, OleDbCommand, etc
MySql连接器将允许您访问类,如MySqlConnection,MySqlCommand等,以及所有ADO.Net范例对象,而使用OLEDB,您将通过OleDbConnection,OleDbCommand等连接
#1
The Connector will allow you to connect in a ".Net" way, while the provider will allow you to connect via OLEDB interface.
连接器允许您以“.Net”方式连接,而提供程序允许您通过OLEDB接口连接。
The MySql connector will give you access to classes as MySqlConnection, MySqlCommand, etc, and all the ADO.Net paradigm objects, while with OLEDB you will connect via OleDbConnection, OleDbCommand, etc
MySql连接器将允许您访问类,如MySqlConnection,MySqlCommand等,以及所有ADO.Net范例对象,而使用OLEDB,您将通过OleDbConnection,OleDbCommand等连接