.NET中各种数据库连接大全(23)

王朝c#·作者佚名  2007-05-11
宽屏版  字体: |||超大  

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()

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()

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()

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;"

Standard:

"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"

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()

IBM DB2

OLEDB, OleDbConnection (.NET) from ms

TCP/IP:

"Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"

APPC:

"Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"

TCP/IP:

"Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"

APPC:

"Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"

Sybase

ODBC

Standard:

"Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"

Intersolv 3.10:

"Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;"

Standard:

"Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"

Intersolv 3.10:

"Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;"

第一页    上一页    第23页/共33页    下一页    最后页
第01页 第02页 第03页 第04页 第05页 第06页 第07页 第08页 第09页 第10页 
第11页 第12页 第13页 第14页 第15页 第16页 第17页 第18页 第19页 第20页 
第21页 第22页 第23页 第24页 第25页 第26页 第27页 第28页 第29页 第30页 
第31页 第32页 第33页 
 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
© 2005- 王朝网络 版权所有