OWC Connection Error -
12-12-2006
, 08:41 AM
Hi
I'm using pivoteTable from OWC to show a cube from SQL Server 2005. In local
mode works ok, but when the clients from another computer load the ActiveX
component cannot establish a connection with the SQL Analysis Services 9.0,
the following error is raised: "The query colud not be processed: The data
provider didn't supply any further error information" "An error 0x80004005
occurred. No futher information was provided"
Why I'm getting this error?
Thanks =)
Some Additional Information:
WebServer: 10.100.100.19
SQLServer: 10.10.100.40
ConnectionString: Provider=MSOLAP.3;Cache
Authentication=False;Password=telgat;Persist Security Info=True;User
ID=administrator;Initial Catalog=GsmOLAP;Data
Source=10.100.100.40;Impersonation Level=Impersonate;Mode=ReadWrite;Auto
Synch Period=20000;Default Isolation Mode=0;Default MDX Visual Mode=0;MDX
Compatibility=0;MDX Unique Name Style=0;Non Empty
Threshold=0;SQLQueryMode=Calculated;Safety Options=1;Secured Cell
Value=0;SQL Compatibility=0;Compression Level=0;Real Time Olap=False;Packet
Size=4096 |