连接oracle数据库出现了问题

[cstudying]

string strConn="Data Source=Oracle8i;Integrated Security=yes";

string strSql = "SELECT DEC_PORT AND TRADE_NAME FROM DEC_I_HEAD WHERE CUSTOM_MASTER = '长沙'";
DataSet ds = new DataSet();
OracleConnection conn = new OracleConnection(strConn);
conn.Open();
OracleDataAdapter adapter = new OracleDataAdapter(strSql, conn);
adapter.Fill(ds);
dataGrid1.DataSource = ds.Tables[0];


出现错误:




未处理的“System.Data.OracleClient.OracleException”类型的异常出现在 system.data.oracleclient.dll 中。

其他信息: ORA-12154: TNS: 无法处理服务名



我所做的是想把查询所得的值显示在一个 datagrid中
请高手指点 帮忙,谢谢

[cstudying]

晕 怎么没有人理我呢

[zxf_hay]

string ConnectionString="Provider=OraOLEDB.Oracle;Data Source=mydb;User Id=system;password=manager;";

try this

[singlepine]

http://www.connectionstrings.com/

Data Source=MyOracleDB;User Id=username;Password=passwd;Integrated Security=no;

[yanlixin4csdn]

sqlplus 能连上吗?
tns 的错误.确认一个tns

///*************************///
这两年来慢慢习惯了光说不练
///*************************///

[swordragon]

string strQuery1 = "";

string strConnection = "Data Source=xxx;User Id=xxx;Password=xxx";

DataSet objDateSet = new DataSet();

SqlConnection conn = new SqlConnection(strConnection);
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(strQuery1, conn);
adapter.Fill(objDateSet,"Table1");

adapter.Close();
conn.Close();

DataGrid1.DataSource = objDateSet;
DataGrid1.DataBind();

[cstudying]

string strConn = "Data Source = ora8;User Id = offline_dec;Password = dbwork;Integrated Security = yes ";

string strSql = "SELECT DEC_PORT AND TRADE_NAME FROM DEC_I_HEAD WHERE CUSTOM_MASTER = '湛江'";

OracleConnection myConnection = new OracleConnection(strConn);
OracleCommand myCommand = new OracleCommand(strSql,myConnection);
myConnection.Open();
|> DataSet dataSet1 = new DataSet();
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~错误提示行
OracleDataAdapter adapter = new OracleDataAdapter(myCommand);
adapter.Fill(dataSet1);
myConnection.Close();
错误内容：

未处理的“System.Data.OracleClient.OracleException”类型的异常出现在 system.data.oracleclient.dll 中。

其他信息: ORA-12541: TNS: 没有监听器

[cstudying]

我可能知道
了 因为 数据库 没有启动的原因吧:(
我没有权限启动

[cstudying]

提示错误 TNS:没有监听器

绿色的指示在这 OracleConnection conn = new OracleConnection(strConn);

是 怎么回事情呢?

strConn = "Data Source=mydb;User Id=system;Password=manager;Integrated Security=yes";

我看不出哪儿错了呀

[swordragon]

strConn = "Data Source=mydb;User Id=system;Password=manager;Integrated Security=yes";
+++++++++++++++

你使用sqlplus连接一下db，看看是否可以？