怎么用OLEDB连接oracle

怎么用OLEDB连接oracle ?,

解决方案 »

  1.   

    http://topic.csdn.net/t/20061027/11/5113168.html
      

  2.   

    TNS-less连接串Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User Id=myUsername;Password=myPassword;
      

  3.   

    provider=OraOLEDB.Oracle;Data Source=" + dbname.InnerText + ";User Id=" + userid.InnerText + ";Password=" + pwd.InnerText + ";"