private string get_Create_DBLinkStr()
{
StringBuilder sb = new StringBuilder();
sb.Append("create database link ");
sb.Append(this._c_linkname.Value);
sb.Append(" CONNECT TO ");
sb.Append(this._c_username.Value);
sb.Append(" IDENTIFIED BY \"");
sb.Append(this._c_password.Value);
sb.Append("\" using '");
sb.Append("(DESCRIPTION=(ADDRESS=(TCP)(HOST=");
sb.Append(this._ipaddress.Value);
sb.Append(")(PORT = 1521))");
sb.Append("(Connect_Data=(");
sb.Append(this._c_servicename.Value);
sb.Append(")))';");
return sb.ToString();
}
private bool create_DBLink()
{
try
{
OracleConnection oc = new OracleConnection(ConfigurationManager.ConnectionStrings["155"].ConnectionString);
oc.Open();
//OracleParameter op=new OracleParameter("DBLINK",OracleType.VarChar);
//op.Value = get_Create_DBLinkStr();
OracleCommand t_oc = new OracleCommand(get_Create_DBLinkStr(), oc);
//t_oc.CommandText = "";
//t_oc.CommandType=CommandType.StoredProcedure;
//t_oc.Parameters.Add(op);
t_oc.ExecuteNonQuery();
oc.Close();
return true;
}
catch
{
return false;
}
}"create database link whatup connect to test identified by \"1234\"using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.1)(PORT = 1521)) )(CONNECT_DATA = (SERVICE_NAME = orcl) ) )'"
这个拼接出来的ExecuteNonQuery()时报错无效字符
public string DBLinkString
{
get
{
String dbls = "create database link {0} connect to {1} identified by \"{2}\"" +
"using '(DESCRIPTION = (ADDRESS_LIST = " +
"(ADDRESS = (PROTOCOL = TCP)(HOST = {3})(PORT = {4})) )" +
"(CONNECT_DATA = (SERVICE_NAME = {5}) ) )'";
try
{
}
catch { }
return string.Format(dbls, "whatup", this._c_username.Value, this._c_password.Value, this._c_ipaddress.Value, "1521", "orcl");
} } private bool create_DBLink()
{
try
{
OracleConnection oc = new OracleConnection(ConfigurationManager.ConnectionStrings["155"].ConnectionString);
oc.Open();
//OracleParameter op=new OracleParameter("DBLINK",OracleType.VarChar);
//op.Value = get_Create_DBLinkStr();
OracleCommand t_oc = new OracleCommand(DBLinkString, oc);
//t_oc.CommandText = "";
//t_oc.CommandType=CommandType.StoredProcedure;
//t_oc.Parameters.Add(op);
t_oc.ExecuteNonQuery();
oc.Close();
return true;
}
catch
{
return false;
}
}
create database link whatup connect to test identified by "1234"using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.85.151)(PORT = 1521)) )(CONNECT_DATA = (SERVICE_NAME = orcl) ) )'
这个是string拼的,ExecuteNonQuery()却不报错。。 2个字符串一样的东西到了ExecuteNonQuery()一个过,一个不过,我弄了1个小时了。无奈了发贴求助!
解决方案 »
- SOCKET实现传输多个文件,解决方案
- 请问使用http post做为服务器接口是什么意思呀?
- 引用控件的问题 高人人帮帮我吧!
- .Net Framework 2.0和3.5可以装在一起吗?
- C#与C++之间的调用问题
- WinForm 进度条,加载数据 时间长,
- 请问:C#入门经典(清华大学出版社)的,这本书怎么样?
- C# 绘图的一个问题 有代码
- 请问大家,我想用C#做一个IP地址输入框,就像WINDOWS中的网络属性中的一样,但不知如何下手,请高手讲讲吧
- 部署时,文件系统-用户的“程序”菜单中需要些什么??
- 求一个C#写的通过调用WinAPI来实现的连接VPN的一段代码~
- 请求API问题,FindWindow得到的窗口后,怎么移动
单步查询数据
而get_Create_DBLinkStr()拼接出来的却过不了,2个一模一样的,为什么出这样的事呢???
谢谢您的醒言~