XPost: microsoft.public.sqlserver.programming   
   From: esquel@sommarskog.se   
      
   Jason Keats (jkeats@melbpcDeleteThis.org.au) writes:   
   > ADO was installed as part of MDAC, but is now part of WDAC which comes   
   > with the operating system of Windows Vista and later. ADO is not yet   
   > deprecated, and is (AFAIK still) THE way to access your SQL Server data   
   > - if you're not using a .NET programming language.   
   >   
      
   No, that would be ODBC.   
      
   ADO does not fully support new data types added to SQL Server. The ones   
   that are supported are only because they fit into the OLE DB framework   
   at the time, for instance the date data type. (Where as time does not   
   work, since the time data type in SQL Server does not mach TIME in   
   OLE DB.)   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)