Connection strings Examples for Teradata - Connectionstring Examples

Connection strings Examples for Teradata

.NET Data Provider for ODBC

This is a .NET Class Library from Microsoft. The namespace for this provider is System.Data.Odbc.OdbcConnection.

Standard:

Provider=Teradata;DBCName=yourDbcName;Database=yourDataBase; Uid=yourUsername;Pwd=yourPassword;

Note: You can view more ODBC connection strings for other data provider from other pages.

Teradata .NET Data Provider

This is a .NET driver from Teradata. The usage for this provider is Teradata.Client.Provider.TDConnection.

StandaStandard:

Data Source=yourServerAddress;User ID=yourUsername;Password=yourPassword;

.NET Framework Data Provider for OLE DB

This is a OLE DB provider from Microsoft. The usage for this provider is System.Data.OleDb.OleDbConnection.

Standard:

Provider=TDOLEDB;Data Source=yourServerAddress;Persist Security Info=True;User ID=yourUsername;Password=yourPassword;Session Mode=ANSI;

Note: You can get more information from the Teradata site.

Teradata ODBC Driver

This is a ODBC driver from Teradata. The usage for this provider is Provider=Teradata.

Standard:

Provider=Teradata;DBCName=yourDbcName;Database=yourDataBase; Uid=yourUsername;Pwd=yourPassword;