Pivot table client dependicies

[Ivan]

For the last couple months I have been working with Pivot
Tables to create a dashboard. I use OCW11, Office 2003 in
an ASP page connecting to an Oracle 9i database.

While all works dandy, on my local machine I know that
people I'm going distribute need to have the Office Web
Components installed which is no problem but it also seems
that they need an Oracle Client access on there machine.

Is it there anyway that I can provide the ASP to clients
without having them to depend on a local datasource?

Thanks,
Ivan

 

[Alvin Bruney [MVP - ASP.NET]]

yes, you can keep the database on a central server that the components can
access via the web

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc

 

[Guest]

Alvin,
While I know I can use a central database as I'm doing
that right now. My problem is that the ASP needs a local
SYSTEM DSN or TNSNAMES.ORA if I use the Oracle OLEDB
connection.

I believe this is because the Office components are client
side components. And I'm trying to provide the customers
just a URL without having to install any other supporting
information.

Ivan