How to use Teradata with .NET
1. Download the .NET driver:
2. Add a reference to both Teradata.Client.Provider.dll and the Teradata.Net.Security.Tdgss.dll in your Visual Studio Project
3. Create a connection string in the web or app.config. Here is the format:
4. Write some code to connect.
public class Repository
public void TestConnection()
TdConnection conn = new TdConnection
ConnectionString = ConfigurationManager.ConnectionStrings["MyDatabase"].ToString()
QuestionsQ: In order to use Teradata with .NET, do I need to do a full install of the drivers on the web server or do I just need Teradata.Client.Provider.dll and the Teradata.Net.Security.Tdgss.dll?
A: I found this out by trial. The Teradata driver does not reference any unmanaged pieces so it can be xcopy deployed to the bin directory on your web server.
Q: Why am I getting the error: [Teradata Database]  The UserId, Password or Account is invalid.
A: Put this in your web.config:
Q: When am I getting this error: The NTLM authentication token is not supported
A: I don't know why. I had to switch from integrated security to a normal user name and password.