NAME
tkdm - Multi-host data manager for UnixODBC.pm.SYNOPSIS
tkdm [options]DESCRIPTION
Tkdm is a multi-host ODBC data manager that uses Perl/Tk as its user interface and the UnixODBC BridgeServer.pm module for network communication. Refer to the UnixODBC::BridgeServer man page and the README file of the UnixODBC package for details of how to configure multi-host communication with UnixODBC.pm.
OPTIONS
Tkdm recognizes the following options when typed at the shell prompt.
--background <color>
Set the window background color.
--debug
Print debugging messages on the terminal.
--displayfont <font>
Set the font used to display widget text.
--help
Display the command line options on the terminal and exit.
--height <pixels>
Window height.
--monofont <font>
Set the monospaced font used to display columnar data.
--relief <style>
Set the widget relief style. The "style" paramater may be one of: "raised," "sunken," "flat," "ridge," "solid," "groove," or "none."
--selectedfont <font>
Set the font used to highlight selected widgets.
--width <pixels>
Window width.
Usage
The Datamanager contains two windows. The left-hand window displays information about hosts, data sources, and, when logged in, tables in each data source.
The right-hand window provides forms and buttons to perform queries and display results on the data source and table selected in the left-hand window.
Clicking the right mouse button over most of the widgets displays a short menu with an About... dialog option and also an option to exit the data manager.
DSN Window
The left-hand window of tkdm displays the network hosts and data sources that are available via UnixODBC.pm peer servers on each host system on a network, and which are listed in the user's $HOME/.odbclogins file (see below).
If tkdm cannot connect to a host, it will display that host's icon X-ed out.
Clicking on a data source label with the left mouse button causes tkdm to request the login user name and password for that data source. Once login is successful, you can click on one of the tables in the data source's database, and tkdm then draws a query form for that table in the right-hand window, as described in the next section.
Table Query Window
The right hand window presents the controls for selecting and inserting data, and entering and running other SQL queries.
The three buttons in the upper left-hand corner of the window, described here from left to right, perform the following functions:
- Execute a SELECT query, modified using the field selectors and predicate inputs in the checkboxes and text entry boxes.
- Execute an INSERT query, using the data entered in the text entry boxes.
- Open a dialog box where the user can enter the text of a SQL query.
Once the query is submitted, tkdm will display the number of rows and columns in the result set, and, if the query returns data in the result set, tkdm will display the data in tabular form in the window.
CONFIGURATION
The file $HOME/.odbclogins contains the information for logging into each host system on a network that has a UnixODBC server.
Each line in the .odbclogins file provides the login information for one host, including the local system. The format of each line is:
<hostname>::<username>::<password>To access the data sources on the hosts named "accounting," "sales," and "warehouse," for example, the .odbclogins file would look like this:
accounting::mylogin::mypassword
sales::mylogin::mypassword
warehouse::mylogin::mypasswordSubstitute the actual login name and password for each system for "mylogin" and "mypassword."
The format of the .odbclogins file is similar to the odbclogins file used by the CGI data manager. There is a sample odbclogins file in the datamanager directory of the UnixODBC package.
CAUTION - The .odbclogins file can present a signifiant security risk if other users can read your login data. To prevent this, remove the group and other read permissions for the file, by using the command:
# chmod 0600 ~/.odbcloginsVERSION INFORMATION AND CREDITS
Version 0.12
Tkdm is part of the UnixODBC.pm package.
Written by: Robert Allan Kiesling <rkiesling@earthlink.net>.
Licensed under the same terms as Perl. Please refer to the file "Artistic" for details.
SEE ALSO
perl(1), UnixODBC(3), UnixODBC::BridgeServer(3).