Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2002-03-30 : 03:40:26
|
Hi,Microsoft has given the readymade database of FoodMart for Analysis Services demo.It is in Access.I transfered it in SQL Server, and tried to built the cube, it allows me to create measures, dimensions for fact table. I can browse the data.But when i trys to process the cube it shows me error Data source provider error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified;IM002; why?am i forgetting to do before processing the cube?Thanx in advance---------------------------Sandesh - The Messanger |
|
|
Nungtze
Starting Member
2 Posts |
Posted - 2002-03-30 : 05:25:36
|
| Have you tried to use provider OLEDB for SQL Server in the connection ?Dont use ODBC, but use OLEDB instead. I think it will solve the problem. |
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-03-30 : 05:33:46
|
| Nungtze,Thanx a lot.....its working perfactly..Thanx again---------------------------Sandesh - The Messanger |
|
|
|
|
|
|
Connecting to SQL Server Database