[dba-SQLServer] SQL Server linked to Teradata

ODBC drivers have various levels of conformance.

I've run into some that are very basic (don't ask me what I think of Jade)

Many proprietary systems are not even relational databases as we know them, they are 
Object Oriented and the ODBC driver is based on virtual tables  - which of necessity limits 
much of the DDL part of ODBC. (don't ask me what I think of Jade)

It's quite possible that the Teradata ODBC driver just doesn't support what you are trying to 
do.

-- 
Stuart

On 26 Mar 2009 at 14:45, Mark A Matte wrote:

> 
> Thanks Francisco,
>  
> I've hit almost every site google found that mentioned Teradata or linked servers.  The one funny part...is I CAN do this with Access as a pass-through query.
>  
> Anything you find would be much appreciated...but I would not expect you to put too much effort into it.
>  
> Thanks again,
>  
> Mark
>