Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HELP! Linking a Teradata Server in SQL 2K

Status
Not open for further replies.

karuzi

IS-IT--Management
Apr 2, 2003
5
US
I am trying to link a Teradata server to a SQL Server. I am getting various errors surrounding making the connection. I have created a SystemDSN and included the authentication credentials in it, but I get Authentication Failed message.

Any tips? I have installed the Teradata OLE DB Provider 1.1.

Thanks for any help
 
I use DTS to move data between them, did you want to do that or write selects to include data from both db's?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top