一、安装oracle客户端程序
如果是windows版本可以到这里下载
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
配置环境变量
一共设置以下三个环境变量(以解压缩目录c:\instantclient为例)
环境变量名 变量值
path c:\instantclient
TNS_ADMIN c:\instantclient
NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK
创建C#控制台项目.首先引用system.oracle.dll.
下面是一个数据库连接类DbConn.
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OracleClient;
namespace folokmanager
{
class DbConn
{
private String Source;
private String UserID;
private String Password;
public DbConn()
{
//数据源字符串其中192.168.1.21是你oracle数据库的机器ip,port是你oracle数据库的端口号,home2是你oracle数据库的服务名
Source = "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.21)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=home2)))";
UserID = "system"; //用户名字符串
Password = "a1b2c3d4"; //密码
}
public OracleConnection GetConn()
{
OracleConnection OracleConn = new OracleConnection("Data Source=" + Source + "; User Id=" + UserID + ";Password=" + Password + ";Integrated Security=no;");
OracleConn.Open();
return OracleConn;
}
}
}