Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

CreateDataSource Method

SQL Server 2000

ReportingService.CreateDataSource Method

Creates a new data source in the report server database.

Public Sub CreateDataSource( _
   ByVal DataSource As String, _
   ByVal Parent As String, _
   ByVal Overwrite As Boolean, _
   ByVal Definition As [Namespace].DataSourceDefinition, _
   ByVal Properties() As [Namespace].Property _
)
   Member of [Namespace].ReportingService

public void CreateDataSource(
   string DataSource,
   string Parent,
   bool Overwrite,
   [Namespace].DataSourceDefintion Definition,
   [Namespace].Property[] Properties
);
   Member of [Namespace].ReportingService
Parameters
DataSource
The name of the data source.
Parent
The full path name of the parent folder that contains the data source.
Overwrite
A Boolean expression that indicates whether an existing data source with the same name in the location specified should be overwritten.
Definition
A DataSourceDefinition object that describes the connection properties for the data source.
Properties
An array of Property[] objects that defines the property names and values to set for the data source.
Permissions

Operation Description
Create Data Source Required on the folder to which the data source is being added.

Remarks

If errors occur, the data source is not created.

Security Note  This method may pass sensitive data, including user credentials, over a network. When possible, use Secure Sockets Layer (SSL) encryption when making Web service calls with this method. Depending on the SecureConnectionLevel setting for the report server, you may be required to use SSL when invoking this method. You can use the ListSecureMethods method to retrieve a list of methods that currently require a secure connection. For more information about the SecureConnectionLevel setting, see Using Secure Web Service Methods.

Example

To compile this code example, you must reference the Reporting Services WSDL and import certain namespaces. For more information, see Compiling and Running Code Examples. The following code example creates a new data source in the root folder of the report server database:

Imports System
Imports System.Web.Services.Protocols

Class Sample
   Public Shared Sub Main()
      Dim rs As New ReportingService()
      rs.Credentials = System.Net.CredentialCache.DefaultCredentials
      
      Dim name As String = "AdventureWorks"
      Dim parent As String = "/"
      
      ' Define the data source definition.
      Dim definition As New DataSourceDefinition()
      definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
      definition.ConnectString = "data source=(local);initial catalog=AdventureWorks"
      definition.Enabled = True
      definition.EnabledSpecified = True
      definition.Extension = "SQL"
      definition.ImpersonateUserSpecified = False
      'Use the default prompt string.
      definition.Prompt = Nothing
      definition.WindowsCredentials = False
      
      Try
         rs.CreateDataSource(name, parent, False, definition, Nothing)
      
      Catch e As SoapException
         Console.WriteLine(e.Detail.InnerXml.ToString())
      End Try
   End Sub 'Main
End Class 'Sample

using System;
using System.Web.Services.Protocols;

class Sample
{
   public static void Main()
   {
      ReportingService rs = new ReportingService();
      rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

      string name = "AdventureWorks";
      string parent ="/";

      // Define the data source definition.
      DataSourceDefinition definition = new DataSourceDefinition();
      definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated;
      definition.ConnectString = "data source=(local);initial catalog=AdventureWorks";
      definition.Enabled = true;
      definition.EnabledSpecified = true;
      definition.Extension = "SQL";
      definition.ImpersonateUserSpecified = false;
      //Use the default prompt string.
      definition.Prompt = null;
      definition.WindowsCredentials = false;

      try
      {
         rs.CreateDataSource(name, parent, false, definition, null);
      }

      catch (SoapException e)
      {
         Console.WriteLine(e.Detail.InnerXml.ToString()); 
      }
   }
}
See Also

ReportingService Class

Reporting Services Web Service Library

Show:
© 2015 Microsoft