H

I need access to Analisys Services from .NET ...

tr
DataSet myDS
myDS = new DataSet()
string ConnStr
ConnStr ="Provider=MSOLAP;Password=sa;Persist Security Info=True;Data Source=TAMLCS2;Initial Catalog=FoodMart 2000;"
string SQLSelect
SQLSelect = "with member [Measures].[Store Profit Rate] as '([Measures].[Store Sales]-[Measures].[Store Cost])/[Measures].[Store Cost]', format = '#.00%' select {[Measures].[Store Cost],[Measures].[Store Sales],[Measures].[Store Profit Rate]} on columns,Order([Product].[Product Department].members, [Measures].[Store Profit Rate], BDESC) on rows from Sales where ([Time].[1997])"
System.Data.OleDb.OleDbConnection mySqlConn
mySqlConn = new System.Data.OleDb.OleDbConnection(ConnStr)
mySqlConn.Open()
System.Data.OleDb.OleDbDataAdapter mySqlDA
//SqlClient.SqlDataAdapter mySqlDA
mySqlDA = new System.Data.OleDb.OleDbDataAdapter(SQLSelect,ConnS tr)
//.SqlClient.SqlDataAdapter(SQLSelect, ConnStr)
mySqlDA.Fill(myDS)
MyGrid.DataSource = myDS.Tables[0].DefaultView
MyGrid.DataBind()

the error message is : The Database FoodMart 2000 don't exist on lin
mySqlConn.Open()

somebody have any ide

thanks