Configuration of the database connection string (2)

Source: Internet
Author: User
Tags ole

 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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.