|Database Tour Documentation|
Opening Data Source
Alternatively, you can view Ways of Opening Different Data Source Types.
Databases can be opened by the following ways:
Choose Database | Open... menu -> click Alias / ODBC data source button -> select an alias from the dropdown list -> click Open button.
For some types of databases, you may be asked for user name and password.
2. Opening a data file
Choose Database | Open... menu -> -> click File button -> click '...' button -> select a physical file (for example, of DB, DBF, MDB type etc.). You can create a blank MDB or UDL file here. Click Open button.
After that, the folder with the selected file (except multi-table files), will be automatically opened as a database and the selected file will be opened as a table of this database. If a multi-table file (for example, MDB or GDB) was selected, then the file will be opened as database.
3. Opening folder with database files like .DB, .DBF etc.
Choose Database | Open... menu -> click Folder button -> click '...' button -> select a physical folder with database files -> click Open button.
After that, the selected folder will be opened as a database and the database files, which it contains, will be shown as tables.
Note: if you open folder via ADO interface, don't forget to select the correct driver for the database from the list of available drivers; for example, if you wish to open folder with .DBF files, then select dBase driver.
A particular case of this way of opening database is opening a folder of higher level from open folder of lower level:
4. Opening database by direct specifying a connection string
Choose Database | Open... menu -> click ADO and Connection string buttons -> specify a connection string manually or by using connection string builder -> click Open button.
For some file types, folders or ODBC data sources, the connection string can be generated automatically. To automatically generate the connection string, select needed ODBC data source, file or folder in the corresponding field and click Convert to connection strings button; then, the list of available connection strings for selected database will appear in Connection string field; select the most suitable one from the list and click Open button (advanced users can improve the connection string by manually adding extended parameters prior to clicking the Open button).
5. Opening files directly from Windows Explorer
Some files (for example, DB, DBF, MDB etc.) can be opened by using file associations. If such a file is associated with Database Tour, then it is enough to click it twice and Windows will automatically start Database Tour, and it will open the selected file.
Also, you can drag files from Explorer and drop them into the open instance of Database Tour.
6. Opening databases through the command line
Almost all supported database types can be opened through the command line.
7. Opening files, which are not database files
Besides databases Database Tour can also open some other file types:
- Report files (DTT, STT). These files can be opened by several ways: using the corresponding tab of Open Data Source dialog, through the command line, using the corresponding button of main window, or from Report Builder window.
- SQL files. When opening .SQL files, Database Tour firstly opens folder, which contains the file (see 3. above), then opens SQL page and loads text of the file into SQL editor. Sometimes, before opening such file, Database Tour lets you select associated database through Open Data Source dialog.
- INI files. If you try to open such file in Database Tour, the program treats this file as file containing schema for ADO text table, therefore it firstly open the file's containing folder as text database and then opens the file.
- SCH files. If you try to open such file in Database Tour, the program treats this file as file containing schema for BDE text table, therefore it firstly open the file's containing folder as text database and then opens the file.
When opening files of other types, Database Tour in most cases will try to open them like it does for database files (see 2. above).
8. Reopening previously opened databases
The last used databases can be accessed from Database | Reopen or Database | Database History... menu, and can be easily reopened from there. Opened databases from this list are marked with checkboxes.
Some databases require password to be open. You can optionally save the password after successful database opening to avoid typing the password in the future. All saved passwords can be removed by choosing Database | Clear Password List.
After a database is opened, the list of its tables is available in the Tables pane of Object Browser, which occupies left part of the main window. You may open a table from the opened database by the following ways: