vs.net 中连接ORACLE

Question

连结字符串不对，注意User ID和Data Source中间的空格，pwd-〉password，server=后面漏了分号
ConnectionString = "Provider=MSDAORA.1; Password=liuhz1017; User ID=system; Data Source=liuhz";

Answer 1

public string connectora="Provider=MSDAORA.1;Password=密码;User ID=用户;Data Source=连接串;Persist Security Info=True"; #region 连接Oracle数据库
public OleDbConnection ConnectDB() 
{
try
{
OleDbConnection conn=new OleDbConnection();
conn.ConnectionString=connectora;
conn.Open();
return conn;
}
catch
{
return null;
}
}
#endregion--用户名和密码及连接串是你从客户端登陆oracle的用户名密码和连接串.

Answer 2

http://dev.csdn.net/article/16/16437.shtm
http://www.connectionstrings.com/

Answer 3

string conn_str = "Provider=OraOLEDB.Oracle.1;Password=" + Password + ";Persist Security Info=True;User ID=" + LoginID + ";Data Source=" + ServerName + ";Extended Properties="; OleDbConnection cn = new OleDbConnection(conn_str);
cn.Open();
OleDbCommand cmd = new OleDbCommand("UPDATE HRMS.LABOR_PHOTO SET "+sFlag+"=? WHERE LABOR_ID=" +int.Parse(LABOR_ID),cn);
cmd.Parameters.Add(sFlag,OleDbType.Binary);