 |
 |
Archives of the TeradataForum
Message Posted: Sat, 03 Aug 2002 @ 09:33:57 GMT
| Subj: | | Re: Linked Server from SQL Server to Teradata |
| |
| From: | | Dieter N�th |
Hi Mike,
| | Thank you. We figured it out. you have to use OpenQuery in SQL Server. You can not query the tables directly. | |
| | select top 100 * from openquery(rchtera, 'select * from cust.cust_oms') | |
I'm able to do a
select * from teradata_linked_server..dbname.tablename
and i didn't do anything special, just added a new linked server.
V2R4.1, ODBC3.1.0.0, SQL2000
Dieter
| |
