oracle安装后怎么连接数据库,安装完odp后，连接oracle数据库

安装完oracle提供的odp后，使用vs2010自带的数据源控件似乎还是连接不上oracle数据库，只能通过代码编写的方式进行关联。首先，在工程中添加ORACLE.DATAACCESS引用,编写代码如下：

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Oracle.DataAccess.Client;

namespace ConsoleApplication3 {     class Program     {         static void Main(string[] args)         {             string connStr = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=jdev)));User ID=hr;Password=hr;";             using (OracleConnection conn = new OracleConnection(connStr))             {                 conn.Open();                 string sql = "select * from jobs";                 using (OracleCommand comm = new OracleCommand(sql, conn))                 {                     using (OracleDataReader rdr = comm.ExecuteReader())                     {                         while (rdr.Read())                         {                             Console.WriteLine("{0} {1} {2:c3}",rdr.GetString(0),rdr.GetString(1),rdr.GetInt32(2));                         }                     }                 }                 conn.Close();             }             Console.WriteLine("Ok!");             Console.Read();         }     } }