Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Implemente SPS 2003 in local orgnization

  Asked By: Chelsea    Date: Apr 22    Category: Sharepoint    Views: 796

Recently i start implementing SPS
2003 in local orgnization... But i want some charts related web parts
to display the static analysis of projects and now this time all data
enter through manually and not connteced with data base...

i have 2 queries

1) Charts web tamplate or addon and also all instalation guide of that
2) how to conntect this data using database... or how to use connect
web tamplate



2 Answers Found

Answer #1    Answered By: Deonte Stein     Answered On: Apr 22

is the link to get some Microsoft Web Part which I have installed in our
testing sharepoint server, it contains different web parts including charts
as well. Get it from the link :


See the instruction when you download that for installation.

Answer #2    Answered By: Stephon Valentine     Answered On: Apr 22

Unless I'm mistaken, these office web parts will cause some serious connectivity
issues if the web server, sql server and client are not on the same LAN. When we
reviewed them, we saw that the web part:
1) requires Office 2003 to be installed, perhaps not a big deal
2) don't process the charting images on the server side. (somewhat of a big
3) deliver processing instructions for browser-instantiated client-installed
Office components which have the component connecting directly to the sql server
via DSN. (a very big deal)

As you can tell, #3 is a killer. The office web components are simply
client-installed, browser-instatiated office components which retrieve data
directly from the SQL server using a DSN. Depending on if you use sql
authentication or integrated authentication, this could mean that the connection
password is delivered to the browser embedded in the HTML. It also meant for us
that we would have to expose the SQL server to our Extranet users so they could
retrieve data directly from the Internet. We were not willing to do this.

Also, as you're configuring the web part for others to view, the table selects
pull data from SQL using a "SELECT *" syntax. If the source tables have much
data, you'll be pulling quite a bit of data across the wire. Doing this across a
WAN or the Internet can be crippling in addition to being insecure.

You might want to review them carefully for scalability and security.

I may be "all wet" here but these are some of the issues we saw when we
reviewed the Office Web Parts,

We opted for SQL reporting services.

Take a look here if this is an option for you.

Didn't find what you were looking for? Find more on Implemente SPS 2003 in local orgnization Or get search suggestion and latest updates.