我正在尝试连接到一个Oracle数据库,但当代码执行以下行时:
con = new OracleConnection(oradb);
它提示以下错误:"程序无法启动,因为您的计算机缺少oraons.dll文件。请尝试重新安装程序以解决此问题。" 我已从以下网站http://www.oracle.com/technetwork/topics/dotnet/index-085163.html下载并安装了ODP.NET,也已经引用了Oracle.DataAccess。我还检查了安装的文件夹,发现oraons dll位于其中。这是代码:
class OracleDatabase
{
OracleConnection con;
public void ConnectToOracleDb()
{
string oradb = getConnectionString("host", 1521, "sid", "user", "pass");
try
{
con = new OracleConnection(oradb);
con.Open();
Console.WriteLine("Connected to Oracle" + con.ServerVersion);
}
catch
{
Console.WriteLine("Could not connect to FLX");
}
}
private static string getConnectionString(string databaseIP, int databasePort, string databaseSID, string databaseUN, string databasePW)
{
return string.Format(
"Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = {0})(PORT = {1}))(CONNECT_DATA =(SID = {2})));" +
"Persist Security Info=True;User ID={3};Password={4}",
databaseIP, databasePort, databaseSID, databaseUN, databasePW
);
}
}
为什么我无法连接?有什么建议吗?