Connection strings for Teradata

Providers for Teradata

Teradata .Net driver(TdConnection)
OLE DB Provider for Teradata
.NET Framework Data Provider for OLE DB(OleDbConnection)
Teradata ODBC Driver
.NET Framework Data Provider for ODBC(OdbcConnection)

Community Forums

Find solutions and post questions regarding connection string related issues.

Forum for Teradata

Teradata .Net driver

Type .NET Framework Class Library
Usage Teradata.Client.Provider.TdConnection
Manufacturer Teradata

Set example values »

More about this class library »

Standard

Data Source=myServerAddress;User ID=myUsername;Password=myPassword;

Copy

OLE DB Provider for Teradata

Type OLE DB Provider
Usage Provider=TDOLEDB
Manufacturer Teradata

Set example values »

More about this provider »

Standard

Provider=TDOLEDB;Data Source=myServerAddress;Persist Security Info=True;User ID=myUsername;Password=myPassword;Session Mode=ANSI;

Copy

.NET Framework Data Provider for OLE DB

Type .NET Framework Wrapper Class Library
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft

Set example values »

More about this wrapper class library »

Bridging to OLE DB Provider for Teradata

This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.

Provider=TDOLEDB;Data Source=myServerAddress;Persist Security Info=True;User ID=myUsername;Password=myPassword;Session Mode=ANSI;

Copy

Teradata ODBC Driver

Type ODBC Driver
Usage Provider=Teradata
Manufacturer Teradata

Set example values »

More about this driver »

Standard

Provider=Teradata;DBCName=MyDbcName;Database=myDataBase; Uid=myUsername;Pwd=myPassword;

Copy

.NET Framework Data Provider for ODBC

Type .NET Framework Wrapper Class Library
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft

Set example values »

More about this wrapper class library »

Bridging to Teradata ODBC Driver

This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.

Provider=Teradata;DBCName=MyDbcName;Database=myDataBase; Uid=myUsername;Pwd=myPassword;

Copy

Sign-in or Join

Selected Articles

What is a connection string?

Rules for connection strings

All SQL Server SqlConnection properties

SQL Server Data Types Reference