Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Alzano Lombardo, Italy
    Thanked 0 Times in 0 Posts

    Programming OLAP Databases from Access Using DSO (2003)

    Do you think it's possible to have OlapDemo.mdb working using SQL Server 2005 Express Edition? I opened the file but it misses the reference to msmddo80.dll.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Programming OLAP Databases from Access Using DSO (2003)

    From the article you refer to:
    <hr>Note To program against the Analysis server and to use the procedures in the sample Access database, you need to have SQL Server 2000 Analysis Services installed, either on your local machine or a server, and set a reference (References dialog box, Tools menu) to the Microsoft Decision Support Objects (msmddo80.dll) library.<hr>
    Analysis Services only come with the Standard and Enterprise versions, not with the Express edition. Moreover, you'd need the 2000 version. Perhaps you can use the Microsoft SQL Server 2005 Backward Compatibility Components available from Download details: Feature Pack for SQL Server 2005 Nov 2005.

Posting Permissions

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