Odbc 4 All 2.2
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.
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 can even be automatically shown on a screen grid (while INSERT, UPDATE etc. usually do not provides any output); you can browse the data there, send it to an Excel spreedshet, or create a configuration file to run the query again, later on, in batch mode.
Batch mode is particularly useful to use it inside a 3rd party application. You can manually create an ascii configuration file, or let the screen scrig automatically creating it for you, 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 by using our Printfil - Windows Printing System for Applications software: [link removed] , or sent out via e-mail by using our FileInMail software: [link removed]
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.
|Release Info:||Major Update on Jun 21, 2010|
|Release Notes:||1. Better compatibility with newer Windows OS's and ODBC drivers; 2. New "Export Query" button on the screen grid to automatically create a new INI file with encrypted DNS entries; 3. Interactive data can be opened in "Excel" by a new button on the screen grid; 4. Other minor improvements;|
|Related Tags:||ODBC DOS database DSN DBF DB3 Clipper Access Excel Informix Oracle|
Allows you to list all the opened windows (applications) on your Windows machine (including hidden and trayed) and to kill them by specifing PART of their titles. Works also as a command line utility and can be invoked by batch files. Freeware.@SwIt Printfil 5.18
Print from DOS, Unix, Linux to Windows printers: USB, GDI, PDF, e-mail, network, IP, fax, virtual. Capture LPT1: .. LPT9: port and redirect the jobs, even to a printer physically connected to the captured port and w/out physical LPT ports installedFileInMail 2.3
FileInMail automatically monitor disk folders for specified files. As soon as they appears, the files are archived on disk, even as ZIP, and forwarded via e-mail to one or more recipients through your own e-mail Client program or an SMTP server.
item has less then 1 vote
|FileCart Rating||Not yet Rated|
|OS Support||Windows Install and Uninstall|
|File Size||0.98 MB ( 1,003 KB )|
|Published||Jan 28, 2011 (4 years ago)|
|Updated||Dec 26, 2013 (1 year ago)|