Create a Data Source

1. Open the Data Source window.
   1. From the Administration tab, click on the Data Sources tile.
   2. Click the Add button or [Shift] + [Alt] + A. The Data Source window opens.Data_Source_Window
2. Enter a unique Name for your data source.
3. Enter a Connection String. A detailed ADO connection string contains a series of argument = value statements separated by semicolons. Parameters are specific to the database driver being used.

   Click the ellipsis button to launch the connection string wizard.

   If you know the ADO connection string, type it directly in the Connection String box.

   NOTE: Refer to Microsoft Windows® documentation/online Help for more information regarding ODBC drivers.  For Windows operating systems, your ODBC Data Source Administrator can be accessed from your Control Panel > Administrative Tools.

   1. The default Data Source/Provider is 'Microsoft SQL Server'/'.NET Framework Data Provider for SQL Server'.
   2. Fill in the appropriate fields: Server Name, Log on credentials, Database.
   3. Click OK to save and exit the wizard.
4. Click the Test Connection button on the Edit Data Source screen to test your connection. You will receive a 'Connection Failed' message.

   This is because the password under Authorization is blank.

   If you click OK or Apply at this time, you will get a popup informing you the password is blank.

5. In the Authorization section, enter the password associated with the user ID in the connection string.
6. Click the Test Connection button. You will receive a 'Connection Success' message.
7. Click OK to save your changes and exit the Edit Data Source screen.

Data Sources

Deleting a Data Source