new to pivottable please help

[Pascal Paindavoine]

Hello, i'm quite new to owc.
I'm using visual studio.net and i've installed the office web components on
the toolbox.
I then created an asp.net application with a pivottable on a webpage. I
connected the pivottable to sql server 2000 on the 'pub' database with "SA"
login and selected employees as table. All is going all right when I
access the pivottable on my local webserver but when i try to access my
asp.net page over the internet or a client navigator, i can't catch the
data, pivottable is empty with an error.(sql server not found or security
access deny). SA login exists in sql server 2000 and NT users . CAn Anyone
help ?
forgive my bad english


Pascal

 

[Dan Ricker]

If you are trying via the "Internet" this makes sense. The
SQL Server is probably not visible through the Internet.

If you really need the "Internet" I suggest creating a asp
page that returns MSPersist format XML RecordSet
(RecordSet XML generated by an ADODB.RecordSet object when
saving.

Pivot Can connect to this using:

PivotTable1.ConnectionString = "Provider=MSPersist"
PivotTable1.CommandText = "http://MyServer/MyData.asp"

 

[Pascal Paindavoine]

thanks a lot this is really helpfull
Pascal

If you are trying via the "Internet" this makes sense. The
SQL Server is probably not visible through the Internet.

If you really need the "Internet" I suggest creating a asp
page that returns MSPersist format XML RecordSet
(RecordSet XML generated by an ADODB.RecordSet object when
saving.

Pivot Can connect to this using:

PivotTable1.ConnectionString = "Provider=MSPersist"
PivotTable1.CommandText = "http://MyServer/MyData.asp"