SQL 2005 64-bit - Teradata Linked server...not working

Connectivity

SQL 2005 64-bit - Teradata Linked server...not working

Hello everybody,

I have setup a linked server in SQL 2005 using:
1. 64-bit Teradata ODBC drivers (native OLE DB does not support 64-bit)
2. I use the Microsoft OLE DB provider for ODBC.

When executing a count from SQL Server to a teradata table it does work, i.e.:
1. Query:
SELECT COUNT(*) FROM TD..PRD_edw_views.offg;

2. Result:

-----------
4656

(1 row(s) affected)

When I try to select (*) the data from the table I get the following error. It does look like some sort of table definition is returned but not data, the error:
Offering Id Offering Start Dttm Offering End Dttm Offering Cd Offering Name Offering Desc Offering Launch Dttm Offering Termination Dttm Offering Type Cd Process Creation Dttm Process Closed Dttm File Id
----------- ----------------------- ----------------------- -------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- ------------------------- -------------------- ----------------------- ----------------------- -----------
OLE DB provider "MSDASQL" for linked server "TD" returned message "[Teradata][ODBC Teradata Driver][Teradata Database] Column/Parameter 'PRD_edw_views.Tbl1002.Offering Id' does not exist. ".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT "Tbl1002"."Offering Id" "Col1004","Tbl1002"."Offering Start Dttm" "Col1005","Tbl1002"."Offering End Dttm" "Col1006","Tbl1002"."Offering Cd" "Col1007","Tbl1002"."Offering Name" "Col1008","Tbl1002"."Offering Desc" "Col1009","Tbl1002"."Offering Launch Dttm" "Col1010","Tbl1002"."Offering Termination Dttm" "Col1011","Tbl1002"."Offering Type Cd" "Col1012","Tbl1002"."Process Creation Dttm" "Col1013","Tbl1002"."Process Closed Dttm" "Col1014","Tbl1002"."File Id" "Col1015" FROM "PRD_edw_views"."offg" "Tbl1002"" for execution against OLE DB provider "MSDASQL" for linked server "TD".

Anybody that have seen this error with linked servers?

Regards

Raino
1 REPLY
Teradata Employee

Re: SQL 2005 64-bit - Teradata Linked server...not working


Did you verify the view definition and match it with the SQL request? i.e., if the missing column indeed exist? You can do execute "show view PRD_edw_views.offg" from from SQLA or BTeq