MDAC 2.5 SDK - ODBC Desktop Database Drivers

Using the ExtendedAnsiSQL Connection String Attribute

Jet 4.0 has several new features that are not enabled by default in the ODBC Desktop Database Drivers version 4.0. To take advantage of these new features, an application will have to set a new connection attribute, add a new attribute to the connection string, or set the attribute in a DSN. The attribute is called ExtendedAnsiSQL and pertains only to the Microsoft ODBC Desktop Database Drivers 4.0 and later.

ExtendedAnsiSQL features:

• Setting ExtendedAnsiSQL
  
  
• Enabling New Data Types by Setting ExtendedAnsiSQL
  
  
• Creating and Dropping Views and Procedures Using ExtendedAnsiSQL
  
  
• Data Trunctation Detection Enabled Using ExtendedAnsiSQL
  
  
• Jet 4.0 Uses SQL-92 Reserved Words List when ExtendedAnsiSQL Set