---++ 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
























































































FeatureData Access MechanismProduct Format
New DBMS Support ExpressLiteMulti-Tier
[[NewDBChecklist?][DB2 8 & 9]]Check MarkCheck MarkCheck Mark
[[NewDBChecklist?][Firebird 1.5]]Check Mark
[[NewDBChecklist?][Informix 10 & 11]]Check MarkCheck MarkCheck Mark
[[NewDBChecklist?][Ingres R3]]Check MarkCheck MarkCheck Mark
[[NewDBChecklist?][Microsoft SQL Server 2005]]Check MarkCheck MarkCheck Mark
[[NewDBChecklist?][MySQL 4.x & 5.x]]Check MarkCheck MarkCheck Mark
[[NewDBChecklist?][Oracle 11]]
[[NewDBChecklist?][PostgreSQL 8]]Check MarkCheck MarkCheck Mark
[[NewDBChecklist?][Progress 91E04 &10.x]] Check MarkCheck Mark
[[NewDBChecklist?][Sybase 15]] Check MarkCheck MarkCheck Mark
Platform Support ExpressLiteMulti-Tier
[[NewOSChecklist?][Mac OS X 10.5 x86(64bit Mode)]]
[[NewOSChecklist?][Mac OS X 10.x x86]]Check MarkCheck MarkCheck Mark
[[NewOSChecklist?][Mac OS X 10.x PPC]]Check MarkCheck MarkCheck Mark
[[NewOSChecklist?][Linux & Unix (32bit)]]Check MarkCheck Mark
[[NewOSChecklist?][Linux & Unix (64bit)]]Check MarkCheck Mark
[[NewOSChecklist?][Windows Itanium2 (IA-64)]]Check MarkCheck Mark
[[NewOSChecklist?][Windows Opteron (x86_64)]]Check MarkCheck MarkCheck Mark
[[NewOSChecklist?][Windows Xeon (x86_64)]]Check MarkCheck MarkCheck Mark

ODBC Compliance ExpressLiteMulti-Tier
[[ODBCChecklist][Core]]Check MarkCheck MarkCheck Mark
[[ODBCChecklist][Level 1]]Check MarkCheck MarkCheck Mark
[[ODBCChecklist][Level 2]]Check MarkCheck MarkCheck Mark
SQL Compliance ExpressLiteMulti-Tier
[[SQLChecklist][SQL92]]Check MarkCheck MarkCheck Mark
License Management ExpressLiteMulti-Tier
[[LicensingChecklist?][Distributed License Management]]Check MarkCheck MarkCheck Mark
Performance & Stability ExpressLiteMulti-Tier
[[EnterpriseChecklist?][Enterprise Performance]]Check MarkCheck Mark
[[EnterpriseChecklist?][Enterprise Stability]]Check MarkCheck Mark
Unicode Support ExpressLiteMulti-Tier
[[UnicodeChecklist?][Unicode]]Check MarkCheck MarkCheck Mark
Data Type Support ExpressLiteMulti-Tier
[[DataTypeChecklist?][Microsoft SQL Server NCHAR, NVARCHAR]] Check MarkCheck MarkCheck Mark
[[DataTypeChecklist?][Microsoft SQL Server LARGE Value Data Types (NVARCHAR (max), VARBINARY (max), VARCHAR (max)]]Check MarkCheck Mark
[[DataTypeChecklist?][Microsoft SQL Server XML Data Type]]Check MarkCheck Mark
[[UnicodeChecklist?][MySQL? Unicode Data Types]]Check MarkCheck MarkCheck Mark
[[DataTypeChecklist?][Oracle BINARY FLOAT, BINARY DOUBLE]]Check MarkCheck MarkCheck Mark
[[DataTypeChecklist?][Oracle BLOB, CLOB]]Check MarkCheck MarkCheck Mark
[[DataTypeChecklist?][Oracle TIMESTAMP (with Time Zone, Local Time Zone)]]Check MarkCheck MarkCheck Mark
[[UnicodeChecklist?][PostgreSQL? Unicode Data Types]]Check MarkCheck MarkCheck Mark
Security & Authentication ExpressLiteMulti-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 MarkCheck Mark
[[RulesChecklist?][Serverside Rules-based Security]]Check Mark
[[SSLChecklist][SSL Data Encryption]]Check MarkCheck Mark
Wire Protocol ExpressLiteMulti-Tier
[[WireChecklist?][Microsoft SQL Server]]Check MarkCheck MarkCheck Mark
[[WireChecklist?][MySQL]]Check MarkCheck MarkCheck Mark
[[WireChecklist?][PostgreSQL]]Check MarkCheck MarkCheck Mark
[[WireChecklist?][Sybase]]Check MarkCheck MarkCheck Mark
Clustering (Failover, Balancing) ExpressLiteMulti-Tier
Diagnostic Resources ExpressLiteMulti-Tier
Built-in Clientside Tracing?Check MarkCheck MarkCheck Mark
Connection Logging?Check Mark
Database Specific Capabilities ExpressLiteMulti-Tier
[[BuiltInCapabilityChecklist?][DB2 - Multi-Threading Support]]Check MarkCheck Mark
[[BuiltInCapabilityChecklist?][DB2 - SQLCancel Support]]Check MarkCheck 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 MarkCheck Mark
[[DTCChecklist][Ingres - XA-Based Two-Phase Commit]]Check Mark
[[SQLAutoDiscoveryChecklist?][Microsoft SQL Server - Auto-Discovery of SQL Server instances]]Check MarkCheck Mark
[[SQLMirroringChecklist?][Microsoft SQL Server - Database mirroring compatibility]]Check MarkCheck Mark
[[DTCChecklist][Microsoft SQL Server - MS DTC]] Check Mark
[[SQLMARSChecklist][Microsoft SQL Server - Multiple Active Result Sets (MARS)]] Check MarkCheck Mark
Microsoft SQL Server - Named Instance Support? Check MarkCheck Mark
[[SQLSnapshotLevelsChecklist?][Microsoft SQL Server - Snapshot transaction isolation levels]]Check MarkCheck Mark
Microsoft SQL Server - SQL Server Express Support?Check MarkCheck Mark
[[DTCChecklist][Microsoft SQL Server - XA-Based Two-Phase Commit]] Check Mark
Oracle - Connection Pooling?Check MarkCheck Mark
Oracle - Instant Client Support?Check MarkCheck Mark
[[DTCChecklist][Oracle - MS DTC]]Check Mark
Oracle - Real Application Cluster (RAC) Support?Check MarkCheck Mark
[[BuiltInCapabilityChecklist?][Oracle - Reference Cursors in Stored Procedures]]Check MarkCheck Mark
[[BuiltInCapabilityChecklist?][Oracle - Static, Keyset, Forward-Only Cursors]]Check MarkCheck Mark
[[DTCChecklist][Oracle - XA-Based Two-Phase Commit]]Check Mark
Progress - User Level Transaction Isolation Levels configuration?Check MarkCheck Mark
[[BuiltInCapabilityChecklist?][Sybase - Identity Column Support]]Check MarkCheck Mark
[[DTCChecklist][Sybase - MS DTC]]Check Mark
[[DTCChecklist][Sybase - XA-Based Two-Phase Commit]]Check Mark
Other ExpressLiteMulti-Tier
[[ADONETChecklist][ADO.NET 2.0 Support]]Check MarkCheck Mark
[[ADONETChecklist][Visual Studio 2005 Integration]]Check MarkCheck Mark