我记得数据库别名的前后需要加双引号,试试
str="Data Source=""ptest"";Persist Security Info=True;User ID=ld123;Password=ld123;Unicode=True;Min Pool Size=10;Connection Lifetime=120;Max Pool Size=50;";
str="Data Source=""ptest"";Persist Security Info=True;User ID=ld123;Password=ld123;Unicode=True;Min Pool Size=10;Connection Lifetime=120;Max Pool Size=50;";
解决方案 »
- 通过java往oracle中blob字段写入数据
- 如何剔除重复的记录
- 急求一个数据更新的SQL语句
- sql*plus替代变量代码块求组!
- Oracle(10g)安装正常,计算机重启后就出现ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- oracle 多个表的查询问题
- linux8+oracle9.2.0安装好了后,工具界面里面不能输入字符,谢谢指教;急!
- 在线等待(100分):怎样用oo4o获得long raw型字段中数据的长度
- Oracle 12c Database Configuration Assistant 失败
- ORACLE常用的软件有哪些啊
- oracle用户修改密码后,连接不上数据库
- 这个查询语句如何修改,才能在存储过程中使用
public String GetOracleConnection(string ID, string Password, string SeverAddress)
{
return "Provider=MSDAORA.1;password=" + Password + ";user id=" + ID + ";data source= " + Strings.Chr(34) + SeverAddress + Strings.Chr(34) + ";persist security info=True ";
}
//调用方式
str=GetOracleConnection("ld123","ld123","ptest");
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.187)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=test)))
还是不行,会不会是权限问题额
{ string connectstring = XMLHelp.Instance.GetConnectString();
currenConn = new OracleConnection(connectstring);
if (currenConn.State == ConnectionState.Closed) { currenConn.Open(); }
return currenConn; }
public string GetConnectString()
{
string oraServer = GetValueByNodeName("DataServer");
string oraBase =GetValueByNodeName("DataBase");
string oraName = GetValueByNodeName("UserName");
string oraPwd = GetValueByNodeName("Pwd");
//string connecString = string.Format(@"Data Source={0};Persist Security Info=True;User ID={1};Password={2};Unicode=True;Min Pool Size=10;Connection Lifetime=120;Max Pool Size=50; ", "\""+oraBase+"\"", oraName, oraPwd);
string connecString = GetOracleConnection(oraName, oraPwd, oraBase);
return connecString;
}
public string GetOracleConnection(string ID, string Password, string SeverAddress)
{
return "password=" + Password + ";user id=" + ID + ";data source= " + Convert.ToChar(34) + SeverAddress + Convert.ToChar(34) + ";persist security info=True ";
}
2、换成(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.187)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=test)))试试
感觉有可能是没走你的tns配置文件
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
)
)
本机服务器配置如下:
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
)
)