Oracle数据库连接

王朝oracle·作者佚名 2006-01-09

宽屏版字体: 小|中|大|超大

ODBC

New version:

"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"

Old version:

"Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"

OLEDB, OleDbConnection (.NET)

Standard security:

"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"

This one's from Microsoft, the following are from Oracle

Standard Security:

"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"

Trusted Connection:

"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"

OracleConnection (.NET)

Standard:

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

This one works only with Oracle 8i release 3 or later

Declare the OracleConnection:

C#:

using System.Data.OracleClient;

OracleConnection oOracleConn = new OracleConnection();

oOracleConn.ConnectionString = "my connectionstring";

oOracleConn.Open();

VB.NET:

Imports System.Data.OracleClient

Dim oOracleConn As OracleConnection = New OracleConnection()

oOracleConn.ConnectionString = "my connectionstring"

oOracleConn.Open()

Data Shape

MS Data Shape:

"Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"

例子1：namespace oracle

{

/// <summary>

/// WebForm1 的摘要说明。

/// </summary>

public class WebForm1 : System.Web.UI.Page

{

protected System.Web.UI.WebControls.DataGrid DataGrid1;

private DataSet myDataSet = new DataSet();

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

string connstring="Provider=OraOLEDB.Oracle;Data Source=jtest;User Id=system;Password=manager;";

OleDbConnection conn=new OleDbConnection(connstring);

string strcom = "select * from system.LG_TASK_TABLE";

conn.Open();

OleDbDataAdapter mycommand = new OleDbDataAdapter(strcom,conn);

mycommand.Fill(myDataSet,"system.LG_TASK_TABLE");

DataGrid1.DataSource = myDataSet.Tables["system.LG_TASK_TABLE"].DefaultView;

DataGrid1.DataBind();

conn.Close();

}