Oracle数据库连接
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 ones 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
{
///
/// webform1 的摘要说明。
///
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();
}