Dialect

Sets or returns the dialect to be used for the CommandStream or CommandText properties.

The Dialect property, new to ADO 2.6, sets or returns the dialect to be used for the CommandStream or CommandText properties. This is a provider-independent Globally Unique IDdentifier which allows the provider to support multiple dialects. Its main use is in XML-generated Recordsets, where it identifies what form of XML the Recordset is stored in. The default dialect is standard SQL which has the following GUID:

 

   {C8B521FB-5CF3-11CE-ADE5-00AA0044773D}

 

And for the SQL XML format used by SQL Server 2000 the GUID is ...

 

   {5D531CB2-E6ED-11D2-B252-00C04F681B71}