The ANSI_DEFAULTS Setting of the SQL Server 6.5 Driver

One of the significant improvements implemented with SQL Server 6.5 is compliance to the ANSI standard. The ODBC driver for SQL Server 6.5 uses and enforces that syntax. When the driver sets ANSI_DEFAULTS to ON, the following ANSI standards are activated:

• ANSI_NULLS
  
  
• ARITHABORT
  
  
• ANSI_NULL_DFLT_ON
  
  
• CURSOR_CLOSE_ON_COMMIT
  
  
• ANSI_PADDING
  
  
• IMPLICIT_TRANSACTIONS
  
  
• ANSI_WARNINGS
  
  
• QUOTED_IDENTIFIER

Queries written by Microsoft Access adhere to these standards. Avoid problems by writing your queries to the ANSI standards, too. For more information, see SQL Server Books Online. Also see Knowledge Base Articles Q135533 INF, "Differences in SQL Behavior Between ODBC and ISQL," and Q152032 INF, "Changes to SQL Server 6.5 That Affect 6.0 Apps."