Free Software Downloads
Odbc 4 All 2.0
System Utilities category
check the available software downloads subcategories
|Company : p.i. Guolo Davide
File download size: 714 kb
License : Shareware
OS: Win98, WinME, WinXP, WinNT 4.x, Windows2000, Windows2003
Release date: 2005-06-06
Software Links:Homepage: software homepage
Download link: Download
Screenshot: View screenshot
related: ODBC, DOS, database, DSN, DBF, DB3, Clipper, Access, Excel, Informix, Oracle
Odbc 4 All 2.0 description
Allows any application, including DOS apps and batch files, to easily run SQL queries using any ODBC data source, (Access, MySql, Oracle, Informix, ...) redirecting the output to the screen, an ascii file / table or a DBF table. Can be used in standalone mode and/or inside a 3rd party application, with or without user intervention.
Odbc 4 All 2.0 review
ODBC 4 ALL is a 32 bit Windows utility designed to easily allow any application, including DOS apps and batch files, to run SQL queries using any ODBC data source, (Access, Informix, MySql, Oracle, Sql Server, ...), redirecting the output to the screen, an ascii file / table or a DBF table.
When run in interactive mode, you can interactively choose the ODBC Data Source and Table, then insert the SQL command to send to the database server. If the command is a SELECT, the SQL results will be automatically shown on a screen grid, while INSERT, UPDATE etc. usually do not provides any output.
To use it inside a 3rd party application, you can create an ascii configuration file, then run ODBC4ALL.EXE to obtain the results of the SQL query into the desired output format.
In this case user intervention is not required. Even the error messages could be redirected to an ascii file (for example if the SQL query contains a syntax error, or if the database server is unreachable because the server PC is down) allowing the running application to check for errors before managing the results.
Ascii tables are particularly useful to obtain data views which are automatically printable using our Printfil - Windows Printing System for Applications software: http://www.printfil.com
The two modes can be mixed, allowing you to run it in interactive mode obtaining an ascii output file or to run it from within your application only to automatically show the results of the query to the user.