去找Operate吧。应该是继承的。
在ASP.Net中与oracle数据库连接出错问题
OracleCommand cmd = new OracleCommand("
select * from dept;
"
,conn);
"
select * from dept"
,不要分号!
OracleCommand cmd = new OracleCommand("
select * from dept"
,conn);
select * from dept;
"
,conn);
"
select * from dept"
,不要分号!
OracleCommand cmd = new OracleCommand("
select * from dept"
,conn);
ASP连接oracle数据库
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DIZZY)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
改成
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库ip地址)(PORT = 1521))
(CONNECT_DATA =
(sid = orcl)）
)
==================================================
'
dns="
Driver={Microsoft ODBC for Oracle};
UID=user;
PWD=pwd;
server=10.128.64.7"
改成 dns="
Driver={Microsoft ODBC for Oracle};
UID=user;
PWD=pwd;
server=orcl"
可以了，通过测试
dns="
Driver={Microsoft ODBC for Oracle};
UID=user;
PWD=pwd;
server=10.128.64.7"
改成 dns="
Driver={Microsoft ODBC for Oracle};
UID=user;
PWD=pwd;
server=orcl"
可以了，通过测试
