H

I want to connect to Analisys Services Database from .NET on C

I'm try this simple exampl

DataSet myDS
myDS = new DataSet()
string ConnStr
ConnStr ="Provider=MSOLAP;Password=sa;Persist Security Info=True;User ID=sa;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
mySqlDA = new System.Data.OleDb.OleDbDataAdapter(SQLSelect,ConnS tr)
mySqlDA.Fill(myDS)
MyGrid.DataSource = myDS.Tables[0].DefaultView
MyGrid.DataBind()

The error message is : Database FoodMart don't exist in line : mySqlConn.Ope

I've install on server: SQL Server 2000 sp3, Analisys Services sp3 y Visual Studios .NET 2000 with Framework 1.

somebody have a idea

thanks

perhaps Database FoodMart don't exist
"george" <anonymous (AT) discussions (DOT) microsoft.com> wrote

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])";

what are the database roles, is it still everyone?
I've been able to connect through .net.