<!--web.config-->
<connectionStrings> <add name="MSSQL"connectionstring="server=.; database=bjrd;uid=sa;pwd=123456"Providername="System.Data.SqlClient"/> <add name="Oracle"connectionstring="User Id=jijian; Password=jijian;data source= (description= (address_list= (address=) (PROTOCOL=TCP) (host=127.0.0.1)) ( Connect_data= (server=dedicated) (sid=xxxxx )))"Providername="Oracle.ManagedDataAccess.Client"/> </connectionStrings>
<!--c:\windows\microsoft.net\framework\v4.0.30319\config\machine.config-->
<system.data> <DbProviderFactories> <add name="odp.net, Managed Driver"Invariant="Oracle.ManagedDataAccess.Client"description="Oracle Data Provider for. NET, Managed Driver"Type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.manageddataaccess, version=4.121.2.0, culture= Neutral, publickeytoken=89b483f429c47342"/> <add name="MySQL Data Provider"Invariant="MySql.Data.MySqlClient"description=". Net Framework Data Provider for MySQL"Type="MySql.Data.MySqlClient.MySqlClientFactory, Mysql.data, version=6.9.3.0, Culture=neutral, publickeytoken= C5687FC88969C44D"/> <add name="Microsoft SQL Server Compact Data Provider 4.0"Invariant="system.data.sqlserverce.4.0"description=". NET Framework Data Provider for Microsoft SQL Server Compact"Type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, version=4.0.0.0, Culture=neutral, Publickeytoken=89845dcd8080cc91"/> <add name="Oracle Data Provider for. NET"Invariant="Oracle.DataAccess.Client"description="Oracle Data Provider for. NET"Type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.dataaccess, version=4.112.2.0, Culture=neutral, publickeytoken=89b483f429c47342"/> </DbProviderFactories> </system.data>
Oracle Connection string