Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 26 Sep 2011 @ 18:58:55 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: ODBC versus .NET with SQLA
From:   Dempsey, Mike

The simple answer is Yes.

In general the Teradata.Net option will be faster than ODBC and will give you access to more functionality.

In some cases the performance can be considerably faster.

When Microsoft created the ODBC interface to .Net they did so as a 'temporary' measure. Their feeling is that all .Net applications should use vendor specific .Net Data providers.

As a result they only partially implemented the ODBC interface - meaning that some features simply don't work.

Add the fact that the interface has a number of bugs in it - and Microsoft don't plan to fix them - and you can see that using ODBC has its limitations.

Refer to the 'Release Notes' link in the Teradata SQL Assistant program group for more information on limitations.

The product documentation also refers to some features that are not supported through ODBC.

There is also a series of articles about the new features in SQLA 13.0, 13.10, 13.10 Edition 2 and 13.11 available on the Teradata Developer Exchange (developer.teradata.com/...) under the Tools section.

Note that the latest version of SQL Assistant 13.10 is (or if you want additional features)

Mike Dempsey
Teradata Client Tools

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