Overview: DataDirect Connect64 for ODBC

View PDF

DataDirect Connect64 for ODBC drivers are built on the market-leading technology of DataDirect's 32-bit Connect for ODBC drivers and use the same high-performance wire protocol design. Through this clientless architecture, wire protocol ODBC drivers communicate at the database's native (wire) protocol, effectively removing a communication layer and eliminating the need for database client libraries.

This document provides a broad overview of all DataDirect Connect64 for ODBC drivers. Topics covered in this document include:

Highlights of the latest release of the DataDirect Connect64 for ODBC drivers can be accessed here.
When you are ready to evaluate the DataDirect Connect64 for ODBC drivers with your application, download the driver package. Contact us if you need assistance in evaluating the product.

Download | Buy Now

For information on DataDirect's 32-bit ODBC drivers, click here.

Cross-Platform Support for 64-Bit ODBC Applications to All Major Databases

You can count on DataDirect Technologies for reliable 64-bit connectivity regardless of database or platform. DataDirect Connect64 for ODBC supports all the current and most recent versions of a particular database - with a single driver. This broadens the versions of databases you can support in a commercial product and eliminates the need to change drivers every time you change database versions in an enterprise environment.

Wire Protocol ODBC - No Database Client Software Required

DataDirect Connect64 for ODBC drivers are available as "wire protocol", meaning that the drivers do not require installation and maintenance of database client software and libraries. This unique wire protocol architecture dramatically improves performance and eliminates the need to install and keep up with the various versions of database client libraries such as Oracle Net for Oracle 9i.

  • Proven even faster than programming database access using the database's native interface (such as Oracle OCI)
  • Reduces time testing against multiple versions of the client software
  • Much easier installation and administration of applications

Easy Migration to 64-Bit Applications

Because DataDirect Connect64 for ODBC is built on the same code base as DataDirect's 32-bit ODBC drivers, you get a consistent interface and the same reliability, functionality and performance as you evolve your applications to 64-bit. This common architecture reduces the learning curve, allowing developers to migrate applications to 64-bit platforms more quickly. In addition, in DataDirect, you have just one industry-leading vendor to deal with for all your data access needs for any platform, processor architecture, or database.

Enterprise-Quality Features

  • New MySQL Wire Protocol driver – DataDirect quality and reliability now available for MySQL
  • Performance Tuning Wizard to automatically achieve optimal driver performance.
  • No need to install database client software such as Oracle Net.
  • Consistently supports the latest, most complete implementation of the ODBC specification, as well as a consistent level of ODBC Core, Level 1, and Level 2 functions.
  • Supports Operating Systems (OS) authentication for Oracle, DB2 and Sybase.
  • Support for Oracle data types: CLOB, BLOB, Timestamp, XML Type, and National Language character data types (NCHAR, NVARCHAR2, NCLOB).
  • Supports all Oracle systems including Oracle 8.1.6 and higher from a single ODBC driver.
  • Oracle driver is highly optimized for applications that use LOB data and PL/SQL stored procedures.
  • Supports new Oracle 10g Float and Double Data types. Supports Oracle RAC servers and provides connection failover and load balancing.
  • Oracle TNS Names support - Allows use of centralized configuration information, easing deployment maintenance.
  • Support for SQL Server 2005 features such as MAX data types, XML data type, Snapshot transaction isolation levels and Stored Procedures as Managed Code Assemblies.
  • Supports all DB2 platforms - z/OS, Windows NT, Windows 2000, UNIX and IBM AS/400 - from one driver.
  • DB2 driver supports multiple result sets from stored procedures, SQLDescribeParam, full BLOB/CLOB and RowID data types.
  • Full UNICODE support.
  • Supports SSL data encryption for Oracle, DB2, and Sybase.
  • Supports IPv6 (Internet protocol version 6) in SQL Server, DB2, Sybase, and Informix wire protocol drivers.
  • Connection failover support and client-side load balancing for all databases.
  • Microsoft DTC (Distributed Transaction Coordinator) support for Oracle, SQL Server, Sybase and Informix.
  • Tested under production conditions using the most comprehensive ODBC testing suites in the industry.
  • Built-in debugging capabilities.
  • File DSN support on UNIX platforms - Eases distribution and reduces management of applications across all major network platforms.

All Major Databases Supported

See the database support matrix for a complete list of all the database versions supported.

All Major Platforms and Processor Architectures Supported

  • HP-UX 11i v1.6 and v2.0 for Intel Itanium
  • IBM AIX 5L (5.1, 5.2, and 5.3) on IBM PPC
  • Sun Solaris 8, 9, and 10 for Sun SPARC
  • Sun Solaris 10 for AMD/Intel x64
  • Red Hat Enterprise 3.0 and 4.0 for Intel Itanium
  • Red Hat Enterprise 4.0 for AMD/Intel x64
  • SuSE Enterprise Server 9.0 for AMD/Intel x64
  • Windows Server 2003 64-bit Edition on Intel Itanium and AMD/Intel x64
  • Windows XP Professional on AMD/Intel x64

See the support matrix for all the 64-bit platforms and processor architectures supported.

Download | Buy Now