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.
Version: 2.4ODBC 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.
License: Free To Try $64.00
Operating System: Windows
Homepage: www.aswit.com
Developed by:
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 grid 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 ( www.Printfil.com ), or sent out via e-mail by using our FileInMail software ( www.FileInMail.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.
Version 2.4: 1. Added compatibility with the newest Windows Operating Systems: Windows 11 and Windows Server 2022; 2. Some 64-bit systems could show the message "You must create a ODBC DNS configuration from your control panel" even though the DSNs were already configured. Fixed; 3. Other minor improvements;
Version 2.3: 1. Added compatibility with Windows 8 and Windows 10; 2. Now you can encrypt the INI files containing your SQL queries so that nobody can see the queries just by using Notepad; 3. Now Odbc4All is digitally signed, to improve security; 4. Other minor improvements;
Version 2.1 -1-: 1.When Odbc 4 All is running in batch mode, without any user intervention, and the initial screenshot has been disabled, it does not create any window at all. In this way, if you are calling Odbc 4 All by a DOS application at full screen, Windows will leave the focus to your application, without recalling the GUI mode anymore; 2.Product activation (needed only to disable the initial screenshot) can now be performed automatically, without involving the Support Team, if your machine is connected to the Internet. If the machine is not connected to the Internet, you can still activate the product by e-mailing the Support Team, like before; 3.Other minor improvements;
Version 2.0: 1. Added ability to run INSERT, UPDATE, DELETE etc. SQL commands.; 2. A few ODBC drivers do not correctly return the correct type for some numeric fields, causing a runtime error when exporting data to DBF tables. Until they will be fixed by the manufacturers, Odbc4All automatically recognizes the buggy numeric fields and retrieve them as char fields in the DBF output table.; 3. If a SELECT query do not return any record and Type=Screen, now a Message Box is shown instead of an empty grid.; 4. Added Auto-Error Notification feature to allow the Support Team to timely fix any new bug. This feature can be enabled/disabled by the INI configuration file.; 5. Other minor changes.
Version 1.2: 1. Added the ability to put SQL commands on several lines ;. 2. Added the ability to retrieve up to 13 decimal digits in numeric fields ;. 3. Improved numeric precision ;. 4. Other minor changes ;.