Hi all!

I have the following problem: I have written an asp.net web application that
uses an ADODB ConnectionClass to create a local cube file by using CREATE
CUBE statement. When opening the ADODB connection by passing the CREATE CUBE
statement as connection string, an error is risen telling me "Data provider
not found. Maybe it's not correctly installed". To reproduce the problem and
for testing issues, I created a simple console application that executes the
same code as my web application. After installing PTS (ptslite.exe from SQL
Analysis Services SP3a), the console application run without problems while
the web application still doesn't work. The error message that is thrown
still tells me "data provider not found".

The Provider property of the ConnectionClass instance is set to "MSOLAP.2",
the DSN for the CREATE CUBE statement also uses "MSOLAP.2" as data provider.

As the console application runs, I assume it's a permissions issue. Any
ideas what might be the problem?


Thanks

Markus

Hi Markus,

I would check your data access files with the component checker and if you
got mismatches upgrade or re-install MDAC. Preferable MDAC2.7sp1.

You can download these from:
http://msdn.microsoft.com/library/de...ist/dataaccess
asp

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."