Hi,
I'm trying to connect to Oracle TimesTen database using c# .net and having problem. The error is "ORA-29158: Unable to open library". However, it works fine when I use SQL Developer to access.
The error is when it called [login to view URL]();
Any idea? I think I missed configuration some where.
Thanks,
LT
------------------------------------------------------
db = "mytns_sampledb_1121";
user = "appuser";
pwd = "mypassword";
count++;
try
{
string connStr = "Data Source=" + db + ";user id=" + user + ";password=" + pwd + ";Statement Cache Size=0";
OracleConnection conn = GetConnection(connStr);
//To fill DataSet and update datasource
OracleDataAdapter productsAdapter = new OracleDataAdapter();
//In-Memory cache of data
DataSet productsDataSet;
//Fetch Product Details
[login to view URL] = new OracleCommand("SELECT * FROM PRODUCT", conn);
//Instantiate DataSet object
productsDataSet = new DataSet("productsDataSet");
//Fill the DataSet with data from 'Products' database table
[login to view URL](productsDataSet, "PRODUCT");
[login to view URL]("Completed");
}
catch (Exception ex)
{
}
------------------------------------------------------
public OracleConnection GetConnection(String connStr)
{
OracleConnection con = new OracleConnection();
[login to view URL] = connStr;
[login to view URL]();
return con;
}