关于数据库连接串： 参考：http://www.connectionstrings.com/ 数据库： SQLServer2005: 访问器名称：.NET Framework Data Provider for SQL Server Type: .NET Framework Class Library Usage: System.Data.SqlClient.SqlConnection Standard Security：Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False; Trusted Connection：Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI; Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; 访问器名称：.NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Bridging to SQL Native Client OLE DB ：Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword; Bridging to OLE DB Provider for SQL Server:Provider=SQLOLEDB;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername; Password=myPassword; 访问器名称：.NET Framework Data Provider for ODBC Type: .NET Framework Wrapper Class Library Usage: System.Data.Odbc.OdbcConnection Bridging to SQL Native Client 10.0 ODBC Driver :Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Oracle: 访问器名称：.NET Framework Data Provider for Oracle Type: .NET Framework Class Library Usage: System.Data.OracleClient.OracleConnection Standard： Data Source=MyOracleDB;Integrated Security=yes; Specifying username and password：Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no; Omiting tnsnames.ora：Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword; Using Connection Pooling：Data Source=myOracleDB;User Id=myUsername;Password=myPassword;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=2; 访问器名称：Oracle Data Provider for .NET / ODP.NET Type: .NET Framework Class Library Usage: Oracle.DataAccess.Client.OracleConnection Using TNS： Data Source=TORCL;User Id=myUsername;Password=myPassword Using ODP.NET without tnsnames.ora：Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword; Using the Easy Connect Naming Method ：Data Source=username/password@//myserver:1521/my.service.com; 访问器名称：.NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Bridging to Oracle Provider for OLE DB：Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;OLEDB.NET=True; 访问器名称：.NET Framework Data Provider for ODBC Type: .NET Framework Wrapper Class Library Usage: System.Data.Odbc.OdbcConnection Bridging to Oracle in OraHome92 ODBC Driver：Driver={Oracle in OraHome92};Server=myServerAddress;Dbq=myDataBase;Uid=myUsername;Pwd=myPassword;
SQLite： 访问器名称：SQLite.NET Type: .NET Framework Class Library Usage: System.Data.SQLite.SQLiteConnection Basic： Data Source=filename;Version=3; Using UTF16：Data Source=filename;Version=3;UseUTF16Encoding=True; With password：Data Source=filename;Version=3;Password=myPassword; Using the pre 3.3x database format：Data Source=filename;Version=3;Legacy Format=True; With connection pooling：Data Source=filename;Version=3;Pooling=False;Max Pool Size=100; Read only connection：Data Source=filename;Version=3;Read Only=True; 访问器名称：.NET Framework Data Provider for ODBC Type: .NET Framework Wrapper Class Library Usage: System.Data.Odbc.OdbcConnection Bridging to SQLite3 ODBC Driver：DRIVER=SQLite3 ODBC Driver;Database=mydb.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;
Access: 访问器名称：.NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Bridging to Jet OLE DB 4.0：Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/mydatabase.mdb;User Id=admin;Password=; Bridging to ACE OLEDB 12.0:Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/myFolder/myAccess2007file.accdb;Persist Security Info=False; 访问器名称：.NET Framework Data Provider for ODBC Type: .NET Framework Wrapper Class Library Usage: System.Data.Odbc.OdbcConnection Bridging to Microsoft Access ODBC Driver：Driver={Microsoft Access Driver (*.mdb)};Dbq=C:/mydatabase.mdb;Uid=Admin;Pwd=;
Excel: 访问器名称：.NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Bridging to Jet OLE DB 4.0:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"; 访问器名称：.NET Framework Data Provider for ODBC Type: .NET Framework Wrapper Class Library Usage: System.Data.Odbc.OdbcConnection Bridging to Microsoft Excel ODBC Driver:Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:/MyExcel.xls;DefaultDir=c:/mypath; 访问器名称：.NET xlReader for Microsoft Excel Type: .NET Framework Class Library Usage: VM.xPort.ExcelClient.ExcelConnection Excel file with header row：Data Source =c:/myExcelFile.xls;HDR=yes;Format=xls; Excel file without header row：Data Source =c:/myExcelFile.xls;HDR=no;Format=xls;
MySQL： 访问器名称：MySQLDriverCS Type: .NET Framework Class Library Usage: MySQLDriverCS.MySQLConnection Standard： Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties=""""; 访问器名称：.NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Bridging to MySQL OLEDB：Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword; 访问器名称：.NET Framework Data Provider for ODBC Type: .NET Framework Wrapper Class Library Usage: System.Data.Odbc.OdbcConnection Bridging to MySQL Connector/ODBC 5.1：Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;
HTML Table： 访问器名称：.NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Bridging to Jet OLE DB 4.0：Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://www.websitewithhtmltable.com/tablepage.html;Extended Properties="HTML Import;HDR=YES;IMEX=1";
Textfile： 访问器名称：.NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Bridging to Jet OLE DB 4.0：Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/txtFilesFolder/;Extended Properties="text;HDR=Yes;FMT=Delimited"; 访问器名称：.NET Framework Data Provider for ODBC Type: .NET Framework Wrapper Class Library Usage: System.Data.Odbc.OdbcConnection Bridging to Microsoft Text ODBC Driver：Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:/txtFilesFolder/;Extensions=asc,csv,tab,txt;
SharePoint： 访问器名称：.NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Bridging to ACE OLEDB 12.0：Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes; DATABASE=http://pp1webofficelivecom.officelive.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};