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;" 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 always read "intermixed" data columns as text. 12.Text A.ODBC I.Standard: "Driver={Microsoft Text Driver (*.txt; *.csv)}; Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;" B.OLE DB I.Standard: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties=""text;HDR=Yes;FMT=Delimited""" "HDR=Yes;" indicates that the first row contains columnnames, not data.
13.DBF / FoxPro A.ODBC I.standard: "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;" B.OLE DB, OleDbConnection (.NET) I.standard: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties= dBASE IV;User ID=Admin;Password=" 14.Visual FoxPro A.OLE DB, OleDbConnection (.NET) I.Database container (.DBC): "Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc; Password=MyPassWord;Collating Sequence=machine" II. Free table directory: "Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Password=MyPassWord; Collating Sequence=general" B.ODBC I.Database container (.DBC): "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB= c:\myvfpdb.dbc;Exclusive=No;Collate=Machine;" II.Free Table directory: "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB= c:\myvfpdbfolder;Exclusive=No;Collate=Machine;" 15.Pervasive (没听说过这个东东) A.ODBC I.Standard: "Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname" B.OLE DB I.Standard: "Provider=PervasiveOLEDB;Data Source=C:\path" 16.UDL "File Name=c:\myDataLink.udl;"

|