• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 521
  • Last Modified:

how to link serversql server 2000 and Teradata

I am trying to connect the teradata as linkes server to SQL server 2000. I am not able to find the driver ofr tera data tough. ON macine we are using teradata as DSN connection(odbc). ANy help please?
0
mintmanin
Asked:
mintmanin
  • 5
  • 2
1 Solution
 
mintmaninAuthor Commented:
I dont see OBDC driver option for Terada in linked servers, what should i Do?
0
 
ZberteocCommented:
Download it and install it from here:

http://www.teradata.com/downloadcenter/
0
 
mintmaninAuthor Commented:
THere are many files any idea which one i should download?we use windows 2000
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
mintmaninAuthor Commented:
Looks like i Need Teradata OLE DB Provider 13.0 (.zip, 38 MB)
0
 
mintmaninAuthor Commented:
finally able to load the driver, but when i give all the information , it says authentication failed and it is not loading any tables
0
 
ZberteocCommented:
You have to authenticate properly on SQL the terradata database. Use you user/password combination. On that site you should also find some documentation.

The authentication failed message actually suggests that the driver works.
0
 
mintmaninAuthor Commented:
Had some issues with server, now everything runs smootly:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now