OWC11 Pivot Table : Data provider didn't supply any further error

[Skinnerfritz]

The Pivot table displays the "data provider.." message from some computers.
In this case the underlying script error reads, "ActiveX componenet can't
create object". Also, the problematic line is the xml containing the
connection string.

However, the pivot tables are working perfectly for other computers - while
using the same connection info.

The client-side script used to create the pivot table leverages the XMLData
property. where the xml given to this property has the connectionstring
embedded in it. The datasource is a server running AS2005.

Pings to the AS2005 server containing the data are successful from the
problematic computers.

Using sql profiler to trace the requests to the AS2005 server from the
problematic computers display nothing.

Though it seems AS2005 denying the request, my problem is identifying the
issue.

Any troubleshooting suggestions to identify what the issue is?

Thanks much,
Fritz Skinner

 

[Skinnerfritz]

There were two aspects to this problem.

1) the users did not have the AS OLE DB 9.0 driver installed.

Solution: In order to communicate with AS2005 server our clients are
required to install the AS OLE DB 9.0 driver.

2) Client machines are not on our domain network.

Solution: configure http access to communicate with AS2005. Link below
references what was for me a very helpful article.
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

Thanks to those that considered this post.
Fritz