%META:TOPICPARENT{name="SupportIndex"}% ---++ UDA Drivers Comparison Guide OpenLink's 6.x Data Access Drivers feature set is listed below. Use the checklist to see which feature appears in which driver. Use individual feature hyperlinks to learn how to configure or otherwise access the feature. If you want to evaluate a previous version of the drivers, contact OpenLink Product Support for product feature lists and comparison information. ---+++ Feature Categories * New DBMS Support * Platform Support * ODBC Compliance * SQL Compliance * License Management * Perfomance & Stability * Unicode Support * Data Type Support * Security & Authentication * Wire Protocol * Clustering (Failover, Balancing) * Diagnostic Resources * Database Specific Capabilities * Other Capabilities
Feature   Product Format
New DBMS Support   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[NewDBChecklist][DB2 8 & 9]] Check Mark Check Mark Check Mark
[[NewDBChecklist][Firebird 1.5]] Check Mark
[[NewDBChecklist][Informix 10 & 11]] Check Mark Check Mark Check Mark
[[NewDBChecklist][Ingres R3]] Check Mark Check Mark Check Mark
[[NewDBChecklist][Microsoft SQL Server 2005 and 2008]] Check Mark Check Mark Check Mark
[[NewDBChecklist][MySQL 4.x & 5.x]] Check Mark Check Mark Check Mark
[[NewDBChecklist][Oracle 11]]
[[NewDBChecklist][PostgreSQL 8]] Check Mark Check Mark Check Mark
[[NewDBChecklist][Progress 91E04 &10.x]] Check Mark Check Mark
[[NewDBChecklist][Sybase 15]] Check Mark Check Mark Check Mark
Platform Support   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[NewOSChecklist][Mac OS X 10.5.x–10.6.x x86 (64-bit Mode)]] Check Mark Check Mark
[[NewOSChecklist][Mac OS X 10.4.x–10.6.x x86 (32-bit Mode)]] Check Mark Check Mark Check Mark
[[NewOSChecklist][Mac OS X 10.0.x–10.5.x PPC]] Check Mark Check Mark Check Mark
[[NewOSChecklist][Linux & Unix (32-bit)]] Check Mark Check Mark
[[NewOSChecklist][Linux & Unix (64-bit)]] Check Mark Check Mark
[[NewOSChecklist][Windows Itanium2 (IA_64)]] Check Mark Check Mark
[[NewOSChecklist][Windows Opteron (x86_64)]] Check Mark Check Mark Check Mark
[[NewOSChecklist][Windows Xeon (x86_64)]] Check Mark Check Mark Check Mark
ODBC Compliance   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[ODBCChecklist][Core]] Check Mark Check Mark Check Mark
[[ODBCChecklist][Level 1]] Check Mark Check Mark Check Mark
[[ODBCChecklist][Level 2]] Check Mark Check Mark Check Mark
SQL Compliance   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[SQLChecklist][SQL-92]] Check Mark Check Mark Check Mark
License Management   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[LicensingChecklist][Distributed License Management]] Check Mark Check Mark Check Mark
Performance & Stability   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[EnterpriseChecklist][Enterprise-grade Performance]] Check Mark Check Mark
[[EnterpriseChecklist][Enterprise-grade Stability]] Check Mark Check Mark
Unicode Support   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[UnicodeChecklist][Unicode]] Check Mark Check Mark Check Mark
Data Type Support   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[DataTypeChecklist][Microsoft SQL Server NCHAR, NVARCHAR]] Check Mark Check Mark Check Mark
[[DataTypeChecklist][Microsoft SQL Server LARGE Value Data Types (NVARCHAR (max), VARBINARY (max), VARCHAR (max)]] Check Mark Check Mark
[[DataTypeChecklist][Microsoft SQL Server XML Data Type]] Check Mark Check Mark
[[UnicodeChecklist][MySQL Unicode Data Types]] Check Mark Check Mark Check Mark
[[DataTypeChecklist][Oracle BINARY FLOAT, BINARY DOUBLE]] Check Mark Check Mark Check Mark
[[DataTypeChecklist][Oracle BLOB, CLOB]] Check Mark Check Mark Check Mark
[[DataTypeChecklist][Oracle TIMESTAMP (with Time Zone, Local Time Zone)]] Check Mark Check Mark Check Mark
[[UnicodeChecklist][PostgreSQL Unicode Data Types]] Check Mark Check Mark Check Mark
Security & Authentication   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[OpsysLoginChecklist][Ingres OS Level Authentication]] Check Mark
[[OpsysLoginChecklist][Informix OS Level Authentication]] Check Mark
[[SSOChecklist][Microsoft SQL Server Single Sign On (including Windows NTLMv2 authentication)]] Check Mark Check Mark
[[RulesChecklist][Serverside Rules-based Security]] Check Mark
[[SSLChecklist][SSL Data Encryption]] Check Mark Check Mark
Wire Protocol   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[WireChecklist][Microsoft SQL Server]] Check Mark Check Mark Check Mark
[[WireChecklist][MySQL]] Check Mark Check Mark Check Mark
[[WireChecklist][PostgreSQL]] Check Mark Check Mark Check Mark
[[WireChecklist][Sybase]] Check Mark Check Mark Check Mark
Clustering (Failover, Balancing)   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
Diagnostic Resources   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[Built-in Clientside Tracing]] Check Mark Check Mark Check Mark
[[Connection Logging]] Check Mark
Database Specific Capabilities   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[BuiltInCapabilityChecklist][DB2 - Multi-Threading Support]] Check Mark Check Mark
[[BuiltInCapabilityChecklist][DB2 - SQLCancel Support]] Check Mark Check Mark
[[DTCChecklist][DB2 - XA-Based Two-Phase Commit]] Check Mark
[[DTCChecklist][Informix - MS DTC]] Check Mark
[[DTCChecklist][Informix - XA-Based Two-Phase Commit]] Check Mark
[[BuiltInCapabilityChecklist][Ingres - Return of TID value by SQLSpecialColumns(RowID)]] Check Mark Check Mark
[[DTCChecklist][Ingres - XA-Based Two-Phase Commit]] Check Mark
[[SQLAutoDiscoveryChecklist][Microsoft SQL Server - Auto-Discovery of SQL Server instances]] Check Mark Check Mark
[[SQLMirroringChecklist][Microsoft SQL Server - Database mirroring compatibility]] Check Mark Check Mark
[[DTCChecklist][Microsoft SQL Server - MS DTC]] Check Mark
[[SQLMARSChecklist][Microsoft SQL Server - Multiple Active Result Sets (MARS)]] Check Mark Check Mark
[[Microsoft SQL Server - Named Instance Support]] Check Mark Check Mark
[[SQLSnapshotLevelsChecklist][Microsoft SQL Server - Snapshot transaction isolation levels]] Check Mark Check Mark
[[Microsoft SQL Server - SQL Server Express Support]] Check Mark Check Mark
[[DTCChecklist][Microsoft SQL Server - XA-Based Two-Phase Commit]] Check Mark
[[Oracle - Connection Pooling]] Check Mark Check Mark
[[Oracle - Instant Client Support]] Check Mark Check Mark
[[DTCChecklist][Oracle - MS DTC]] Check Mark
[[Oracle - Real Application Cluster (RAC) Support]] Check Mark Check Mark
[[BuiltInCapabilityChecklist][Oracle - Reference Cursors in Stored Procedures]] Check Mark Check Mark
[[BuiltInCapabilityChecklist][Oracle - Static, Keyset, Forward-Only Cursors]] Check Mark Check Mark
[[DTCChecklist][Oracle - XA-Based Two-Phase Commit]] Check Mark
[[Progress - User Level Transaction Isolation Levels configuration]] Check Mark Check Mark
[[BuiltInCapabilityChecklist][Sybase - Identity Column Support]] Check Mark Check Mark
[[DTCChecklist][Sybase - MS DTC]] Check Mark
[[DTCChecklist][Sybase - XA-Based Two-Phase Commit]] Check Mark
Other   Single-Tier "Express" Edition Single-Tier "Lite" Edition Multi-Tier "Enterprise" Edition
[[ADONETChecklist][ADO.NET 2.0 Support]] Check Mark Check Mark
[[ADONETChecklist][Visual Studio 2005 Integration]] Check Mark Check Mark