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

Access

• ODBC 
  
  • Standard Security:
    "Driver= {Microsoft AccessDriver(*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"
  • Workgroup:
    "Driver= {Microsoft Access Driver(*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;","admin", ""
• OLEDB, OleDbConnection (.NET) 
  
  • Standard security:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= \somepath\mydb.mdb;UserId=admin;Password=asdasd;"
  • Workgroup (system database):
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;","admin", ""
  • With password:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;","admin", ""

·   Oracle

• ODBC
  • New version:
    "Driver= {Microsoft ODBCforOracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"
  • Old version:
    "Driver= {Microsoft ODBC DriverforOracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"
• OLEDB, OleDbConnection (.NET)
  • Standard security:
    "Provider=msdaora;Data Source= MyOracleDB;UserId=UserName;Password=asdasd;"

This one's from Microsoft, the following are from Oracle

• • Standard Security:
    "Provider=OraOLEDB.Oracle;Data Source= MyOracleDB;UserId=Username;Password=asdasd;"
  • Trusted Connection:
    "Provider= OraOLEDB.Oracle;DataSource=MyOracleDB;OSAuthent=1;"
• OracleConnection (.NET)
  • Standard:
    "Data Source=Oracle8i;Integrated Security=yes";

This one works only with Oracle 8i release 3 or later

• • Declare the OracleConnection:

C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connectionstring";
oOracleConn.Open(); 

VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connectionstring"
oOracleConn.Open()

• Data Shape
  • MS Data Shape:
    "Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source= orac;userid=username;password=mypw"

·   MySQL

• ODBC
  • Local database: 
    "Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;"
  • < B>Remotedatabase:
    "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:
    "DataSource=server;Database= mydb;UserID=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;UserID=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;UserID=MyUser;Password=MyPW"

·   Sybase

• ODBC
  • Standard:
    "Driver= {SYBASESYSTEM11};Srvr=Aron1;Uid=username;Pwd=password;"
  • Intersolv 3.10:
    "Driver= {INTERSOLV 3.1032-BITSybase};Srvr=Aron1;Uid=username;Pwd=password;"

·   Informix

• ODBC
  • Informix 3.30: 
    "Dsn='';Driver={INFORMIX3.3032BIT};Host=hostname;Server=myserver;Service=service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd
  • Informix-CLI 2.5:
    "Driver= {Informix-CLI2.5(32Bit)};Server=myserver;Database=mydb;Uid=username;Pwd=myPwd"

·   DSN

• ODBC
  • DSN:< BR>"DSN=myDsn;Uid=username;Pwd=;"
  • File DSN:< BR>"FILEDSN=c:\myData.dsn;Uid=username;Pwd=;"

·   Excel

• ODBC

• • Standard:
    "Driver= {Microsoft ExcelDriver(*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;"
• OLE DB
  • Standard:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=Excel 8.0;HDR=Yes;"

"HDR=Yes;" indicates that the first row contains columnnames, not data

·   DBF / FoxPro

• ODBC
  • standard:
    "Driver= {Microsoft dBASE Driver(*.dbf)};DriverID=277;Dbq=c:\mydbpath;"
• OLEDB, OleDbConnection (.NET)
  • standard:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties= dBASE IV;UserID=Admin;Password="

·   Pervasive

• ODBC
  • Standard:
    "Driver= {Pervasive ODBC ClientInterface};ServerName=srvname;dbq=@dbname"

·   UDL

• UDL

         UDL:
                "File Name=c:\myDataLink.udl;"

2009-09-04                   

注：源自原百度博客“至美心”