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 HvB Computer Engineering
|
The blueshell Data Guy is an ADO-based editor for virtually all types of databases. This program supports Jet (Access and ISAMs like dBase, Paradox etc.), Oracle, SQL Server, MySQL, Sybase and Advantage DB. Additionally you can use other OLEDB or ODBC providers.
All connections, schemas, table types and tables are shown using a tree view. You can open a new connection and tables of this connection with a few mouse clicks. You can watch all properties of your opened connections and of the recordsets using bAsk - the "blueshell ADO Survey Kit" included in this program.
Enjoy the magic of connectivity! Exchange tables between your Desktop applications like Word, Excel, Outlook, Frontpage etc., your database files (.mdb, .dbf, .xls, .db etc.) and your client-server databases like Oracle, MS SQL Server etc. Nearly everything that can contain a table can be the source or the destination! Import, Export, Copy, Paste, Drag and Drop as you like!
The "blueshell Data Guy" uses the atb control from "blueshell Active Tables". A runtime version of this great ActiveX control is included. 29
|
by microOLAP Technologies LTD
|
DbExpress Borland Delphi/C++Builder driver for MySQL with the highest performance.
microOLAP dbExpress driver for MySQL (DBX4MySQL) is an independent library that implements the common dbExpress interfaces for processing queries, without any third-party libraries and intermediate layers like BDE, ADO or ODBC.
As data-access layer thin and simple, dbExpress (and implicitly DBX4MySQL) provides high performance database connectivity and is easy to deploy. DBX4MySQL driver is available for Windows as a dynamic-link library.
When you deploy a database application that uses DBX4MySQL, you need only include the driver dll with the application files you build.
DBX4MySQL driver provides very fast access to MySQL through native MySQL network protocol.
DBX4MySQL driver supports transactions on MySQL server.
DBX4MySQL already works on the core we've developed for DAC for MySQL future 3.x version.
The main features of dbExpress driver for MySQL are:
Does not contain any third-party GPL-licensed components;
Licensed per a developer without royalty fee: you don't need to purchase end-user run-time licenses at all;
Any MySQL libraries are not requred on a client workstation, even libmysql.dll (which must be licensed on per seat basis for non-GPL commercial applications);
Linux/Kylix support (planned to be released at the end of this May);
Access to MySQL server through the native network protocol directly;
High performance;
Supports latest versions of MySQL;
All MySQL data types support;
Transaction support;
Complete fields information support;
Automatic detection for the old/new password algorithm (including the handling of the special 4.1.0 passwords);
Native SSL implementation in the Enterprise version (without any external libraries). 47
|
by DB Software Laboratory
|
Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources.
Very fast and reliable. Uses naitive API.
Data targets:
Oracle 7-9i database (using OCI API)
SQL server 7- 2000 (using BCP API)
ODBC source (using ODBC API)
Data sources:
Text files
Any ODBC source
Repository:
MS Access
Oracle
MS Sql Server
Interbase
MySQL
PostgreSQL
This product features:
Great performance - hundreds of records per second
Comprehensive logging
Rejected records file
Integrated Expressions builder
Allows the user to perform calculation during the loading process such as splitting fields, concatenations, data formatting, and loading cross/pivot tables.
Oracle
There are two ways of loading available:
Oracle direct path loading
Conventional path
MS SQL server
This software uses the same API as Microsoft DTS service.
ODBC
Any ODBC compliant database.
Other features are:
Easy Repository switching
Data Preview
Mapping editor
Exports
SQL scripts editor
Packages editor
Integrated Scheduler
Logging
Lookups
Email Notifications
File Operations
Check Files
Compare Files
FTP Downloads
Applications 30
|
by Mach5 Enterprises
|
Take the bulk out of email! Simple, Free, and Effective. Send personalized email messages
to customers, from any database source including Access and Excel, with conditional
content, HTML formatting, and attachments.
Great for newsletters and announcements! Schedule your mailing for
low bandwidth hours. See exactly what your contacts see with advanced
preview. Click send for fast multi threaded delivery, and process
the inbound email with ease. Your contacts get a personal message
with content relevant to just them.
HTML capability allows you to send combined HTML and plain text
messages, and HTML Import from web greatly simplifies sending HTML
messages. Attachments are automatically encoded and can come from a
field in your database. Each person can get a different attachment.
Message filtering allows you to send to just the customers you
intend, using contents of your database.
Also includes PopMonger, an inbound email handling utility, to
conduct confirmed opt in management, manage failed messages,
unsubscribe requests, auto replies, and redirection You can process
these requests and also catch personal replies too.
For larger enterprises, Mach5 Mailer Gold also includes the
capability for powerful scripting using VBasic, JScript, and PHP.
Can connect to any database via ODBC, will inline graphics with your
HTML, and includes SOCKS Proxy support. Great for enterprises, you
can program the content of each individual message and even open
separate database connections for each message Mailer sends.
With ODBC support, Mailer can connect to any database that supports
this common standard. Even over the internet or across your LAN.
Note. Mailer is not licensed for sending unsolicited email and
includes anti spam provisions.
Three Editions. Free Edition sends up to 200 messages at once.
Mailer Regular is 99.95 USD, and Gold is 249.95 18
|
by microOLAP Technologies LTD
|
DAC for MySQL (also known as MySQLDAC) is the most powerful component suite for Delphi/C++Builder/MySQL.
This component suite allows you to create Delphi/C++Builder applications with direct access to MySQL DB without BDE and ODBC.
BLOB fields are supported. MySQLDAC was developed for easy migration of existing projects from BDE/ODBC scheme to the native one.
Any MySQL library is not required.
TDBImageEx component for JPEG images support included in package for free (with sources).
DAC for MySQL(tm) is a royalty-free product.
Update policy:
(1) All minor updates (Versions .xx) for free;
(2) Any updates during one year for free. 14
|
by microOLAP Technologies LTD
|
PostgresDAC is PostgreSQL BDE replacement for Delphi/C++Builder.
It allows to create Delphi/C++Builder applications with the direct access to PostgreSQL DB without BDE and ODBC.
This components set was developed for easy migration of existing projects from BDE/ODBC scheme to the native one.
Interface is BDE-like and TDataSet compatible.
TDBImageEx component for JPEG images in BLOBs support included in package for free (with sources).
Royalty free product. 14
|
by ABIdeal.com
|
SQLIdl is a Universal Web based Command Line Database (SQL) Tool for Application Developers
Features:
- Execute SQL Commands (DML/DDL)
- Invoke from Windows Start-->Run (command line)
- Connect any database by changing the connection string at run time. Tested databases are:
- Oracle
- SQL Server
- Preconfigure settings, so that you need not bother about typing in everytime:
- Connection string (Database, username, password)
- Frequently used SQLs
- SQLs for retrieving table/view/trigger/stored procedure definitions
- DML commands like Insert/Update need a password for preventing tampering
of database opened up using this utility. This Password is configurable (default: mypwd)
- Generation of Insert/Update command based on query results.
Retrieve from Oracle and insert/update into SQL Server or vice-versa
as it is or after typing in changes visually!!!
- Multiline data can be retrieved, changed and updated back
- Works fine with CLOB/LONG types
- Use multiple statements separated by semicolon!!! For ex: select * from dept;select * from emp
Requires .Net Framework (I use v1.1), MDAC 2.6, Internet Explorer (IE 5.5)
Installation and usage:
After installing to a IIS Virtual Folder, open Web.config from the Virtual folder and change the key conStr_def to point to your database. Please change other values if necessary.
open IE and type in as follows:
http://localhost/SQLIdl/SQLIdl.aspx
You would need to provide the correct virtual folder if you changed it during installation. Type in your SQL query and enjoy!!!
To install the command line utility, simply copy the two files SQL.exe and SQLIdl.ini to your workstation windows system32 folder, open SQLIdl.ini in notepad and provide the correct path to IIS.
Now just invoke run from Start Menu, type in your query as follows :
sql "select * from dept"
It is THAT simple!!!
If you like SQLIdl, please buy ($10 only). 12
|
by MonocerosSoft
|
Database Web Explorer is an universal Web-based database manager intended to work with DBMS in Internet/Intranet networks. Database Web Explorer allows you to manipulate the data stored in databases via Internet. As programm of the remote access the usual Web-browser is used. Database Web Explorer was developed with ASP technology in pure script language and does not required installation of any additional COM-components, DLL or ActiveX neither on the Web-server nor on the computer of the user. Database Web Explorer is distributed in source codes - HTML and JavaScript. Supports connections to databases through ODBC drivers and OLE DB providers. Configuration and installation of Database Web Explorer is very easy. The product works under the Web-server Microsoft Internet Information Server.
Common features:
- Very easy installation, configuration and usage
- Supports the multiuser work with DBMS
- Does not required installation of any additional COM-components, DLL or ActiveX neither on the Web-server nor on the computer of the user
- As programm of the remote access the usual Web-browser is used
- Supports connections to databases through ODBC drivers and OLE DB providers
- Compact code in pure script language
Database Web Explorer allows you:
- Connect to any DBMS via ODBC or OLE DB
- View names of tables, fields, indexes and stored procedures in database
- View definitions of fields and indexes of tables in database
- View data in tables in database
- Export data in tables to MS Excel and as SQL-script
- Add, edit and delete record in tables in database
- Execute SQL-queries to database
- Export results of queries to MS Excel 11
|
by XL Consulting GmbH
|
Excel Compare is a tool that allows you to compare and update Excel files, Excel spreadsheets and individual ranges of sheets. Excel Compare offers three different possibilities for using the variations results:
1. MARK DIFFERENCES
Excel Compare marks the differences of the underlying spreadsheets and tables. Differences are marked with the following colors:
- orange for different cell entries
- green for added and columns and rows
- light blue for deleted columns and rows
At one glance Excel Compare clearly displays all differences and you may decide with which version of the spreadsheet you wish to proceed.
2. CREATE A DIFFERENCE REPORT
If desired, you may display the result of the comparison in a reader friendly difference report. On this report you not only see the rows or columns deleted and/or added, but also each individual cell with different values.
3. ANALYZER / UPDATE
The third and certainly most comfortable function of Excel Compare is the "Analyzer" tool: After the comparison process the spreadsheets are displayed vertically or horizontally and a user friendly tool bar is displayed, with which you may easily navigate through the differences. Excel Compare ensures that both tables are displayed on your screen in order for you to directly compare all differences. At this point you may decide with which version you wish to continue. With mouse-clicks you may transfer values from table 1 to table 2 or vice versa. This is the quickest way to eliminate all differences and within a short period of time you will have your Excel spreadsheet perfectly updated. 8
|
by Ariacom
|
Ariacom Business Reports is a database reporting and multi-dimensional
analysis tool with dynamic SQL generation. Non-technical end-users can run
and edit complex reports from any SQL relational database.
The product is able to meet a whole range of reporting requirements, from
publishing a directory over the intranet to multi-dimensional analysis on a
data-warehouse.
The product's main features are:
- Dynamic and optimized SQL queries
- Generation of complex reports integrating pivot tables
- Native line, bar, point and pie charts
- Integrated security management limiting user access
- Fully multilingual design (currently in English, French, German, Spanish)
- Report results in various formats (html, csv, txt, xml with conversion to
pdf)
- Output to various devices (file, printer, fax, email, ftp)
- Cascade reports allowing multi-dimensional navigation
- Publication and sharing of reports and results
- Simple to install and configure
- ActiveX to be integrated into any Win32 applications
Functions limited in the free version:
Report Scheduler, Web Report Server,
Drill navigation, Running totals, Ranking, Formulas, Custom Templates 7
|
by Markosoft Inc
|
The Markosoft Database Assistant is an all-in-one database access tool for use in viewing and editing data from virtually every major type of database including Oracle, MS SQL Server, Informix, MS Access, Sybase, and dBase. Features include the ability to perform wildcard queries, insert, update and remove records, query generating capabilities, free-form queries, and the ability to create ASCII files and insert records from ASCII files.
Additionally, the Database Assistant provides a way to pre-configure all of the data sources that you commonly use, which also provides a way to select a database in just seconds using a single button click.
Finally, shortcuts for accessing FTP accounts via the WS_FTP application can be created with the Database Assistant and quick access menu options are available for displaying individual table definitions and for viewing the records in a list view.
The Database Assistant includes an easy to use interface and many advanced features that are not even found in much more expensive database access applications. Additionally, the flexibility of performing direct entry into data fields or using free-form SQL statements for updating and retrieving records along with a much lower purchase price gives the Database Assistant a definite advantage over the competition. Increase the productivity of all of your data access and manipulation tasks today with the Database Assistant. 7
|
by UES Ltd trading as UNITY
|
| Universal Table Browser is a fully functioning Query Tool giving you access to ANY database using ODBC. A well designed graphical user interface means that you can simply point and click your way to complex SQL statements or use the SQL editor to write your own query. The browser has been optimized for MASSIVE databases, capable of dealing with MILLIONS of rows and thousands of columns and is capable of delivering data to you at blistering speed, the likes of which you've never seen before. Universal Table Browser is stable and super fast. During product demos we've seen people fall off their chairs at the speed (honest). It is a technically superior product and performs exceptionally well against all databases, from the smallest Access database to the largest enterprise system. It is a simple to use, super efficient query tool. It gives sufficient functionality for ANY database professional or end user to build and execute SQL queries against their databases. The Universal Table Browser has been extensively proven on the road as an effective query tool. It has been developed out of frustration with the inadequacies of existing tools. It is used on a daily basis against large, varied and "real" databases. Universal Table Browser can run against large databases (over 10,000 tables) and MASSIVE tables (over 100 million rows), especially mainframes and mini systems. Download your fully functional free evaluation today and we guarantee you will not be disappointed ! 2
|
by DB Software Laboratory
|
Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files, cross tables or ODBC datasources.
Very fast and reliable. Uses naitive API (OCI API,BCP API,ODBC API) Capable of performing calculation during import, may also execute SQL statemts before and after import.
Integrated expression builder, comprehensive error log, rejected records file. Source Data Filtering 2
|
by Christian C. Rasmussen
|
ATAF can automatic convert a MS-Access or ODBC database LikemySQL, MS-SQL server, Oracle, IBM DB2 or Lotus Notes database table in to a full grown ASP application as a HTML form with fields you select. ATAF creates the necessary Active server pages code (ASP), and navigation buttons. so you online can edit/add/delete upload pictures and search in your database records online.
ATAF Creates 7 HTML pages with ASP ( Active server pages ) code :
* A login page with username and password protection ( Optional )
* A Menu page
* A Form view where you can navigate, edit, create, copy, upload picture and delete record like in MS-access
* A page formatted to a print put of you form
* A list view like in MS-Access where you navigate, edit, create, copy all the records
* A search view where you can search in you records and edit them afterwards
* A SQL enter page, where you manually can execute SQL statements in your database
The ATAF application will then work as a HTML form on top of your database.
You also have many options to changing the design of you ATAF application. You can set the font size and colour on each element such Background colour, headers and footers and much more in a CSS supported format.
Also now ATAF includes a menu editor so you can customize the ATAF generated menus.
In version 6.0 it is also now possible to save you settings, in different profiles, so you don't have to enter all you settings each time you create a ASP application.
Version 6.0 also support colour templates so you easily can add a format to you application.
No need to make any ASP or HTML code the ATAF program will do everything for you. :-).
Just convert your database with ATAF, publish it to your web server, and you are running a database application on the internet. 1
|
|
|