Developers community number 1 connection string reference

Connection strings for Teradata

Providers to use when connecting to 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)

Finding this site useful?

-Say "Thanks" to Greg Harward and the other contributing developers!

-Thank you! »

Teradata .Net driver

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

Manufacturer: Teradata

Customize string
example values »

Standard

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

OLE DB Provider for Teradata

Type: OLE DB Provider
Usage: Provider=TDOLEDB

Manufacturer: Teradata

Customize string
example values »

Standard

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

.NET Framework Data Provider for OLE DB

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

Manufacturer: Microsoft
More info about this wrapper class library »

Customize string
example values »

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;

Teradata ODBC Driver

Type: ODBC Driver
Usage: Provider=Teradata

Manufacturer: Teradata

Customize string
example values »

Standard

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

.NET Framework Data Provider for ODBC

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

Manufacturer: Microsoft
More info about this wrapper class library »

Customize string
example values »

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;