I'm trying to connect to an OLAP database with ADO. The following works:

"Provider=MSOLAP;Data Source=localhost;Initial Catalog=FoodMart 2000"

The following (that reference another system) fail with
System.Runtime.InteropServices.COMException, "Unspecified error":

"Provider=MSOLAP;Data Source=192.168.128.53;Initial Catalog=FoodMart 2000"
"Provider=MSOLAP;Data Source=192.168.128.53;Integrated
Security=SSPI;Initial Catalog=FoodMart 2000"
"Provider=MSOLAP;Data Source=192.168.128.53;User
Id=sa;Password=xxxx;Initial Catalog=FoodMart 2000"

The other system produces the exact same symptoms. It can connect
locally but not remotely. This implies that the problem isn't the system.

I've tried non .NET code; same result.
I've tried a provider of MSOLAP.2; same result.

Any ideas? This seems so basic. I'm surprised I don't see other users
hitting this issue.

hi,

try using this

Set cat = Server.CreateObject("ADOMD.Catalog")
Set cst = Server.CreateObject("ADOMD.CellSet")

OLAPServerName = "computer name"
cat.ActiveConnection = "Data Source=" &
OLAPServerName & ";Initial Catalog=foodmart
2000;Provider=msolap;"



This may help u to solve ur problem.

bye,