c#连接oracle数据库

最新推荐文章于 2024-09-22 13:49:16 发布

weixin_30809333

最新推荐文章于 2024-09-22 13:49:16 发布

阅读量30

点赞数

文章标签：网络数据库

原文链接：http://www.cnblogs.com/missheyo/p/10106751.html

版权

连接字符串

public static string connString = "User ID=DatabaseName;Password=OraclePwd;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = IPAddress)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))";

引用命名空间

using Oracle.ManagedDataAccess.Client;

连接方法

public int GetConn()
{
OracleConnection conn = new OracleConnection(connString);
int result = 0;
try
{
conn.Open();
result = 1;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
conn.Close();
}
return result;
}