Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 25 Mar 2004 @ 20:18:40 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Data Access with ODBC.NET
From:   Dempsey, Mike

As with most of Microsoft's 'high level' data access tools they are built to provide good functionality for SQL Server.

.Net probably has less functionality that any of the earlier tools. The one with the most functionality is the base ODBC API itself. ADO (pre .Net) also has missing functionality - and no way around it. RDO has missing functionality, but allows you to 'drop down' into the ODBC API if you need anything that is missing.

I therefore recommend that anyone building a new ODBC based app stick with RDO if they may need anything that is not 'Standard'. It may be old ... But it works.

(The API itself also works well ... But it is a lot of work, and requires close attention to detail/specs, if you go that route.)

Teradata is the only database that I know of that can tell you the number of rows in the answer set BEFORE it returns them. As a result this is basically 'non-standard' functionality.

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016