现在的位置: 首页 > 综合 > 正文

Oracle 和 IBMDB2 连接字符串

2012年05月16日 ⁄ 综合 ⁄ 共 1018字 ⁄ 字号 评论关闭

[oledb]
; Everything after this line is an OLE DB initstring
Provider=OraOLEDB.Oracle.1;Password=840616;Persist Security Info=True;User ID=SYSTEM;Data Source=orcl

[oledb]
; Everything after this line is an OLE DB initstring
Provider=MSDAORA.1;Password=840616;User ID=SYSTEM;Data Source=orcl;Persist Security Info=True
--------------------------------------------------------------------------------------------------------------------------------------------------
<appSettings>
   <!--连接IBM DB2-->
  <add key="Connstr_DB2" value="Provider=IBMDADB2.1;User ID=gcgl;Password=lgcg;Data Source=gc_sys"/>

  <!--连接Oracle 10g OleDb-->
  <add key="Connstr_OracleMS" value="Provider=MSDAORA.1;Data Source=Orcl;User ID=SYSTEM;Password=840616"/>
  <add key="Connstr_OracleOra" value="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=SYSTEM;Password=840616;Data Source=orcl"/>

  <!--连接Oracle 10g OracleClient-->
  <add key="Connstr_OracleClient" value="User Id=SYSTEM;Password=840616;Data Source=orcl;Pooling=true;Enlist=true;Min Pool Size=10;Connection Lifetime=120"/>
</appSettings>

抱歉!评论已关闭.