Expert

The Expert Configure Data Source Wizard allows you to connect to a third-party database using a connection string. It allows more customization than the Windows ODBC or Advanced wizards, but requires expert knowledge.

Third-Party Database Connection String

Data Source Provider

• Click Browse and select a data source provider from the menu.

  

Data Source Connection

• Specify a connection string.

To use a template

1. Click Template. The Connection String Templates dialog box will open.

   

2. Under Template name, expand the list of available templates.
3. Select a template.
4. Click OK.
5. Under Configure how to connect to your data source:, modify the template to suit your desired database connection.
• Click Test to test whether the connection works.
• When you are ready, click Finish.