数据库连接字符串conn.open connStr(转集)

1.Sqlserver
  A.ODBC
    I.Standard Security:
      "Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;" 
    II.Trusted connection:
      "Driver={SQL Server};Server=Aron1;Database=pubs;
       Trusted_Connection=yes;" 
    III.Prompt for username and password:
       oConn.Properties("Prompt") = adPromptAlways
       oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;" 
  B.OLE DB, OleDbConnection (.NET) 
    I.Standard Security:
       "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User 
       Id=sa;Password=asdasd;"
    II.Trusted Connection:
       "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;
       Integrated Security=SSPI;" 
       (仅适用于Sqlserver 2000)
    III.Prompt for username and password:
       oConn.Provider = "sqloledb"
       oConn.Properties("Prompt") = adPromptAlways
       oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"  
    IV.Connect via an IP address:
       "Provider=sqloledb;Data Source=190.190.200.100,1433;Network
       Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;" 
  C.SqlConnection (.NET) 
    I.Standard Security:
     "Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;" 
     或者"Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;
     Trusted_Connection=False" 
    II.Trusted Connection:
     "Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;" 
     或者"Server=Aron1;Database=pubs;Trusted_Connection=True;" 
     (仅适用于Sqlserver 2000)
    III.Connect via an IP address:
     "Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial 
     Catalog=pubs;User ID=sa;Password=asdasd;" 
     Name       Network library 
     dbnmpntw   Win32 Named Pipes 
     dbmssocn   Win32 Winsock TCP/IP 
     dbmsspxn   Win32 SPX/IPX 
     dbmsvinn   Win32 Banyan Vines 
     dbmsrpcn   Win32 Multi-Protocol (Windows RPC) 
     通过SQLOLEDB provider 连接，用Network Library=dbmssocn，通过MSDASQL
     provider连接，用Network=dbmssocn 
    IV.声明方法：
     C#:
       using System.Data.SqlClient;
       SqlConnection oSQLConn = new SqlConnection();
       oSQLConn.ConnectionString="my connectionstring";
       oSQLConn.Open(); 
     VB.NET:
       Imports System.Data.SqlClient
       Dim oSQLConn As SqlConnection = New SqlConnection()
       oSQLConn.ConnectionString="my connectionstring"
       oSQLConn.Open() 
  D.Data Shape 
    MS Data Shape
    "Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial
    Catalog=pubs;User ID=sa;Password=asdasd;" 
   呵呵，Data Shape没用过，请参照
    http://www.4guysfromrolla.com/webtech/092599-1.shtml
2.Access 
  A.ODBC 
    I.Standard Security:
      "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
       Uid=Admin;Pwd=;" 
    II.Workgroup:
      "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
      SystemDB=C:\mydatabase.mdw;" 
    III.Exclusive:
      "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
      Exclusive=1;Uid=admin;Pwd="
  B.OLE DB, OleDbConnection (.NET) 
    I.Standard security:
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;
      User Id=admin;Password=;" 
    II.Workgroup (system database):
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;
      Jet OLEDB:System Database=system.mdw;" 
    III.With password:
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;
      Jet OLEDB:Database Password=MyDbPassword;" 

 

(附加:"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & mydbPath)

有密码打开

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=1"

用户组打开

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb;User ID=admin;Password=rr;Jet OLEDB:Database Password=1;Jet OLEDB:System database=c:\system.mdw"

局域网共享打开

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\access911\floder1\1.mdb;User ID='admin';Password='rr';Jet OLEDB:Database Password='1';Jet OLEDB:System database=\\access911\floder1\system.mdw"

 

JetOLEDB:GlobalPartialBulkOps=2;JetOLEDB:RegistryPath=;JetOLEDB:DatabaseLockingMode=1;JetOLEDB:DatabasePassword=;DataSource=D:\db.mdb;Password=;JetOLEDB:EngineType=5;JetOLEDB:GlobalBulkTransactions=1;Provider=Microsoft.Jet.OLEDB.4.0;JetOLEDB:Systemdatabase=;JetOLEDB:SFP=False;ExtendedProperties=;Mode=ShareDenyNone;JetOLEDB:NewDatabasePassword=;JetOLEDB:CreateSystemDatabase=False;JetOLEDB:Don'tCopyLocaleonCompact=False;JetOLEDB:CompactWithoutReplicaRepair=False;UserID=Admin;JetOLEDB:EncryptDatabase=False

 

2007:

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Documents and Settings\chenge\My Documents\数据库1.accdb;Mode=Share Deny Read|Share Deny Write;Extended Properties="";Jet OLEDB:System database=C:\Documents and Settings\chenge\Application Data\Microsoft\Access\System.mdw;Jet OLEDB:Registry Path=Software\Microsoft\Office\12.0\Access\Access Connectivity Engine;Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=True
3.Oracle 
  A.ODBC 
    I.New version:
      "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;
      Uid=Username;Pwd=asdasd;" 
    II.Old version:
      "Driver={Microsoft ODBC Driver for Oracle};ConnectString=
      OracleServer.world;Uid=myUsername;Pwd=myPassword;" 
  B.OLE DB, OleDbConnection (.NET) 
    I.Standard security:
      "Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;
      Password=asdasd;" 
      注：上面是用MS的驱动，下面是用Oracle提供的驱动：
      "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User
      Id=Username;Password=asdasd;" 
    II.Trusted Connection:
      "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;" 
  C.OracleConnection (.NET) 
    I.Standard:
      "Data Source=Oracle8i;Integrated Security=yes"; 
      注：此写法用于Oracle 8i release 3及以上版本。
      声明方法:
      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() 
  D.Data Shape 
    I.MS Data Shape:
      "Provider=MSDataShape.1;Persist Security Info=False;Data 
      Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"
3.MySQL 
  A.ODBC 
    I.Local database:
      "Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;" 
    II.Remote database:
      "Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;
      Stmt=;Database=my-database;Uid=username;Pwd=password;" 
  B.OLE DB, OleDbConnection (.NET) 
    I.Standard:
      "Provider=MySQLProv;Data Source=mydb;User Id=UserName;
      Password=asdasd;" 
  C.MySqlConnection (.NET) 
    I.eInfoDesigns.dbProvider:
      "Data Source=server;Database=mydb;User ID=username;
      Password=pwd;Command Logging=false" 
      注：此写法仅用于通过eInfoDesigns dbProvider连接：
    II.声明方法：
      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()   
4.Interbase 
  A.ODBC (Easysoft ODBC-Interbase driver ) 
   I.Local computer:
     "Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:
     C:\mydatabase.gdb;Uid=username;Pwd=password" 
   II.Remote Computer:
     "Driver={Easysoft IB6 ODBC};Server=ComputerName;Database=ComputerName
     :C:\mydatabase.gdb;Uid=username;Pwd=password" 
  B.ODBC (Intersolv ODBC-Interbase driver )
   I.Local computer:
     "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;
     Database=localhost:C:\mydatabase.gdb;Uid=username;Pwd=password" 
   II.Remote Computer:
     "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};
     Server=ComputerName;Database=ComputerName:C:\mydatabase.gdb;
     Uid=username;Pwd=password" 
  C.OLE DB (SIBPROvider Driver) 
   I.Standard:
     "provider=sibprovider;location=localhost:;data source=c:
     \databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey" 
   II.Specifying character set:
     "provider=sibprovider;location=localhost:;data source=c:
     \databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey;
     character set=ISO8859_1" 
   III.Specifying role:
     "provider=sibprovider;location=localhost:;data source=c:
     \databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey;
     role=DIGITADORES"
6.IBM DB2 
  A.OLE DB, OleDbConnection (.NET) from ms 
   I.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" 
   II.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"  
7.Sybase 
  A.ODBC 
   I.Standard Sybase System 12 (or 12.5) Enterprise Open Client:
     "Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password" 
   II.Standard Sybase System 11:
     "Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;" 
   III.Intersolv 3.10:
     "Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;
     Pwd=password;" 
   IIII.Sybase SQL Anywhere (former Watcom SQL ODBC driver):
    "ODBC; Driver=Sybase SQL Anywhere 5.0; DefaultDir=c:\dbfolder\;Dbf=
    c:\mydatabase.db;Uid=username;Pwd=password;Dsn=""""" 
  B.OLEDB
    I.Adaptive Server Anywhere (ASA):
    "Provider=ASAProv;Data source=myASA" 
    II.Adaptive Server Enterprise (ASE) with Data Source .IDS file:
    "Provider=Sybase ASE OLE DB Provider; Data source=myASE" 
    注：必须先用Data Administrator创建Data Source .IDS file  
    III.Adaptive Server Enterprise (ASE):
    "Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDBname;
    User Id=username;Password=password" 
8.Informix 
  A.ODBC 
    I.Informix 3.30:
    "Dsn=’’;Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myserver;Service=
    service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd 
    II.Informix-CLI 2.5:
    "Driver={Informix-CLI 2.5 (32 Bit)};Server=myserver;Database=mydb;
    Uid=username;Pwd=myPwd" 
  B.OLE DB 
    I.IBM Informix OLE DB Provider:
    "Provider=Ifxoledbc.2;password=myPw;User ID=myUser;Data Source=
    dbName@serverName;Persist Security Info=true" 
9.Mimer SQL 
  A.ODBC 
    I.Standard Security:
    "Driver={MIMER};Database=mydb;Uid=myuser;Pwd=mypw;" 
    II. Prompt for username and password:
    "Driver={MIMER};Database=mydb;" 
10.DSN 
  A.ODBC 
   I.DSN:
    "DSN=myDsn;Uid=username;Pwd=;" 
   II.File DSN:
    "FILEDSN=c:\myData.dsn;Uid=username;Pwd=;" 
11.Excel 
  A.ODBC 
   I.Standard:
    "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;
    Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;" 
  B.OLE DB 
   I.Standard:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended 
    Properties=""Excel 8.0;HDR=Yes;IMEX=1""" 
    "HDR=Yes;" indicates that the first row contains columnnames, not data.
    "IMEX=1;" tells the driver to alway

 

万能方法，新建.udl文件，打开。