Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    232

    Arrow Unanswered: analysis service connection to access database

    Hi

    I was doing steps on page 15 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

    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
    Attached Files Attached Files
    bigfoots

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    have you applied service pack 3 for analysis services? If you have you might reapply MDAC 2.8, if not, apply it.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Oct 2003
    Posts
    232
    It still did not work for i already had those things there
    bigfoots

Posting Permissions

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