Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

VS 2005, SQL Sever 2005 Reporting services Error

  Asked By: Brandon    Date: Oct 03    Category: Sharepoint    Views: 1109

I am working reporting services in vs 2005 and sharepoint as a datasource. I am getting the following error when creating dataset.

A connection cannot be made to the database.
Set and test the connection string.
(Microsoft Report Designer)

Keyword not supported: 'http://server:2233/_vti_bin/lists.asmx;integrated security'. (System.Data)

I selected data source type as XML and give connection string as http://server:2233/_vti_bin/lists.asmx . And while creating dataset i have given the following Query string:

<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" />



1 Answer Found

Answer #1    Answered By: Talia Johns     Answered On: Oct 03

In Data source  Properties what type  of authentication are you using?(you should be using Windows)

Can you try to browse the web service URL in the browser?

In the above mentioned query  you should specify parameters in which you will specify the list name

sample query:

<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameter Name="listName">
<DefaultValue>Test List</DefaultValue>
<Parameter Name="rowLimit">
<ElementPath IgnoreNamespaces="true">*</ElementPath>

Didn't find what you were looking for? Find more on VS 2005, SQL Sever 2005 Reporting services Error Or get search suggestion and latest updates.