mysql oledb驱动程序 [英] mysql oledb driver

问题描述

如何在本地系统中安装mysql oledb驱动程序.

how to install mysql oledb driver in local system.

请提供Mysql oledb连接字符串

please give Mysql oledb Connection string

推荐答案

.NET解决方案(c#)

您需要使用Package-Manager安装MySql.Data ...

.NET Solution (c#)

You need to install MySql.Data using Package-Manager...

PM>安装包MySql.Data

PM>Install-Package MySql.Data

然后，在您的C#代码中执行以下操作.

Then, in your c# code do something like this..

using System.Data.OleDb;
using System.Data.Common;
using MySql.Data.MySqlClient;

DbProviderFactory factory = new MySqlClientFactory();
DbConnection cxn = factory.CreateConnection();
cxn.ConnectionString = "server=mysqlserver;port=3306;Database=mydb;user id=myname;password=mypass;SslMode=none;Convert Zero Datetime=True";
cxn.Open();

这篇关于mysql oledb驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！