ODBC 4 All Icon

ODBC 4 All

Run SQL queries on any application using any ODBC data source.

ODBC 4 AllOverview

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 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 , or sent out via e-mail by using our FileInMail software

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.

NEW

  • Added compatibility with the newest Windows Operating Systems: Windows 8 and Windows 10
  • Now you can encrypt the INI files containing your SQL queries so that nobody can see the queriesjust by opening the configuration files with Notepad or other texteditors.
  • Now Odbc4All is digitally signed, to improve security and lower the risk of antivirus false positives.
  • Other minor improvements.

ODBC 4 AllInformation

Version
2.3
Date
06.16.15
License
Demo
Language
English
File Size
1.1MB
Developer
Category
SubCategory
Operating Systems
Windows 98/Me/NT/2000/XP/2003/Vista/Server 2008/7/8/10
System Requirements
No additional system requirements.
Printfil Icon
Print from Legacy, DOS programs to Windows printers, USB, GDI, PDF, e-mail, fax.
Demo
@Kill Icon
Manage opened Windows applications.
Free
FileInMail Icon
Monitor one or more folders for specified files to send via e-mail.
Demo
More
MySQL Query Browser Icon
The easiest visual tool for creating, executing, and optimizing SQL queries
Free
CASE Studio 2 Icon
Create ER diagrams for various databases, generate SQL scripts, HTML reports
Paid
SQL Dumper Icon
Allows dumping a SQL Server Database to a text file
Free
JumpStart Icon
Database initialization system for SQL Server.
Demo
Crystal Reports Server XI Icon
Transforming data into actionable information accessible anytime, anywhere
Trial
xSQL Script Executor Icon
Execute multiple T-SQL scripts against multiple SQL Server, DB2, and MySQL databases.
Free
Statement Tracer for Oracle Icon
A free solution for debugging programs interfacing with the Oracle RDBMS.
Free
SQL Prompt Icon
Intelligent code completion and layout for MS SQL Server
Paid
More