Hi all;
I am developper and i want to connect my application to essbase database. This the code I have:
string connectionString = string.Empty;
connectionString = "Provider=MSOLAP;Data Source=http://192.168.24.4:19000/aps/XMLA; Initial Catalog=MaBase;User Id=admin;Password=admin123;Timeout=60000;";
string query = "SELECT ...";
AdomdDataReader reader = null;
try
{
using (AdomdConnection conn = new AdomdConnection(connectionString))
{
conn.Open();
using (AdomdCommand cmd = new AdomdCommand(query, conn))
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader.GetString(0));
Console.WriteLine(reader.GetString(1));
}
Console.WriteLine("fin");
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}