我用C#连接Oracle的方法,楼主可以参考下 1、将Provider改为Provider=msdaora, 2、Provide仍然为Provider=OraOLEDB.Oracle.1,但安装Oracle客户端时,必段选择安oledb for windows 3、不用OleDbConnection ,用OracleConnection,这时候连接字串不需要写Provider(OracleConnection是专门为连接ORACLE提供的,推荐使用这种方式)
引用 OracleClientusing System.Data; using System.Data.OracleClient;
OracleConnection conn = new OracleConnection("Data Source=orcl;User Id=system;Password=manager"); conn.Open(); ........ conn.Close();
引用 OracleClientusing System.Data; using System.Data.OracleClient;
OracleConnection conn = new OracleConnection("Data Source=orcl;User Id=system;Password=manager"); conn.Open(); ........ conn.Close();
using System.Data.OracleClient;System.Data.后沒有OracleClient選擇...
这是为什么?
貌似我的连接字符串和http://connectionstrings.com中的一致啊,
可惜还是报错啊
9i的要单独安装oledb的数据访问组件
1、将Provider改为Provider=msdaora,
2、Provide仍然为Provider=OraOLEDB.Oracle.1,但安装Oracle客户端时,必段选择安oledb for windows
3、不用OleDbConnection ,用OracleConnection,这时候连接字串不需要写Provider(OracleConnection是专门为连接ORACLE提供的,推荐使用这种方式)
using System.Data.OracleClient;
OracleConnection conn = new OracleConnection("Data Source=orcl;User Id=system;Password=manager");
conn.Open();
........
conn.Close();
using System.Data.OracleClient;
OracleConnection conn = new OracleConnection("Data Source=orcl;User Id=system;Password=manager");
conn.Open();
........
conn.Close();
using(OracleConnection conn = new OracleConnection("连接字符串"))
{
OracleCommand cmd = new OracleCommand("SQL查询语句", conn);
conn.Open();
OracleDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while(reader.Read())
{
//
}
}
这个网站真不错
OracleConnection myConnect;
OracleCommand myCommand;
string connecstr = @"Data Source=oradb;User Id=user;PassWord=pwd;"; sqlStr = "";
myConnect = new OracleConnection(connecstr);
myCommand = new OracleCommand(sqlStr, myConnect);
myConnect.Open();
OracleTransaction theTrans = myConnect.BeginTransaction();
myCommand.Transaction = theTrans;
")(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = oracle92)));uid=ietest;password=ietest连接数据库这3个属性就够了。