GreatManuals.com
Huge Collections of Software Manuals and Knowledgebase

Database and Table Selection

Log Recording Details to Database

If this option is selected, VRS will log information regarding each channel's recording to a specified database. This can be useful if you want to keep a complete listing of each recording's details for future reference.

In able to select this option you will need to have a ODBC Data Source already created.

Setting up an ODBC Data Source.

Go to Control Panel -> Administrative Tools-> Data Sources. Under 'User DSN' Tab, Select 'Add' -> Complete the Wizard by specifiying a database driver, name and location. When you click Log Recording Details to Database in VRS, you should now see the Database name you specified in Data Sources.

Database to Insert Into

Select from the Databases listed the one you wish to insert into. If you database has a username and password specify these and test that your login details are correct. You must be able to access the database and have a correct login in order to insert into it.

SQL Command to INSERT

Specify what you require to be inserted into the database. An example insert statement follows:

INSERT INTO LogTable ("Date","Time","Channel","FileName","Folder","Duration","Data","MD5Value") values ('%date%','%time%','%channel%','%filename%','%folder%','%duration%','%dial/data%','%md5%') Where:

1. The field or column names are : Date,Time,Channel.. etc
2. the keywords that vrs uses include: %date%,%time%,%channel%,%filename%,%folder%,%duration%,%dial/data%,%md5%
3. Extra columns/fields may be used to store further information like : UserName, ComputerName etc, providing a value instead of a keyword. To use your own fields please remember to place % around each other word you wish to insert. eg: %MyComputer%
4. You can then test the SQL command for using the correct syntax and the correct field names.

SQL INSERT Line Backup

If for some reason the Database file is not able to be accessed at one point in time, VRS will store the SQL command and attempt to insert it at the end of the next recording. Besides receiving a Log Error when it fails the first time, it is possible to check that the SQL Commands are exectuted correctly by viewing the "C:\Documents and Settings\All Users\Application Data\NCH Swift Sound\VRS\failedSQlCommands.txt".

If the file doesn't exist, all INSERT commands that have been successful.