ODBC Browser Utility
The ODBC Browser utility is a simple yet powerful tool that enables you to examine the contents of ODBC compliant databases using ODBC data sources to connect to the databases you wish to examine.
Note: If the ODBC Browser Utility application is not referenced in the VAM, you must manually add it. The ODBC Browser application's directory is named "ODBCBrowse", and is stored within the VTS installation directory. If you require assistance in adding the ODBC Browser application to the VAM, please refer to the instructions provided in Add an Existing Script Application to the VAM.
An image of the ODBC Browser utility is displayed below.
Select a Data Source
In the upper left-hand corner of the ODBC Browser is a Data Sources drop-down list that enables you to choose from the ODBC compliant data sources on your workstation. The total number of available data sources is identified above the drop-down list. Each data source should have one database related to it.
In the event that data sources have been added, deleted, or modified, the Rescan button that appears above the drop-down list can be clicked to update the Data Sources drop-down list.
For Access database files, the File button can be used to open database file related to the data source selected in the Data Sources drop-down list.
To select view the contents of a database, simply select a data source from the Data Sources drop-down list. The ODBC Browser will display preliminary information about the database related to the selected data source.
View the Contents of the Database Related to the Selected Data Source
Once you have chosen a data source, the ODBC Browser will indicate the number of tables in the related database. This information is displayed in the "Tables for Data Source" drop-down list. An example is shown below.
Most of the information given in the different areas of the "ODBC Browser" window is updated automatically in response to selections or changes in other areas. The data sources are listed in the "Data Sources" area.
You may select any of the tables in the database using the "Tables for Data Source" drop-down list. The fields within the selected table are displayed in the "Fields for Table Name" list, where the name and data type for each field is identified. The records stored in each of the tables are displayed in the "Records For Table Name" list).
To the right of the ODBC Browser utility appears information on the SQL connection string and query string that was used to display the associated data, along with an ODBC status report. The status report displays error codes in the event that an error has occurred.
Finally, the fields and corresponding values for each record in the database can be viewed in the "Record X for Table Name" list. This data displayed in this list changes according to the record selected in the "Records For Table Name" list.