好像還不能打開ORACLE的數據庫
執行下面代碼出錯﹐錯誤如下﹕,hr_hrhr是一個連上Oracle的ODBC的DSN例外詳細資訊: System.NotSupportedException: .Net Data OLE DB Provider(System.Data.OleDb) 未支援 MSDASQL Provider,Microsoft OLE DB Provider for ODBC Drivers。
String strCn = "Provider=msdasql.1;DSN=hr_hrhr;uid=ems;pwd=ems";
OleDbConnection myCn = new OleDbConnection(strCn);
myCn.Open();
執行下面代碼出錯﹐錯誤如下﹕,hr_hrhr是一個連上Oracle的ODBC的DSN例外詳細資訊: System.NotSupportedException: .Net Data OLE DB Provider(System.Data.OleDb) 未支援 MSDASQL Provider,Microsoft OLE DB Provider for ODBC Drivers。
String strCn = "Provider=msdasql.1;DSN=hr_hrhr;uid=ems;pwd=ems";
OleDbConnection myCn = new OleDbConnection(strCn);
myCn.Open();
using System;
using System.Data;
using System.Data.OleDb;class OracleTest
{
static void Main()
{
const string strConn = "PROVIDER=OraOLEDB.Oracle;DATA SOURCE=YourDataSrcName;USER ID=YourUID;PASSWORD=YourPassword;PLSQLRSet=1"; const string strSQL = "Select * From YourTable"; try
{
OleDbConnection dbConn = new OleDbConnection(strConn);
DataSet ds = new DataSet("EmployeesSet");
OleDbDataAdapter da = new OleDbDataAdapter(strSQL,dbConn);
da.Fill(ds,"Buyer");
Console.WriteLine(ds.GetXml());
}
catch(OleDbException e)
{
Console.WriteLine("Exception Occured :{0}",e.Errors[0].Message);
}
}
}
或改用MICROSOFT提供的驱动程序