Setup Linked Server from SQL Server 2005

[AndyKr]

Hi Guys

Anyone have any information on setting up a linked server to a Teradata system from SQL Server 2005.

I found this link on line but cannot get it to work correctly:

http://weblogs.sqlteam.com/phils/archive/2005/11/30/8466.aspx

Seems to me that that this code should work:
EXEC sp_addlinkedserver
@server = 'TDATA',
@srvproduct = 'Teradata',
@provider = 'MSDASQL',
@location = '[server_location_here]',
@provstr = 'DRIVER={Teradata};UID=[login_name];PWD=[password];'
GO

But all I get is the following error:
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].


----
Andy Kramek
Visual FoxPro MVP