Database Tour Documentation Contents Index

Opening Data Source

Top Previous Next

Alternatively, you can view Ways of Opening Different Data Source Types.

Databases can be opened by the following ways:

1. Opening an ODBC data source or BDE alias

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:

upfolder

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.

- Action files. These files can be opened using the corresponding tab of Open Data Source dialog or through the command line.

- 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:

- Simply select it in this list; opening the table data can be done by one the following three ways: moving to Data pane, double-clicking the table name in the table list, or pressing ENTER when the table name is selected in the list;
-There is ability to open table from the table list in a separate window. It is useful for comparing two tables. To open table in the separate window right-click the table in red marker and choose Open in the Separate Window.

In addition to tables, you may open such data sets as queries.

See also

 Examples of ADO Connection Strings

 Closing Data Source

 Ways of Opening Diferent Data Source Types

 Error Messages

 Creating and Configuring BDE Aliases

 Command Line Usage