Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How to retrieve data in WP?

  Asked By: Jena    Date: Apr 09    Category: Sharepoint    Views: 1006

I'm new with SPS and trying to make a web part which can retrieve data
from SQL Server 2000 and XML files.

I made 2 functions in order to retrieve the data. One is GetAuthors,
which retrieves records from table authors in database pubs (SQL
Server), and the other is GetCustomer, which retrieves data from a XML

These functions always generate errors. The first one generates error in
line containing: oAdapter.Fill(mDS, "authors"). The error message:

Request for the permission of type
System.Data.SqlClient.SqlClientPermission, System.Data,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

The second generates error:

Request for the permission of type
System.Security.Permissions.FileIOPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Anybody knows what are the problems and how to solve these errors? The
source code is attached at the bottom.

One more question: I installed SQL 2000 Reporting Services on the same
PC where I installed SPS. My Question:

I want the authenticated users in SPS (from Windows Authentication) to
be able to access the reports which is stored in SQL Reporting Services.
What should I do?



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on How to retrieve data in WP? Or get search suggestion and latest updates.