MySQL ODBC Local database: "Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;" Remote database: "Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;" OLEDB, OleDbConnection (.NET) Standard: "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;" MySqlConnection (.NET) EID: "Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false" This one is used with eInfoDesigns dbProvider, an add-on to .NET Declare the MySqlConnection:C#: using EID.MySqlClient; MySqlConnection oMySqlConn = new MySqlConnection(); oMySqlConn.ConnectionString = "my connectionstring"; oMySqlConn.Open(); VB.NET: Imports EID.MySqlClient Dim oMySqlConn As MySqlConnection = New MySqlConnection() oMySqlConn.ConnectionString = "my connectionstring" oMySqlConn.Open()
谢谢luluso(luluso) ,我看的不是很明白,不知道我这样是否正确 在webconfig中定义<appSettings><add key="conn" value="Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd" /></appSettings> 在数据层中定义数据访问基类using System; using System.Configuration; using System.Data; using System.Data.OleDb; namespace DA { /// <summary> /// 数据库基类 /// </summary> public class DataBase { protected static string strConnection = ConfigurationSettings.AppSettings["conn"].ToString(); protected static OleDbConnection conn; /// <summary> /// 初始化连接 /// </summary> public DataBase() { conn = new OleDbConnection(strConnection); } /// <summary> /// 打开数据库连接 /// </summary> protected void OpenConnection() { if (conn.State != ConnectionState.Open) conn.Open(); } /// <summary> /// 关闭数据库连接 /// </summary> protected void CloseConnection() { conn.Close(); } 我这样写对吗
MySQL
ODBC
Local database:
"Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;"
Remote database:
"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"
OLEDB, OleDbConnection (.NET)
Standard:
"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
MySqlConnection (.NET)
EID:
"Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false"
This one is used with eInfoDesigns dbProvider, an add-on to .NET
Declare the MySqlConnection:C#:
using EID.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connectionstring";
oMySqlConn.Open(); VB.NET:
Imports EID.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connectionstring"
oMySqlConn.Open()
在webconfig中定义<appSettings><add key="conn" value="Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd" /></appSettings>
在数据层中定义数据访问基类using System;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
namespace DA
{
/// <summary>
/// 数据库基类
/// </summary>
public class DataBase
{
protected static string strConnection = ConfigurationSettings.AppSettings["conn"].ToString();
protected static OleDbConnection conn;
/// <summary>
/// 初始化连接
/// </summary>
public DataBase()
{
conn = new OleDbConnection(strConnection);
}
/// <summary>
/// 打开数据库连接
/// </summary>
protected void OpenConnection()
{
if (conn.State != ConnectionState.Open)
conn.Open();
}
/// <summary>
/// 关闭数据库连接
/// </summary>
protected void CloseConnection()
{
conn.Close();
}
我这样写对吗
SqlConnection mycon=new SqlConnection(str1);
其实,我给你推荐http://www.mysql.com/products/connector/net/。
我的原因很简单,a,专用驱动,似乎经过了优化;b,方便部署。在目标机器上拷贝一个dll,和安装一个oledb相比哪个更简单?