Specify a Connection String

<< Click to Display Table of Contents >>

Navigation:  User Interface Reference > Report Designer > Report Designer for WinForms > Report Wizard > Data-bound Report Wizard > Connect to a Database >

Specify a Connection String

Interface Elements for Desktop > Report Designer > Report Designer for WinForms > Report Wizard > Data-bound Report Wizard > Connect to a Database > Specify a Connection String

Note

This wizard step appears only if you're creating a new report from scratch. In this instance, familiarity with database connections is required, so we recommend that you contact your application administrator or vendor for assistance. If you're modifying an existing report, this step will not appear and you will start with the Choose Columns to Display in Your Report wizard page.

ExpandedCollapsed Purpose

On this page, define a custom connection string or select one of the supported data source types.

The following data source types are supported.

Microsoft SQL Server

Microsoft Access 97

Microsoft Access 2007

Microsoft SQL Server CE

Oracle

Amazon Redshift

Google BigQuery

Teradata

Firebird

IBM DB2

MySQL

Pervasive PSQL

PostgreSQL

SAP Sybase Advantage

SAP Sybase ASE

SQLite

VistaDB

VistaDB5

XML file

ExpandedCollapsed Page Interface

Select the provider type in the Provider drop-down list. Next, specify the connection options required for the selected provider type (e.g., authentication type and database name).

img23763

Click Next to proceed to the next wizard page, depending on whether or not the created connection uses server authentication.

Save the Connection String - if server authentication is required, this page allows you to specify whether or not you want to save the user credentials along with the connection string.

Customize the Query - if server authentication is not required, the page above does not appear, and you will proceed to constructing the query.

Copyright (c) 1998-2016 Developer Express Inc. All rights reserved.

Send Feedback on this topic to DevExpress.