日期:2014-05-17  浏览次数:20654 次

关于连接oracle数据库的问题
刚学oracle用c#连接的时候出现ORA-28009: connection to sys should be as sysdba or sysoper这个错误请问是什么情况啊?查百度没弄明白求指导……
代码如下: static void Main(string[] args)
  {

  OleDbConnection conn= new OleDbConnection
  ("Provider=oraoledb.oracle.1; Server=localhost;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PC-201009061653)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User ID=sys;Password=sys;SERVICE_NAME = orcl");
  conn.Open();
  OleDbCommand comm=new OleDbCommand("select * from scott.emp",conn);
  OleDbDataReader dr=comm.ExecuteReader();

  dr.Close();
  conn.Close();

------解决方案--------------------
换成普通用户连接