Configure Databases and Data Sources
VoiceGuide can interact with any database or data source.
Any .NET Data Provider, ODBC Source or OLE DB can be used.
.NET and OLE DB Databases and Data Sources
Only a valid Connect String needs to be specified. No other configuration is needed.
A good resource for connection strings is: https://www.connectionstrings.com/
Configure ODBC Data Sources
If using the ODBC interface the ODBC driver should be specified in the Connect string, or an ODBC data source must be configured in Windows.
Note that for VoiceGuide v7 and later it is preferable to use the ADO.NET Data Provider, as this methoud is usually faster then using ODBC approach.
If using ODBC you must ensure that the 32-bit ODBC driver for your database has been installed.
VoiceGuide is a 32-bit application and needs to use 32-bit ODBC drivers (not 64-bit ODBC drivers).
On 64-bit versions of the Microsoft Windows:
On 64-bit systems there are two ODBC Administrator apps. A 32-bit version and 64-bit version.
The 32-bit version of the Odbcad32.exe file is located in the C:\Windows\SysWoW64 folder.
The 64-bit version of the Odbcad32.exe file is located in the C:\Windows\System32 folder.
You must use the 32-bit version of Odbcad32.exe when creating the ODBC connections.
Please read this: http://support.microsoft.com/kb/942976 for more information.
On 32-bit versions of the Microsoft Windows:
Open the ODBC Administrator from the Control Panel:
- Click Start, point to Settings, and then click Control Panel.
- 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.