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

    Exclamation Unanswered: 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

    Thanks
    Attached Files Attached Files
    bigfoots

  2. #2
    Join Date
    Feb 2004
    Posts
    4

    Re: analysis service

    Originally 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.

  3. #3
    Join Date
    Oct 2003
    Posts
    232

    i have already upgraded

    Hi

    I have already upgraded with the patch but still does not work
    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
  •