Thursday, February 16, 2012

Analysis Services: Data source provider error

Trying to go through the Analysis Services tuturial. Logged in as Administrator on a 64 bit W2K server. SQL Server 2000 AS and SP4.

As I come to the Design Storage step I get a message saying
Data source provider error: ; Time:2006-04-10 19:51:47
There are no further details given and the Event Logger has nothing.

Grateful for any help.

Screenshot: http://i23.photobucket.com/albums/b366/biund/sql/DesignStorageproblem.png

And the version Screenshot:
http://i23.photobucket.com/albums/b366/biund/sql/DesignStorageproblem2.pngReason was probably that I defined the data source as a User DSN. Should have been System DSN.

I opted to use Jet instead or the Access driver - solved it.|||I'm just starting out with Analysis Services. Also new working with databases. A friend of mine sent me a couple of Databases and they are files with .mdf file extensions. When I try and setup datasource in the control panel wizard, there are no drivers with the .mdf extensions. Just .dbo and others.

Could you explain to me what I need to do to get AS to work with my databases?

Thanks in advance,
Milfredo|||No idea how the drivers are distributed, but I guess installing MS Access will do it. Probably instaling Analys Services includes driver installation.

I am more of a unix guy, so do not trust me. :D

No comments:

Post a Comment