Mysql Data Access Components and Active Query Builder Activex Edition Software for Windows

DBX4MySQL
$149.95 - 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).

---

---

BlackBerry Database Viewer
$19.95 - Cellica Software Services

View any desktop database on BlackBerry Device.
BlackBerry Database Viewer will help you to view the contents of your desktop databases like MS Access, FoxPro, dBase, Excel and any ODBC Compliant Database like Oracle, SQL Server on BlackBerry through the USB cable.

It has two components: One works on Microsoft Windows based Computer (i.e. desktop side) and other on BlackBerry handheld (i.e. device side). This device side application is also referred as BlackBerry Database Viewer. Use the Windows program to transfer your database tables to USB cable connected BlackBerry device.

Features:
view the records of your database tables in a grid form or even single record form.
Apply SQL queries on the desktop database before sending it to BlackBerry.
Transfer the desktop database to your BlackBerry without having any third party synchronization tool.
The data transfer will be taken place simply through the USB cable.
Supported databases: MS Access, Oracle, FoxPro, dBase, MS Excel, MySQL and any ODBC compliant databases.
Resize the column width in grid view as per user's convenience.
Make a phone call directly from the selected cell.

---

---

EMS SQL Management Studio for MySQL
$468 - EMS Database Management Solutions, Inc

EMS SQL Management Studio for MySQL is a complete solution for database administration and development. With components that focus on all critical database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering databases and managing database objects as well as for database migration, extraction, data import, export and comparison. SQL Studio unites these tools in one powerful and easy-to-use environment that can work round the clock. Whether you are a database or application developer, DBA or business analyst, EMS SQL Management Studio offers all essential tools to make you more productive than ever before!

SQL Studio Additional Features:
- Handy launch of utilities and services
- Storing all templates in a single repository
- Common data source list for all services and utilities
- Creating complicated tasks and scheduled tasks execution
- Ability to run external applications from scheduler
- Storing all task execution logs in one database
- Creating customized notifications with a variety of delivery options
- Ability to set visual interface style uniquely for all SQL Studio apps
- Fast access to EMS Technical Support Service

---

GiPo@DB_Utilities
$59 - Gibin Software House

GiPo@DB_Utilities is a set of utilities for Windows 95/98/ME/NT/2000/XP that provide an easy way to work with different OLE DB- and ODBC-compatible databases and data sources such as Microsoft SQL Server 7.0/2000, Oracle DBMS, Informix, MySQL, DB2, Microsoft Access, dBase, Paradox, FoxPro, Visual FoxPro and many other databases that have OLE DB providers.
Main Features:
Provides the visual browsing and editing for OLEDB- and ODBC-compatible databases.
Supports the connection to a DB using Microsoft Universal Data Link (UDL) files.
Supports the connecting to ODBC sources.
Provides the special connection dialog for the most popular databases (Microsoft SQL Server, Oracle, Inprice Interbase, FireBird, Yaffil, MySql, Microsoft Access, Microsoft FoxPro, dBase, Microsoft Excel).
Supports saving an existing connection to a Microsoft Universal Data Link (UDL) file.
Displays tables, table views, store procedure list, system tables, and system views.
Allows to view and edit the existing rows and to insert new rows.
Allows to view and edit LONG TEXT and BLOB fields.
Provides the image management for BLOB fields.
Provides the quick database navigation and search.
Allows to export rows to an external file, or to copy them to the Clipboard.
Allows to view the table information (columns, indexes).
Allows to view the stored procedure information (parameters, columns).
Provides the stored procedure execution.
Provides the SQL queries execution.
Supports the SQL queries with parameters.
Provides the table management (create table, drop table, add column, alter column, drop column).
Provides the table view management (create view, drop view).
Provides the stored procedure management (create, drop procedure).
Provides the SELECT Query Wizard.
Provides the SQL editor with the syntax highlight.
Provides the 'read-only' and 'DB editing' work modes.
Displays query results as a plain text.

---

Active Query Builder Delphi VCL Edition
$195 - Active Database Software

Active Query Builder is a true two-way visual query builder component for Delphi and C++ Builder that allows your end-users to build complex SQL queries via an intuitive visual interface easily. It differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the powerful and user-friendly interface that allows you to build queries involving unions and sub-queries.

The interface of Active Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. The unique features of Active Query Builder for Delphi such as the ability to build queries with unions and sub-queries make it the best solution for professional developers.

Active Query Builder supports Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, Informix, Sybase, SQLite, and ANSI-92 SQL dialects.

The sophisticated SQL parser with full Unicode support can translate any valid SQL statement into it's visual representation. You can use full range of database connectivity components as well as generic event-driven metadata provider to get metadata information from any data source.

Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects. Using Active Query Builder you'll be able to retrieve various information about parsed query like lists of tables and fields used in the query. Working with parameters in Active Query Builder, you may know their names and data types, and discover to what database objects and fields they are related to.

Using the Active SQL Query Builder you can customize SQL code the way you like it.

There are two editions available: the Standard Edition and the Free Edition. The Free Edition is fully functional, but supports only the ANSI-92 SQL dialect.

---

Active Query Builder ActiveX Edition
$295 - Active Database Software

Active Query Builder is a .Net-ready ActiveX visual query builder component to build complex SQL queries via an intuitive visual interface easily. It differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the powerful and user-friendly GUI that allows you to build queries involving unions and sub-queries.

Active Query Builder is a true two-way query builder, so you may combine visual query building with direct SQL query editing. The interface of Active Query Builder is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. The unique features of Active Query Builder such as the ability to build queries with unions and sub-queries make it the best solution for professional developers.

Active Query Builder supports Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, Interbase, Firebird, and other SQL dialects. The sophisticated Active SQL parser can translate any valid SQL statement into it's visual representation.

Active Query Builder can be used in any software project which supports ActiveX controls as well as in the .Net projects. For example, you can use it with Visual Basic 6.0, Visual Basic .NET, Visual C++ 6.0, Visual C#, PowerBuilder, Delphi and so on. Active Query Builder was successfully tested in Windows.Forms and ASP.NET environments, with .NET Framework 1.1 and 2.0.

In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance, for example in the ASP.NET environment. In this case, the most convenient solution would be to work with Active Query Builder in offline mode, loading metadata information from a previously saved XML file. It also makes loading metadata almost instant regardless of the number of objects being loaded.

---