O'Reilly logo

Microsoft® SharePoint® Designer 2010 Unleashed by Kathy Hughes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring a Database Connection

The following example walks through configuring a database connection to the AdventureWorksDW2008 database. It also demonstrates a common issue that can happen when SharePoint Designer incorrectly recognizes the database schema and subsequent queries against the database fail and discusses use of Custom SQL Statements to overcome this issue.

Note

The following example uses the AdventureWorksDW2008 database, but you can also use the AdventureWorksDW database.

To create a new database connection, use the following steps.

1. Click the Data Sources tab in the left-hand navigation pane.

2. Click Data Connection in the New group in the ribbon.

3. In the Data Source Properties dialog, under the source tab, click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required