%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 Data Access Mechanism Product Format
New DBMS Support   Express Lite Multi-Tier
[[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]] 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   Express Lite Multi-Tier
[[NewOSChecklist][Mac OS X 10.5 x86(64bit Mode)]]
[[NewOSChecklist][Mac OS X 10.x x86]] Check Mark Check Mark Check Mark
[[NewOSChecklist][Mac OS X 10.x PPC]] Check Mark Check Mark Check Mark
[[NewOSChecklist][Linux & Unix (32bit)]] Check Mark Check Mark
[[NewOSChecklist][Linux & Unix (64bit)]] 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   Express Lite Multi-Tier
[[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   Express Lite Multi-Tier
[[SQLChecklist][SQL92]] Check Mark Check Mark Check Mark
License Management   Express Lite Multi-Tier
[[LicensingChecklist][Distributed License Management]] Check Mark Check Mark Check Mark
Performance & Stability   Express Lite Multi-Tier
[[EnterpriseChecklist][Enterprise Performance]] Check Mark Check Mark
[[EnterpriseChecklist][Enterprise Stability]] Check Mark Check Mark
Unicode Support   Express Lite Multi-Tier
[[UnicodeChecklist][Unicode]] Check Mark Check Mark Check Mark
Data Type Support   Express Lite Multi-Tier
[[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   Express Lite Multi-Tier
[[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   Express Lite Multi-Tier
[[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)   Express Lite Multi-Tier
Diagnostic Resources   Express Lite Multi-Tier
[[Built-in Clientside Tracing]] Check Mark Check Mark Check Mark
[[Connection Logging]] Check Mark
Database Specific Capabilities   Express Lite Multi-Tier
[[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   Express Lite Multi-Tier
[[ADONETChecklist][ADO.NET 2.0 Support]] Check Mark Check Mark
[[ADONETChecklist][Visual Studio 2005 Integration]] Check Mark Check Mark