.NET中各种数据库连接大全
http://dev.csdn.net/article/16/16437.shtm
http://www.connectionstrings.com/
http://community.csdn.net/Expert/TopicView3.asp?id=3705163
http://dev.csdn.net/article/16/16437.shtm
http://www.connectionstrings.com/
http://community.csdn.net/Expert/TopicView3.asp?id=3705163
解决方案 »
- 请问这段c# 连接 操作access数据库代码错误怎么解决?
- 关于关闭窗口 来拿分吧
- 用电脑通过传真机发送传真
- C# 视频实时抓图
- 放分了阿!!!!!!!!!!!!回者有分!!!!!!!1
- 窗体之间的调用
- C#中用华为API开发短信项目问题 解决疑问至少200块
- 在线等待 ,怎么在代码中调用存储过程中的所有返回值呀?
- 请高手指教 如何实现记事本中的查找 替换功能?
- winForm中treeview能不能把某些列给隐藏起来,不显示?
- 急求数据中单点突跳的剔除方法?
- 我安装了,.NET是在,2000系统上,为什么,.NET的MSDN文档用着用着,就不能用了.出错dexprole.EXE提示"0x75da33d6"指令引用的"0x00233694"内存
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()
具体你可以看一下我以前写的这两篇文章在.NET环境下操作MySQL数据库http://www.cnblogs.com/jimmy/archive/2004/09/10/41892.htmlhttp://www.cnblogs.com/jimmy/archive/2004/09/15/43402.html
通过它你可象操作MSSQL一样操作.
ODBC
ODBC 2.50 Local database:"Driver={mySQL};Server=localhost;Option=16834;Database=mydatabase;" ODBC 2.50 Remote database:"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;" ODBC 3.51 Local database:"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;" ODBC 3.51 Remote database:"DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;" OLE DB, OleDbConnection (.NET)
Standard:"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
MySqlConnection (.NET)
eInfoDesigns.dbProvider:"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 eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connectionstring";
oMySqlConn.Open(); VB.NET:
Imports eInfoDesigns.dbProvider.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connectionstring"
oMySqlConn.Open() SevenObjects MySqlClient (.NET)
Standard:"Host=server; UserName=myusername; Password=mypassword;Database=mydb;"
This is a freeware ADO.Net data provider from SevenObjects
Core Labs MySQLDirect (.NET)
Standard:"User ID=root; Password=pwd; Host=localhost; Port=3306; Database=test;Direct=true; Protocol=TCP; Compress=false; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0"
Read more at Core Lab and the product page.