服务器端Oracle:
1.ORA-12505 : listener未开启(能连上SQL*PLUS但连不上SQL Developer)
解决:双击 安装盘:/app/Admin/product/11.2.0/dbhome_1/BIN/emca.bat
2. ORA-12541:TNS: 无监听程序(VS2010在open()时通不过,提示错误)
解决:http://jingyan.baidu.com/article/03b2f78c7a0ab75ea237ae33.html
VS2010:
先下载链接Oracle 11g所需的驱动ODTwithODAC1120320_32bit,下载链接为http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
using Oracle.DataAccess.Client;
using System.Data;
string connectionString;
string queryString;
// 连接字符串1 (未测试)
//connectionString = "Data Source=192.168.1.106/orcl;User ID=scott;PassWord=***";
// 连接字符串2 (测试通过)
connectionString = "Data Source=(DESCRIPTION="+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.106)(PORT=1521))" +
"(CONNECT_DATA=(SERVICE_NAME=ORCL)));" + "User Id=scott;Password=***;";
queryString = "SELECT * FROM DEPT";
OracleConnection myConnection = new OracleConnection(connectionString);
OracleCommand myORACCommand = myConnection.CreateCommand();
myORACCommand.CommandText = queryString;
myConnection.Open();
OracleDataAdapter oraDA = new OracleDataAdapter(myORACCommand);
DataSet ds = new DataSet();
oraDA.Fill(ds);
this.GridView1.DataSource = ds.Tables[0].DefaultView;
this.GridView1.DataBind();
myConnection.Close();