第一种 WebConfig 添加配置文件
<add name="aaa" connectionString="XpoProvider=ODPManaged;Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = ip地址)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = 数据库名称)));User ID=username;Password=pwd" />
第二种 代码中编辑
static void Default_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e)
{
if (e.ConnectionName == "aaa")
{
OracleConnectionParameters oracleParams = new OracleConnectionParameters();
oracleParams.ServerName = @"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ip地址) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=数据库名称)))"; 这点是比较重要的
oracleParams.UserName = "用户名";
oracleParams.Password = "密码";
e.ConnectionParameters = oracleParams;
}
}