| ODBC Driver Compliance
Level 2 Compliant.
Full SQL Support
 |
Supports ODBC SQL. (Insert,
Update, Select, Delete) |
|
Supports Group By and Distinct
and aggregate functions (AVG, MIN, MAX, SUM, COUNT) |
|
Supports nested inner and
outer left/right joins. |
|
Supports subqueries and
correlated subqueries. |
|
Supports substring and date
functions. |
Multithreaded Asynchronous Execution
Supports the ODBC Asynchronous execution model and true 32bit threads for each
SQL Statement being executed. This feature makes it possible to have a query running in
the background while performing other meaningful work.
Data Conversion
CONNX supports all RDB data types except BLOB (binary large object) data types.
Compatibility
CONNX works with any ODBC compliant application. CONNX has been tested with
the 16bit and 32bit versions of Microsoft Access, Microsoft Visual Basic, Crystal Reports,
Delphi, PowerBuilder, Impromptu, Lotus Approach, I.Q..
Fast Joins, Fast throughput.
CONNX has turbo charged its proprietary RFFA Technology, resulting in faster
multi-table joins, and an increase in speed when performing searches on non-keyed fields.
Fast CONNX Data Dictionary.
The CONNX data dictionary uses the Microsoft Component Object Model (COM) format,
resulting in fast access to information in the data dictionary, and fast queries.
Mass record definition imports
CONNX Imports table definitions directly from your RDB database.
Security
The CONNX CDD utility supports setting up field and table level security by group
as well as individuals. CONNX also supports row level security with CONNX views.
Additionally, the CONNX data dictionary is encrypted to secure sensitive information.
Views
CONNX supports the creation of views, which facilitate hiding table relationships
from the end user. CONNX views facilitate the creation of heterogeneous joins
between multiple databases.
Wizards
CONNX includes a Data Dictionary Wizard that greatly reduces startup time, and
truly provides instant access to your data. CONNX also includes application wizards for
Microsoft Access, Visual Basic, Crystal Reports and Impromptu.
RPC (Remote Procedure Call)
Command Execution
CONNX provides an RPC mechanism that allows remote execution of batch jobs,
command procedures, and applications from a PC.
System Requirements
PC
|
TCP/IP (Winsock 1.1 or above)
or Pathworks 4.0 or above |
|
Windows 95 / Windows NT |
|
8 Meg of memory (16
recommended) |
|
50 Meg of hard drive space
free recommended. |
VAX/Alpha
|
VMS 5.4 or above |
|
TCP/IP (UCX or compatible) or
Pathworks |
|
RDB version 6 or above running
under VMS or UNIX |
For more information or to order an evaluation, please contact us
|
