Configure ODBC Data Sources

VoiceGuide's DB Query module can be used to query data from any data source for which you have an ODBC driver. Before accessing data using the ODBC interface, an ODBC data source must be configured for the database.

Note that for VoiceGuide v7 and later it is preferable to use the ADO.NET Data Provider, as it is usually faster then using the ODBC driver.

Before setting up the ODBC Data Source you must ensure that the ODBC driver for your database has been installed. The ODBC driver for your database should be obtained from your database vendor.

To open the ODBC Administrator from the Control Panel:

1. Click Start, point to Settings, and then click Control Panel.
2. Double-click Administrative Tools, and then double-click Data Sources (ODBC).

The ODBC Data Source Administrator dialog box appears:

Select the 'System DSN' tab, and then click on the 'Add; button to display the list of ODBC drivers installed on the system:

Select the driver which corresponds to the database you want to add, and press Finish. Your Database's ODBC driver should now take you through the rest of the Data Source setup process - the options presented in this stage will be different for each different database source. Please consult your database user's manual for information.

If your database's driver is not listed you should install your databases ODBC drivers. Please consult your database user's manual for information.

In the example above we selected an Access database Products.mdb and have called our Data Source 'Products'. Further parameters (eg database's password) can be set using the 'Advanced' options button.

Each different database type will have a different setup screen - for example the MS SQL Server ODBC setup screen looks like this:

After setting up our ODBC Data source the new source will appear in the User's list of Data Sources.

This ODBC Data Source is now ready to be used. The "DB Query" module can be used to access ODBC Data Sources from a VoiceGuide script.