I have had success using the following syntax.   It is the same syntax as used in SSMS.

Glad it's working for you.

I know the frustrated feeling myself.  I spent a lot of time trying to determine how to get a local cube built in Excel from an...

Yes, OWC 10 is a free download that works with either Office 2000 or Office XP.  Following is a link to the download page:

http://www.microsoft.com/downloads/details.aspx?FamilyID=982b0359-0a86-4fb2-a7ee-5f3a499515dd&DisplayLang=en

If that link doesn't work, go...

I was able to duplicate your problem, I think.  I did it by designing a page using Frontpage 2000 that I have installed on a Win98 machine.  I then copied...

Well I'm confused.  I thought that the "Web Analysis" you were referring to was the ability to use HTTP to tunnel through a firewall.  Based on what I read on...

You need to make a change on the Connection tab of the Data Link Properties.

Instead of putting localhost in the Data Source, leave the Data Source blank and put your...