I am trying to use the Office 2000 Pivot table control and SQL Analysis

Server. When opening the page from within my domain everything works

fine but when outside users are trying to open it they can'e see the

server, I am assuming this is because it is trying to find the server in

their domain, not mine. Why do the office web controls run at the

client? Is there a way to change this? I have the same problems when

trying to use a cube as the Data source. Hard coding the IP Address of

the server doesn't seem to make a difference either. Here is the code



<script language=3DVBScript>

'Pivottable1 =3D name of activex control

sConnection =3D "PROVIDER=3Dmsolap;DATA SOURCE=3DMyServer;USER

ID=3Dguest;PASSWORD=3D;INITIAL CATALOG=3DMyDatabase;"



set adocon =3D createobject("ADODB.Connection")

adocon.ConnectionString =3D sConnection

Pivottable1.ConnectionString =3D sConnection



adocon.Open

Pivottable1.DataMember =3D "MyCube"



</script>





When I am in my domain it works great, everything connects

etc.



When outside the domain I.E. using it as a INTERnet site I

get an Either EOF or BOF error on the last line

(Pivottable1.DataMember =3D "MyCube")



Any Ideas??