1. 安装oracle客户端,连接oracle
需要在客户端%oracle_client_home%network/admin/配置tnsnames.ora,以服务名aa为例,客户端和服务器服务名及连接串需要保持一致。服务名的配置实例如:
a =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = helen)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = a)
)
)
程序代码:
String connOra = "Data Source=a;User ID=a;password=a;Unicode=True";
OracleConnection conn = new OracleConnection(connOra);
conn.Open();
if (conn.State == ConnectionState.Open)
Response.Write("DataOracle.aspx conn open success");
else
Response.Write("DataOracle.aspx conn open failure");
2.不安装oracle客户端,连接oracle
不需要配置tnsnames.ora,把主机、端口、数据库ID(SID)写入连接字符串,其他连接同上。
新的连接字符串为:Data Source= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = helen)(PORT = 1521))) (CONNECT_DATA = (SID= a) ));User ID=a;password=a;Unicode=True