R
robert.chapman
I'm somewhat stumped by how I get a Pivot Table Web component to
connect to the SQL database on our shared hosting providers web server.
I use Front Page on my local machine and "open" our website remotely so
I in effect edit the pages "live" (I know I know). If I create a new
ASP page and insert a Pivot Table web component I need to connect it to
the datasource. The issue appears to be that because the SQL Server DB
is behind the firewall at the host it can only be accessed from IIS
when the pages are active and not when I am editing them. This however
prevents one from carrying on with the Pivot Table wizard because it
needs to see the data to manipulate it prior to saving the page.
Any ideas how you get round this?
Robert.
connect to the SQL database on our shared hosting providers web server.
I use Front Page on my local machine and "open" our website remotely so
I in effect edit the pages "live" (I know I know). If I create a new
ASP page and insert a Pivot Table web component I need to connect it to
the datasource. The issue appears to be that because the SQL Server DB
is behind the firewall at the host it can only be accessed from IIS
when the pages are active and not when I am editing them. This however
prevents one from carrying on with the Pivot Table wizard because it
needs to see the data to manipulate it prior to saving the page.
Any ideas how you get round this?
Robert.