刚学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();
代码如下: 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();
这一句话真值钱。普通用户是能连上,能不能用管理员连接呢?