Question

C#的.NET网站，怎样用odbc连接oracle数据库，这种方式稳定吗？

如题。
请提供详细的代码，谢谢

Answer 1

没有用这样的。我喜欢用app.config写连接字符串

Answer 2

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;"

OLE DB, OleDbConnection (.NET)

Standard security:

"Provider=msdaora;Data Source= MyOracleDB;UserId=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();

Answer 3

专业做法：

可以将connstring写进web.config里面调用

代码=====================================
string connstring="Data Source=instancename;user id=username;password=password";
string cmdstring = "insert into testtable(name) values('haha')";
OracleConnection connection = new OracleConnection(connstring);
OracleCommand myOracleCommand = new OracleCommand(cmdstring, connection);
connection.Open();
myOracleCommand.ExecuteNonQuery();
connection.Close();
//===================================