analysis service

Hi

I was doing steps on page 15 / 16 of attached sheet

I was doing the microsoft example about cube to setup DSN SOURCE CONNECTION to ACCESS database (food mart) when i do a test it works

but after i do design storage and go to Process the cube
it gives me error

'test connection failed because of an error in initializing provide
(microsoft) ODBC DRIVER manager data source name not found and no default driver specified

one more error found
Microsoft ODBC DRIVER MANAGER driver sql connect attr failed: IMOO6

ThanksOriginally posted by sjumma
Hi

I was doing steps on page 15 / 16 of attached sheet

I was doing the microsoft example about cube to setup DSN SOURCE CONNECTION to ACCESS database (food mart) when i do a test it works

but after i do design storage and go to Process the cube
it gives me error

'test connection failed because of an error in initializing provide
(microsoft) ODBC DRIVER manager data source name not found and no default driver specified

one more error found
Microsoft ODBC DRIVER MANAGER driver sql connect attr failed: IMOO6

Thanks

Ensure you have applied SP3. I'm pretty sure there is an MDAC upgrade.|||Hi

I have already upgraded with the patch but still does not work