DbConnection = new OleDbConnection(
"Provider=MSDAORA;data source=oracledb;user id=bill; password=bill;");DbConnection.Open();
打开数据库时报“此内存只能为READ”,为什么?
"Provider=MSDAORA;data source=oracledb;user id=bill; password=bill;");DbConnection.Open();
打开数据库时报“此内存只能为READ”,为什么?
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;"
using System.Data.OracleClient;...OracleConnection conn = new OracleConnection();
conn.ConnectionString = "Data Source=xxx.world;User ID=yyy;Password=zzz";
conn.Open();OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select a, b, c from table";OracleDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
...
}
dr.Close();
conn.Close();
conn.ConnectionString = "Data Source=oracledb;User ID=bill;Password=bill;Persist Security Info=False;";
conn.Open();还是报“DLL OCI.DLL中找不到名为OCIECreate的人口点”,为什么???