ActiveReports 13
Microsoft SQL Client Provider
ActiveReports 13 > ActiveReports User Guide > Concepts > Page Report/RDL Report Concepts > Data Sources and Datasets > Report Data Source Dialog > Microsoft SQL Client Provider

The Microsoft SQL Client Data Provider supports following options under the Connection section in Report Data Source dialog.

Connection Properties

The Connection Properties tab gives access to properties specific to the following data types.

Connection String

Sample Connection string

data source=in-data-sql\sql_2012;initial catalog=ADventurewORKS2012;user id=user1;password=password@123

Advanced Settings

The Advanced Settings tab gives access to properties specific to each data type.

With the SQL data type, the Advanced Settings tab gives access to the following properties: