Public structConnectionStrings {/// <summary> ///OLE DB Standard connection/// </summary> Public Static stringOLE DB ="provider={0};D ata source={1};initital catalog={2}; User id={3}; PASSWORD={4}"; /// <summary> ///ODBC Standard Connection/// </summary> Public Static stringODBC ="driver={{0}}; Server={1};D atabase={2}; UID={3}; PWD={4}"; /// <summary> ///file-based database standard connection/// </summary> Public Static stringACESSODBC ="driver={{0}}; Server={1};D bq={2}; UID={3}; PWD={4}"; } Public classConnectionString {/// <summary> ///data source, empty then default local/// </summary> Public stringDataSource {Get;Set; } /// <summary> ///Database name/// </summary> Public stringDatabase {Get;Set; } /// <summary> ///Login Name/// </summary> Public stringUserID {Get;Set; } /// <summary> ///Login Password/// </summary> Public stringPassword {Get;Set; } /// <summary> ///connection time-out period/// </summary> Public stringConnectionTimeout {Get;Set; } /// <summary> ///Load Balancing Timeout/// </summary> Public stringConnectionlifetime {Get;Set; } /// <summary> ///Maximum number of connections allowed in the pool/// </summary> Public stringminpoolsize {Get;Set; } /// <summary> ///Maximum number of connections allowed in the pool/// </summary> Public stringmaxpoolsize {Get;Set; } /// <summary> ///The size, in bytes, of the network packet that is to communicate with an instance of SQL Server/// </summary> Public stringPacketSize {Get;Set; } /// <summary> ///Trust Connection/// </summary> Public stringTrusted_Connection {Get;Set; } /// <summary> ///When the value is true, if the server side has a certificate installed///SQL Server uses SSL encryption for all data that is transferred between the client and the server///the recognized values are true, false, yes, and no/// </summary> Public stringEncrypt {Get;Set; } /// <summary> ///Network library for establishing a connection to an instance of SQL Server/// </summary> Public stringnetworklibrary {Get;Set; } /// <summary> ///Database Version/// </summary> Public stringtypesystemversion {Get;Set; } } Public structDbprovider { Public Static stringSqlserverprovider ="SQLOLEDB"; Public Static stringAcessprovider ="microsoft.jet.oledb.4.0"; Public Static stringExcelprovider ="microsoft.jet.oledb.4.0"; Public Static stringTextprovider ="microsoft.jet.oledb.4.0"; Public Static stringOracleprovider ="Msdaora"; Public Static stringMysqlprovider ="Mysqlprov"; Public Static stringIbmdb2provider ="Db2oledb"; Public Static stringSibprovider ="Sibprovider"; Public Static stringAdaptiveserveranywhereprovider ="Asaprov"; Public Static stringAdaptiveserverenterpriseprovider ="Sybase ASE OLE DB Provider"; Public Static stringVisualfoxproprovider ="Vfpoledb"; } Public structDbdriver { Public Static stringSQLServerDriver ="SQL Server"; Public Static stringAccessdriver ="Microsoft Access Driver (*.mdb)"; Public Static stringExceldriver ="Microsoft Excel Driver (*.xls)"; Public Static stringTextdriver ="Microsoft Text Driver (*.txt; *.csv)"; Public Static stringOracledriver ="Microsoft ODBC for Oracle"; Public Static stringMysqldriver ="MySQL ODBC 3.51 driver|mysql";//?? Public Static stringInterbasedriver ="easysoft IB6 ODBC"; Public Static stringIntersolvdriver ="intersolv InterBase ODBC Driver (*.gdb)"; Public Static stringIntersolv310 ="intersolv 3.10 32-bit Sybase"; Public Static stringAs400driver ="Client Access ODBC Driver (32-bit)"; Public Static stringSybase12driver ="SYBASE ASE ODBC Driver"; Public Static stringSybase11driver ="SYBASE SYSTEM One"; Public Static stringSybasesqlanywheredriver ="Sybase SQL Anywhere 5.0"; Public Static stringVisualfoxprodbasedriver ="Microsoft DBASE Driver (*.dbf)"; Public Static stringVisualfoxprodriver ="Microsoft Visual Foxpro Driver"; } }
Configuration of the database connection string (2)