Be the first to post a text review of Database Fishing Tool. Rate and review a project by clicking thumbs up or thumbs down in the right column.

• Forum thread added

  ericmilton created the DaTF Postgres to Oracle ODBC error forum thread

  posted by ericmilton 958 days ago

• daft 1.4.3 file released: daft-1.4.3-1_FC3.i386.rpm

  BUG FIXES since version 1.4.2 ----------------------------- *------- Multi word column names gave error message when selected *------- New version indicator should work now New functionality snice version 1.4.2 ------------------------------------- * Handle Tables, Views, and colums with names (partly) in capitals with surrounding quotes.

  posted 1199 days ago

• File released: /daft/1.4.3/daft-1.4.3-1_FC3.i386.rpm

  posted 1200 days ago

• daft 1.4.3 file released: daft-1.4.3-1_suse101.i586.rpm

  BUG FIXES since version 1.4.2 ----------------------------- *------- Multi word column names gave error message when selected *------- New version indicator should work now New functionality snice version 1.4.2 ------------------------------------- * Handle Tables, Views, and colums with names (partly) in capitals with surrounding quotes.

  posted 1200 days ago

• File released: /daft/1.4.3/daft-1.4.3-1_suse101.i586.rpm

  posted 1200 days ago

• daft 1.4.3 file released: Setup_DaFT_1.4.3.exe

  BUG FIXES since version 1.4.2 ----------------------------- *------- Multi word column names gave error message when selected *------- New version indicator should work now New functionality snice version 1.4.2 ------------------------------------- * Handle Tables, Views, and colums with names (partly) in capitals with surrounding quotes.

  posted 1259 days ago

• File released: /daft/1.4.3/Setup_DaFT_1.4.3.exe

  posted 1259 days ago

• themes Themes for DaFT 1.4 file released: itft1.zip

  ITFT1 Theme Version:0.14 Date: 28-JAN-2006 Author: Jelco Huijser License:GPL A new theme for DaFT 1.3+. (1.4.0 included) The Theme is enhanced to handle treeviews. Installation is done by adding the theme zip file itft1.zip to DaFT from the Change Settings menu, Themes Tab, Add Theme.

  posted 1370 days ago

• File released: /themes/Themes for DaFT 1.4/itft1.zip

  posted 1370 days ago

• daft 1.4.2 file released: Setup_DaFT_1.4.2.exe

  ------------------------------------------------------------------------------- DaFT Database Fishing Tool February 6, 2006 ------------------------------------------------------------------------------- Version 1.4 ------------------------------------------------------------------------------- Welcome to Daft, the Database Fishing Tool, a free ODBC database exploration tool available for Linux and Windows. Daft is written by Jelco Huijser, and licensed under GPL. Any suggestions, questions or comment can be sent to jelco@users.sourceforge.net. The homepage for DaFT can be found at: http:/daft.sourceforge.net/ What is Daft? ------------- DaFT is a GUI to any database that can be connected via ODBC. It provides list views of tables and columns, table view of data, SQL editor, CSV , HTML, SyLK, DIF data format export, a function for copying data between two ODBC databases. Written in TCL/Tk. Additional sources used by Daft (already incorporated in the kit) ----------------------------------------------------------------- In case you need the sources or documentation for the additional packages used by DaFt, you can find them at: TCLODBC:http://sourceforge.net/projects/tclodbc/ TKTABLE:http://sourceforge.net/projects/tktable/ MCLISTBOX:http://www1.clearlight.com/~oakley/tcl/mclistbox/index.html COMBOBOX:http://www1.clearlight.com/~oakley/tcl/combobox/index.html TREE:http://www.hwaci.com/sw/tk/treepi.html StarKits:sdx (the starkit wrapper): http://www.equi4.com/sdx.html tclkit (scripting runtime): http://www.equi4.com/tclkit.html INSTALLATION ------------ Linux ----- Gzipped StarKit --------------- Copy the file DaFT_x.x.tar.gz to the directory where you want to install DaFT. Than change directory to this directory. In a command console (i.e. xterm), do a: tar xzvf ./DaFT_x.x.tar.gz Next, change directory to ./DaFT_x.x and execute the configure script. This script will create a daft.sh executable script and make a symbolic link /usr/bin/daft to this script. Start DaFT by typing daft & in an xterm. This step assumes you have tclkit installed its location in your $PATH. See above for the website if you want to download tclkit. unixODBC version 2.2.8 or higher must be installed. RPM-ed Starkit -------------- Do a rpm -i daft-x.x.x.i586.rpm as root and daft will be installed. unixODBC 2.2.8 or higher must be installed. Windows ------- Setup_DaFT_x.x.EXE ------------------ Double click on the file and follow the instructions on the screen. Zipped StarKit -------------- Unzip the files in a directory. If you installed Tclkit you can assiociate the .kit file extension with Tclkit. You can also use the DaFT.bat file to start the kit. In order to run the DaFT.kit you must have installed Tclkit. See above for links to the equi4 website. The kit file can be unwrapped with the sdx utility, which can be downloaded from the equi4 website too. After it is unwrapped main.tcl can be run by the tcl or wish interpreter. PREREQUISITES USING DaFT ------------------------ The current version of the Database fishing tool depends on the tclodbc library. The tclodbc binary is available for windows, binaries for other operating systems must be compiled seperately. The binary included for Linux is based on a Suse 8.0 Linux installation, unixODBC, and oratcl 4.0. If you are using DaFT under Linux, you need to set the ODBC administrator program. You can find it in most distributions as /usr/bin/ODBCConfig. GETTING STARTED --------------- After starting DAFT you'll probably want to open an ODBC connection to a database. A database can be a CSV file, excel, or a scheme in a Oracle, Progress, MySQL, PostgreSQL, or any other relational database. Go to the File menu, click on Open Database, No Role. You can do the same by Ctr-o. If you don't see any ODBC data sources you must create them with the ODBC administrator. You can read more about the roles concept in the DaFT Help page. UPGRADING FROM DaFT 1.0.X (Windows) ----------------------------------- Version 1.2 can best be installed in a different directory as version 1.0. The projects.cfg file (if created), will be converted and copied into to the profil.dft file. The settings.cfg file can be copied into the installation directory, so the user defined layout settings and options will be read into the new version too. UPGRADING FROM DaFT 1.1.X (Windows) ----------------------------------- Version 1.2 can best be installed in a different directory as version 1.1. The connections and projects saved in the previous profil.dft file can reused again; just copy the old profil.dft file to the new installation directory. The settings.cfg file can be copied into the installation directory, so the user defined layout settings and options will be read by the new version. It is advised to copy both the settings.cfg and the profil.dft. Version 1.2.1 works by default with the profil12.dft file name, so the profil.dft will not be used, unless the old settings.cfg is copied over the new settings.cfg (if already created). The old settings.cfg refers the profil.dft and might also contain the key to read the profil.dft database passwords. WHAT'S NEW IN VERSION 1.4 ? --------------------------- * SQL Editor margin and statement indicator. The indicator in the SQL editor margin shows the user the SQL statement scope as perceived by DaFT at the location of the cursor. The indictor shows if the statement will fetch records, or not. If the interpretation is not correct the indicator can be changed. This is useful when you write a procedure or cursor statement that will retrieve records from the database. It also lets you change the scope of the statement. By default any empty lines are regarded as end of statement, this can be changed by highlighting/selecting the full statement, and click on "set to selection". * Tables and views tree view. Different types of tables and views are now separated in a explorer type of view. The old object type combobox has been removed. * Tables and views filter with a combobox for remebering previous filter statements. * Include the database table or view owner. The owner can be included in all generated SQL statements. This can be turned or off per driver type. * Colums and index tree views. The old columns listbox is changed by a tree view that indicates the indexes per column, and for some driver types the primary key too. The primary keys can be found on tables for Oracle, SQL Server, MySQL, FireBird, Interbase, Ms Access. * Driver types for databases that do not support indexes will not show in the index tab. This can be set in the Driver Type Settings * Inclusion of the table/view owner in all generated SQL statements. This feature can be set on or off at connection level (menu Connections) or at the driver type settings. * White space indicators. A button on each table view is available that starts a function which will scan all fields in the table for values containing white spaces at the begin or and of the string. These will be indicated in orange. If the full string contains blanks only, this will be indicated in green. * Ascending and descending sorting of columns. * Added right mouse click menus on several text entry fields. * DaFT uses the Tile library version 0.7.2 WHAT'S NEW IN VERSION 1.3 ? --------------------------- * Themes! * Fixed a few bugs in the Creation of projects, reading and writing to the project database. * (1.3.2) Automatic reloading of the database objects when the database is changed within the same connection. This configurable per type of driver. * (1.3.2) Non-standard statements (i.e. not select,insert,update or delete) will by default not be handled by a database fetch, unless executed as a "single statement" which is necessary when stored procedures are called. WHAT'S NEW IN VERSION 1.2 ? --------------------------- * Execution of selected text, useful for testing a block of T-SQL or PL/SQL code. * Colored lines in de log messages, indicating errors, OK messages, or ODBC messages. * Undo/Redo (Ctr-z/Ctr-y) for the SQL-Pad and SQL-Statement editor * Tip of the day, see [Help Menu] * Check for new version [Help Menu] * Improved and additional menu's and icons * Bypassing of date/time conversion * All statement output, except for insert, update, and delete statements, are send to the Data table view * Automatic creation of profil.dft backup file, locking, and recovery. * Progress bars indicating script execution or script creation progress * (1.2.1) A user configurable setting indicating the number of records at wich point the user must be asked to stop further retrieving of any records. * (1.2.1) Clear buttons for tables and Log Messages * (1.2.1) A new function on top of the statement history stack for remembering current statement and blanc the SQL Editor. * (1.2.1) Improved INSERT script creation dialog, which enables the created script to be copied into the SQL Editor at once, ready for execution on another database. * (1.2.1) Improved Date/Time handling functions when creating INSERT scripts. The user now has the possibility to map datetime fields to a predefined format, and define which statement in the INSERT line should be used to reformat this date value (a string) to the target database native format. WHAT'S NEW IN VERSION 1.1 ? --------------------------- *Filters on the snapshot data. *Remembering of the last used filter per table. *Indication of unique indexes in the columns listbox *Connection history *Stored encrypted passwords *Difference higlighting when two selection sets are compared *Binary excel format export *Improved help file format *Date time format can be set per database type *Expansion of the snapshot table view *Export of the snapshot data *Variable substituion in multi connection statements BUG FIXES since version 1.4.1 ----------------------------- *------- Export of data to MS XLS file with integer or real type of string, resulted in random number in first xls cell BUG FIXES since version 1.4.1 ----------------------------- *------- Changing width of the table treeview causes an error when there is no database connected yet. BUG FIXES since version 1.3.2 ----------------------------- *1215867 Informix database switching error BUG FIXES since version 1.3.1 ----------------------------- *1214347 error when clicked "show indexes" on a table *1213064 ODBC connection doesn't work in 1.3.0 for NonStop BUG FIXES since version 1.3 --------------------------- *Creating project databases had problems with date fields and text fields with some database types like MySQL. *Retrieving queries from a project database resulted in an error in version 1.2.X --------------------------- BUG FIXES since version 1.2 --------------------------- *Several.... BUG FIXES since version 1.1 --------------------------- Version 1.1.1 ------------- *Changed the directory structure references for the Linux version *Bug #1086421 No columns with ODBC-RDB BUG FIXES since version 1.0 --------------------------- Version 1.0.2 ------------- *The maximum attempts to try to connect is made set up variable. This way the user can prevent to be locked out in some database systems when more then the allowed number of authentication failures has been reached; DaFT will stop trying to connect at the set maximum. Version 1.0.1 ------------- *Fixed a problem reconnecting to a NonStop Database *Added password remembering array, so the user does not need to retype userid and password when a reconnection is necessary *Fixed a problem when trying to view data when another record viewer is already opened. The previous viewer will be closed first, before opening the new viewer. *Fixed a problem with the time format conversion that would fall back to %c in some cases. (SQLServer date format)

  posted 1377 days ago