Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2006
    Posts
    3

    Unanswered: 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/b3...ageproblem.png

    And the version Screenshot:
    http://i23.photobucket.com/albums/b3...geproblem2.png

  2. #2
    Join Date
    Apr 2006
    Posts
    3
    Reason 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.
    Last edited by fredarin; 04-10-06 at 16:25.

  3. #3
    Join Date
    Apr 2006
    Posts
    13
    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

  4. #4
    Join Date
    Apr 2006
    Posts
    3
    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.

  5. #5
    Join Date
    Oct 2009
    Posts
    5

    hi

    i am getting error in analysis services when i am trying to open mdx samples and also i have created cubes, i am not able to browse the cube details in cube browser it shows the error ie., unspecified error

  6. #6
    Join Date
    Oct 2009
    Posts
    5
    s, i am already installed MS access

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Read the error message, it ought to explain or at least identify the problem and might also suggest a solution.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  8. #8
    Join Date
    Oct 2009
    Posts
    5

    Analysis Services - Unable to open connection

    When i am trying to open analysis services mdx Sample application it dispalys the error like
    "Unable to open connection
    Provider cannot be found. It may not be properly installed"

    so what to do next?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •