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