Configure Specialized Features in UDA Drivers (Oracle RAC, SQL MARS, etc)

DB2

• Multi-Threading Support
  
• SQLCancel Support
  
• XA-Based Two-Phase Commit

Informix

• MS DTC
  
• OS Level Authentication
  
• XA-Based Two-Phase Commit

Ingres

• OS Level Authentication
  
• Return of TID value by SQLSpecialColumns(RowID)
  
• XA-Based Two-Phase Commit

MS SQL Server

• Auto-Discovery of SQL Server instances
  
• Database mirroring compatibility
  
• MS DTC
  
• Multiple Active Result Sets (MARS)
  
• Named Instance Support
  
• Single Sign On (including Windows NTLMv2 authentication)
  
• SSL Data Encryption
  
• Snapshot transaction isolation levels
  
• SQL Server Express Support
  
• XA-Based Two-Phase Commit

Oracle

• Connection Pooling
  
• Instant Client Support
  
• MS DTC
  
• Real Application Cluster (RAC) Support
  
• Reference Cursors in Stored Procedures
  
• Static, Keyset, Forward-Only Cursors
  
• XA-Based Two-Phase Commit

Progress

• User Level Transaction Isolation Levels configuration

Sybase

• Identity Column Support
  
• MS DTC
  
• XA-Based Two-Phase Commit