How to connect OLE DB provider for Teradata

This article describes the commands used to connect to OLE DB provider for Teradata in .NET framework.
  • 2183

Introduction

An application request database information from an intermediate program, which in turn accesses Teradata database. This intermediate program receives the response from Teradata database and returns a copy of the desired data to the application. The connection string used to connect to OLE DB provider for Teradata is given below.

Syntax

Provider=TDOLEDB;Data Source=server_add;Persist Security Info=True;User ID=user_name;Password=password;Session Mode=ANSI;

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.