<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <clear/>
    <add name="Localhost" connectionString="Data Source=.;Integrated Security=SSPI;Persist Security Info=False;" />
    <add name="MySql_Local" connectionString="Server=127.0.0.1;Database=test;Uid=root;Pwd=123456;" providerName="MySql.Data.MySqlClient"/>
    <add name="SQLite" connectionString="Data Source=F:\data\sqlite3\testdb.s3db;Version=3;" providerName="System.Data.SQLite"/>
    <add name="access" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\main.mdb;User Id=admin;Password=;" providerName="System.Data.OleDb" />
    <add name="oracle_ddtek" connectionString="Host=127.0.0.1;Port=1521;User ID=kly;Password=1111;SID=orcl" providerName="DDTek.Oracle"/>
    <add name="oracle_Devart_tns" connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.20)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User Id=kly;Password=111;" providerName="Devart.Data.Oracle"/>
    <add name="oracle_odp" connectionString="Data Source=orcl;User ID=kly;Password=111;" providerName="System.Data.OracleClient"/>
  </connectionStrings>

    <system.data>
        <DbProviderFactories>
            <clear/>
            <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
            <add name="MySqlClient Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySql" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data" />
            <add name="DB2 Data Provider" invariant="IBM.Data.DB2" description=".Net Framework Data Provider for DB2" type="IBM.Data.DB2.DB2Factory, IBM.Data.DB2" />
      <add name="DDTek Oracle Data Provider" invariant="DDTek.Oracle" description=".Net Framework Data Provider for DDTek Oracle" type="DDTek.Oracle.OracleFactory, DDTek.Oracle" />
      <add name="Devart Data Oracle Data Provider" invariant="Devart.Data.Oracle" description=".Net Framework Data Provider for Devart Data Oracle" type="Devart.Data.Oracle.OracleProviderFactory, Devart.Data.Oracle" />
    </DbProviderFactories>
    </system.data>
</configuration>