by p.i. Guolo Davide
|
ODBC 4 ALL is a 32 bit Windows utility designed to easily allow any application, including DOS, 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 to see the resulting data on a screen grid.
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.guolo.com/printfil
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. 28
|
by Astersoft Co.
|
As technology advances we tend to switch to new ways of accomplishing the same tasks. Faster machines and better software increase our overall computing and information processing speed as well as overall comfort and reliability. New solutions sometimes offer expanded functionality and increased performance.
However, there are oldies-but-goldies even among data storing and processing technologies. One of such things is DBF database format used widely in system database upkeep and administration today. Despite the fact that DBF standard exists for decades it is still one of the most convenient and feature-rich database formats available on the market. What we actually need is some piece of software that can handle all the format functionality allowing us access DBF databases fast and letting us alter both data structure and the data itself on the fly. But is there a compact solution that would suit all our needs?
In fact, there is! Introducing DBF Manager by Astersoft Co., the truly innovative software intended to handle various DBF databases seamlessly.
DBF Manager supports Clipper, dBase and FoxPro databases. Database structure can be modified without data loss. Data can be edited using appropriate edit controls such as calendar for dates and memo editor for memo fields. Common index searching coupled with fast text search function allows searching for data in any of selected fields. Searching for records in a scope is also possible. Convenient index manager allows re-indexing and rebuilding indices order on the go.
Besides the far-beyond-expectations functionality DBF Manager offers convenient user interface and flexible configuration. Throw in some amazing database management features never seen in software like this before and you get the winner! Flexible licensing mechanism makes purchasing DBF Manager cost-effective both for companies and individuals. The application comes with Free Trial version available. You can download it right now! 11
|
|
|