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

•  ODBC
  
  
  •  Standard Security:
    "Driver&＃61;{microsoft Access Driver (*.mdb)};Dbq&＃61;somepathmydb.mdb;Uid&＃61;Admin;Pwd&＃61;asdasd;"
    
    
  •  Workgroup:
    "Driver&＃61;{Microsoft Access Driver (*.mdb)};Dbq&＃61;somepathmydb.mdb;SystemDB&＃61;somepathmydb.mdw;","admin", ""
    
    
•  OLEDB, OleDbConnection (.NET)
  
  
  •  Standard security:
    "Provider&＃61;Microsoft.Jet.OLEDB.4.0;Data Source&＃61;somepathmydb.mdb;User Id&＃61;admin;Password&＃61;asdasd;"
    
    
  •  Workgroup (system database):
    "Provider&＃61;Microsoft.Jet.OLEDB.4.0;Data Source&＃61;somepathmydb.mdb;Jet OLEDB:System Database&＃61;system.mdw;","admin", ""
    
    
  •  With password:
    "Provider&＃61;Microsoft.Jet.OLEDB.4.0;Data Source&＃61;somepathmydb.mdb;Jet OLEDB:Database Password&＃61;MyDbPassword;","admin", ""
    
    

•  ODBC
  
  
  •  New version:
    "Driver&＃61;{Microsoft ODBC for Oracle};Server&＃61;OracleServer.world;Uid&＃61;Username;Pwd&＃61;asdasd;"
    
    
  •  Old version:
    "Driver&＃61;{Microsoft ODBC Driver for Oracle};ConnectString&＃61;OracleServer.world;Uid&＃61;myUsername;Pwd&＃61;myPassword;"
    
    
•  OLEDB, OleDbConnection (.NET)
  
  
  •  Standard security:
    "Provider&＃61;msdaora;Data Source&＃61;MyOracleDB;User Id&＃61;UserName;Password&＃61;asdasd;"

    This one&＃39;s from Microsoft, the following are from Oracle

  •  Standard Security:
    "Provider&＃61;OraOLEDB.Oracle;Data Source&＃61;MyOracleDB;User Id&＃61;Username;Password&＃61;asdasd;"
    
    
  •  Trusted Connection:
    "Provider&＃61;OraOLEDB.Oracle;Data Source&＃61;MyOracleDB;OSAuthent&＃61;1;"
    
    
•  OracleConnection (.NET)
  
  
  •  Standard:
    "Data Source&＃61;oracle8i;Integrated Security&＃61;yes";

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

  •  Declare the OracleConnection:
    

    C#:
    using System.Data.OracleClient;
    OracleConnection oOracleConn &＃61; new OracleConnection();
    oOracleConn.ConnectionString &＃61; "my connectionstring";
    oOracleConn.Open();
    
    VB.NET:
    Imports System.Data.OracleClient
    Dim oOracleConn As OracleConnection &＃61; New OracleConnection()
    oOracleConn.ConnectionString &＃61; "my connectionstring"
    oOracleConn.Open()
    
    

•  Data Shape
  
  
  •  MS Data Shape:
    "Provider&＃61;MSDataShape.1;Persist Security Info&＃61;False;Data Provider&＃61;MSDAORA;Data Source&＃61;orac;user id&＃61;username;password&＃61;mypw"
    
    

•  ODBC
  
  
  •  Local database:
    "Driver&＃61;{mySQL};Server&＃61;mySrvName;Option&＃61;16834;Database&＃61;mydatabase;"
    
    
  •  Remote database:
    "Driver&＃61;{mySQL};Server&＃61;data.domain.com;Port&＃61;3306;Option&＃61;131072;Stmt&＃61;;Database&＃61;my-database;Uid&＃61;username;Pwd&＃61;password;"
    
    
•  OLEDB, OleDbConnection (.NET)
  
  
  •  Standard:
    "Provider&＃61;MySQLProv;Data Source&＃61;mydb;User Id&＃61;UserName;Password&＃61;asdasd;"
•  MySqlConnection (.NET)
  
  
  •  EID:
    "Data Source&＃61;server;Database&＃61;mydb;User ID&＃61;username;Password&＃61;pwd;Command Logging&＃61;false"

    This one is used with eInfoDesigns dbProvider, an add-on to .net

  •  Declare the MySqlConnection:
    

    C#:
    using EID.MySqlClient;
    MySqlConnection oMySqlConn &＃61; new MySqlConnection();
    oMySqlConn.ConnectionString &＃61; "my connectionstring";
    oMySqlConn.Open();
    
    VB.NET:
    Imports EID.MySqlClient
    Dim oMySqlConn As MySqlConnection &＃61; New MySqlConnection()
    oMySqlConn.ConnectionString &＃61; "my connectionstring"
    oMySqlConn.Open()
    
    

•  OLEDB, OleDbConnection (.NET) from ms
  
  
  •  TCP/IP:
    "Provider&＃61;DB2OLEDB;Network Transport Library&＃61;TCPIP;Network Address&＃61;XXX.XXX.XXX.XXX;Initial Catalog&＃61;MyCtlg;Package Collection&＃61;MyPkgCol;Default Schema&＃61;Schema;User ID&＃61;MyUser;Password&＃61;MyPW"
    
    
  •  APPC:
    "Provider&＃61;DB2OLEDB;APPC Local LU Alias&＃61;MyAlias;APPC Remote LU Alias&＃61;MyRemote;Initial Catalog&＃61;MyCtlg;Package Collection&＃61;MyPkgCol;Default Schema&＃61;Schema;User ID&＃61;MyUser;Password&＃61;MyPW"
    
    

•  ODBC
  
  
  •  Standard:
    "Driver&＃61;{SYBASE SYSTEM 11};Srvr&＃61;Aron1;Uid&＃61;username;Pwd&＃61;password;"
    
    
  •  Intersolv 3.10:
    "Driver&＃61;{INTERSOLV 3.10 32-BIT Sybase};Srvr&＃61;Aron1;Uid&＃61;username;Pwd&＃61;password;"
    
    

•  ODBC
  
  
  •  Informix 3.30:
    "Dsn&＃61;&＃39;&＃39;;Driver&＃61;{INFORMIX 3.30 32 BIT};Host&＃61;hostname;Server&＃61;myserver;Service&＃61;service-name;Protocol&＃61;olsoctcp;Database&＃61;mydb;UID&＃61;username;PWD&＃61;myPwd
    
    
  •  Informix-CLI 2.5:
    "Driver&＃61;{Informix-CLI 2.5 (32 Bit)};Server&＃61;myserver;Database&＃61;mydb;Uid&＃61;username;Pwd&＃61;myPwd"
    
    

•  ODBC
  
  
  •  DSN:
    "DSN&＃61;myDsn;Uid&＃61;username;Pwd&＃61;;"
    
    
  •  File DSN:
    "FILEDSN&＃61;c:myData.dsn;Uid&＃61;username;Pwd&＃61;;"
    
    

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

    "HDR&＃61;Yes;" indicates that the first row contains columnnames, not data

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

•  ODBC
  
  
  •  Standard:
    "Driver&＃61;{Pervasive ODBC Client Interface};ServerName&＃61;srvname;dbq&＃61;&＃64;dbname"
    
    

•  UDL
  
  
  •  UDL:
    "File Name&＃61;c:myDataLink.udl;"
    

来自 “ ITPUB博客 ” &＃xff0c;链接&＃xff1a;http://blog.itpub.net/10752043/viewspace-993484/&＃xff0c;如需转载&＃xff0c;请注明出处&＃xff0c;否则将追究法律责任。