Sunday, February 12, 2012

cannot find dsn

Hello everyone,

This must be too simple to be true but im trying to set up the tutorial cube that comes with analysis manager and ive set up the cube and its dimensions but i cant progress beyond the storage design wizard as it gives me the following error when i try to process it:

[Microsoft][ODBC Driver Manager]Data source name is not found and no default driver specified

why is it that i am able to use this dsn to create the cube but not to process it or create the aggregations in the cube?
Ive set up the dsn exactly as described in the setup dsn pages (Tutorial/setup_sys_datasource.htm) and it has been working fine till this, i can even add further dimensions to the cube, just not process it, whats going on?

with much thanks, in advance, for any input

Amit

further to the above,

after going over my data source information again in analysis manager and starting up the i am now getting the following error message

error (-2147221411)Process operation faile;Time....

again im not sure whats changed or why this is different from the above or even if its closer to normal than the above but again any help will be gratefully appreciated.

Amit

|||

I sorted this by rebuilding the dsn and the cube from scratch, evidently there was something wrong somewhere along the line and it was good practice.

Amit

No comments:

Post a Comment