Robert Kiesling > UnixODBC-0.34 > tkdm

Download:
UnixODBC-0.34.tar.gz

Annotate this POD

View/Report Bugs
Source  

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

USAGE ^

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.

DSN 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.

Table Query Pane

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.

Displaying Results

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."

MENU COMMANDS ^

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.

Main Menu Options ^

Help...

Open a help window with this document.

About...

Show version information in a dialog box.

Exit

Exit tkdm.

Text Menu Options ^

Clicking the right mouse button over a result set window pops up a menu which has the following options.

File

Options for multi-line text are, Open, Save, Save As, Include, Clear, and Exit.

Edit

Options are Undo, Redo, Copy, Cut, Paste, Select All, and Unselect All.

Search

Options are Find, Find Next, Find Previous, and Replace.

View

Options are Goto Line, Which Line, and Wrap mode.

COMMAND-LINE OPTIONS ^

--background <color>

The window background color.

--debug

Print debugging information on the terminal.

--displayfont <font>

The font used to display widget text.

--help

Print the command line options and exit.

--height <pixels>

Window height.

--monofont <font>

Monospaced font used to display columnar data.

--relief <style>

Widget relief style. The "style" paramater may be one of: "raised," "sunken," "flat," "ridge," "solid," "groove," or "none."

--selectedfont <font>

Font used to highlight selected widgets.

--width <pixels>

Window width.

CONFIGURATION ^

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:

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

VERSION INFORMATION AND CREDITS ^

$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, rkies@cpan.org.

Licensed under the same terms as Perl. Refer to the file, "Artistic," for details.

SEE ALSO ^

perl(1), Tk(1), UnixODBC(3), UnixODBC::BridgeServer(3).

syntax highlighting: