[Homepage] - by: p.i. Guolo Davide - Download links


Click to enlarge
Description:
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.

Recent changes in this Major Update:
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.

Download: Download links Price $ 64 / 49 Purchase - Get it Now (Statistics)

HyperPublish The professional software for Website / CD catalogues; database CSV import, (sub)categories, and much more...   Alldj Video Converter The excellent Video Conversion software for avi mpeg wmv mp4 mov and flv flash   1site The WebSite creator software that is easy but also fast & handy for the long time productivity... also for the technician...   DVD ripper Copy DVDs / backup your movies...

Comments (Add comment)

Type: Shareware
Price $ 64 / 49


Purchase - Get it Now

File size: 714 Kb
Date: 06/06/2005
Homepage
Install support: Install and Uninstall
OS: Win98, WinME, WinXP, WinNT 4.x, Windows2000, Windows2003
System requirements: odbc32
Language: English

Categories Audio and Music... Business and Finance... Desktop Enhancements... Desktop Themes... Games... Graphic Painting and Drawing... Home and Education... Internet and communication... Multimedia, Video and Productivity... Screen savers... Skins and Wallpapers... Software Development... Utilities, Security and Hardware... Web...