<?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>