Teradata connection strings

Teradata .Net driver

  • Standard

    Data Source=myServerAddress;User ID=myUsername;Password=myPassword;
Problems connecting?
Get answer in the Teradata Q & A forum

OLE DB Provider for Teradata

  • 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

  • Use an OLE DB provider from .NET

    Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

    See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

Teradata ODBC Driver

  • Standard


.NET Framework Data Provider for ODBC

  • Use an ODBC driver from .NET

    Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

    See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.

Q&Aask question »


    Articlesread all »

    Didn't find your connection string?

    Start over from the connection string reference index - or try a search!

    In the Q&A forums you can ask your own question and let somebody help you.

    The knowledge articles contains solutions and guides.