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

Cannot find ODBC drivers

I'm using dreamweaver to create a site, and I am trying to get a database to work with it. I'm using asp and to connect to the dsn i need odbc drivers. When i open the box to set up the connection, none are listed. however, when i tried to install mdac 2.8, it said it could not install because it is already running on my system. Where are my drivers? help please!Which ODBC driver are you using?|||im not using any because i don't have any. i.e. when i go to control panel, administrative tools, data sources, then tab over to File DSN, then click add, and the Create a New Data Source window comes up, there are no drivers in the window.how do i get them there?|||

Some third party software may delete all the odbc driver information incorrectly during uninstalling.

Please try run the following four commands to re-register all the default odbc drivers:

odbcconf.exe /S /Lv odbcconf.log /F %systemroot%\system32\mdaccore.rsp
odbcconf.exe /S /Lv odbcconf.log /F %systemroot%\system32\sqlclnt.rsp
odbcconf.exe /S /Lv odbcconf.log /F %systemroot%\system32\odbcconf.rsp
odbcconf.exe /S /Lv odbcconf.log /F %systemroot%\system32\redist.rsp

|||wow, it worked! thank you so much, you are a genius!|||now i can see all the drivers, so i created a dsn using administrative tools. i used the microsoft access driver. when i try to connect to this dsn in dreamweaver, i get "Unknown error 0x800A0E7A. Provider cannot be found. It may not be properly installed" does that have anything to do with my original problem? Can you help me again please?!|||Are you using the Jet driver? Suggest you post another thread in this forum for the quesiton as i am not a jet expert. Maybe someone else can help you on it. :)