string oradb = "Data Source=(DESCRIPTION=(ADDRESS_LIST="
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=OTNSRVR)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));"
+ "User Id=scott;Password=tiger;";
OracleConnection conn = new OracleConnection(oradb); // C#
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;cmd.
CommandText = "select dname from dept where deptno = 10";
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read()){
ListBox1.Items.Add("The " + dr.Item(1)
+ " department is in "
+ dr.GetString(0));
}
conn.Dispose();
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=OTNSRVR)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));"
+ "User Id=scott;Password=tiger;";
OracleConnection conn = new OracleConnection(oradb); // C#
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;cmd.
CommandText = "select dname from dept where deptno = 10";
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read()){
ListBox1.Items.Add("The " + dr.Item(1)
+ " department is in "
+ dr.GetString(0));
}
conn.Dispose();
解决方案 »
- 一列转为字符串(用,隔开)的SQL语句
- Parse CPU to Parse Elapsd Execute to Parse 太低 改什么参数,如何调优?
- PHP通过PDO连接Oracle时varchar2字段被截断
- 存储过程 for in loop 循环 报错 无效SQL语句
- 两种返回记录集的方式有什么区别呢?是不是性能或者其它方面有区别?
- 数据转移
- oracle中时间表相减怎么到的具体的间隔?
- 请教(急!!):到哪个网站下载oracle8.1.7的jdbc driver 快一些?
- 高分求解,用C#生成COM+服务(数据库事务处理) 继承ServicedComponent
- 关天developer 2000
- 如何在客户端建立Oracle9i数据库(在线等)
- 如何知道oracle当前事务个数?
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=OTNSRVR)(PORT=1521)))"
+ "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));"
+ "User Id=scott;Password=tiger;";
有谁明白这里的配置吗,怎么总是报错啊