Specifying a data source

A data source provides a link to a database, spreadsheet, text file, or other source of data.

Some applications automatically create a data source on your workstation.  It is also possible to manually set up data sources.

The Available data sources list on Database Integration Wizard Step 1 displays data sources that already exist on your workstation.

To allow the Database Integration Wizard to use a data source that already exists on your system, double-click an item in the Available data sources list.  Alternately, you may click an item in the Available data sources list, and then click Add>>.

Note:  When connecting to a Pervasive database, you may connect to the GainSeeker71_B data source installed by GainSeeker.  However, this data source uses a driver for which some SQL commands and syntax options are not supported.  To work around this issue, you can create a new data source based on the Pervasive ODBC Engine Interface.

After adding a data source to the Available data sources list, you may need to specify connection information for the data source.  For more information, see Specifying connection information and testing the connection.

To view more information about a data source, or to create a new data source, follow these steps:

  1. Click Data Source Administrator.

    This launches the ODBC Data Source Administrator application that is installed with Microsoft Windows.

  2. Use the ODBC Data Source Administrator to view details about a data source or to create a new data source.

After you have finished viewing and creating data sources, click OK to return to the Database Integration Wizard.

  1. If you have created a new data source, you must refresh the Available data sources list so that the new data source will be displayed.

    To do so, click any item in the Available data sources list, and then press the F5 key.  The new data source should now be included in the Available data sources list.

 

More:

Specifying connection information and testing the connection

How many connections to I need?

Notes button

Database Integration Wizard: Step 1