tkdm - Multi-host data manager for UnixODBC.pm.
Tkdm is a multi-host ODBC data manager that uses Perl/Tk as its user interface and UnixODBC.pm for peer to peer communications. Refer to the UnixODBC.pm man page, the UnixODBC::BridgeServer.pm man page, and the README file in the UnixODBC source code archive for a description of UnixODBC.pm client and server configuration.
The section, "CONFIGURATION," describes how to configure tkdm with login and server information.
The Tkdm main window has two panes. The left-hand pane displays information about hosts, names of data sources (DSNs), and, when connected to a data source, the database tables.
The right-hand pane provides forms and buttons to perform queries and display query results of the DSN and table selected in the left-hand pane.
The left-hand pane displays network hosts and data sources that are available via UnixODBC.pm peer servers on each host system on a network, as described in the section, "CONFIGURATION."
If tkdm cannot connect to a host, it displays that host's icon X-ed out.
Clicking on a DSN label with the left mouse button pops up a dialog for the DSN's login user name and password. After logging in, clicking on a table name draws a query form in the right-hand pane, as described in the next section.
The right hand pane has buttons for the following functions.
- Execute a SELECT query, modified using the field selectors and predicate inputs in the checkboxes and text entry boxes below.
- 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.
The pane displays the result set's number of rows and columns, and, if the query returns data in the result set, the data in tabular form in the window.
Data that consists of more than one line of text is displayed in a scrollable window. The text window is resizable by dragging the lower right corner of the window. You can cut and paste highlighted text into other applications with the X Window clipboard, or with the text menu options described in, "Text Menu Options."
Clicking the right mouse button opens the program's main menu, or a text editing menu when the mouse pointer is over the results set.
Open a help window with this document.
Show version information in a dialog box.
Clicking the right mouse button over a result set window pops up a menu which has the following options.
Options for multi-line text are, Open, Save, Save As, Include, Clear, and Exit.
Options are Undo, Redo, Copy, Cut, Paste, Select All, and Unselect All.
Options are Find, Find Next, Find Previous, and Replace.
Options are Goto Line, Which Line, and Wrap mode.
The window background color.
Print debugging information on the terminal.
The font used to display widget text.
Print the command line options and exit.
Monospaced font used to display columnar data.
Widget relief style. The "style" paramater may be one of: "raised," "sunken," "flat," "ridge," "solid," "groove," or "none."
Font used to highlight selected widgets.
The file $HOME/.odbclogins contains the information for logging into each host system on a network that has a UnixODBC server.
Each line provides login information for one host, including the local system. The format of each line is:
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::mypassword
Substitute 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.
WARNING - To prevent other users from reading the login data, remove the, "group," and, "other," permissions from the file, with:
# chmod 0600 ~/.odbclogins
$Id: tkdm,v 1.23 2008-01-21 08:47:34 kiesling Exp $
Tkdm is part of the UnixODBC.
Copyright © 2002-2005, 2008 Robert Kiesling, firstname.lastname@example.org.
Licensed under the same terms as Perl. Refer to the file, "Artistic," for details.
perl(1), Tk(1), UnixODBC(3), UnixODBC::BridgeServer(3).