Oracle 连接字符串

最新推荐文章于 2021-08-23 21:38:41 发布

weixin_30721077

最新推荐文章于 2021-08-23 21:38:41 发布

阅读量67

点赞数

原文链接：http://www.cnblogs.com/gxivwshjj/p/5665628.html

版权

<!--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)(PORT=1521)))(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>