Access Teradata using .NET Framework Data Provider for OLE DB

Connectivity
Connectivity covers the mechanisms for connecting to the Teradata Database, including driver connectivity via JDBC or ODBC.

Access Teradata using .NET Framework Data Provider for OLE DB

Hi Folks,

I am new to Teradata.
can any one help me how to connect to Teradata using ".NET Framework Data Provider for OLE DB".

I tried like this.

using System.Data.OleDb;

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

OleDbConnection conn = new OleDbConnection(connString);
conn.Open();
conn.Close();

but I am getting the following exception.
Exception: "The 'TDOLEDB' provider is not registered on the local machine."

how to register 'TDOLEDB' provider?
how to solve this problem........?

Thanks in Advance,
Sudheer CV
Tags (2)
1 REPLY

Re: Access Teradata using .NET Framework Data Provider for OLE DB

hi,

Make sure you have installed:

TD ICU , TeraGSS and Td OLEDB Data Provider. These three comes in one package as

TDOLEDB_Provider__WINDOWS_i386.13.10.00.01 has

          tdicu__windows_i386.13.10.00.01

         TDOLEDB_Provider__windows_i386.13.10.00.01

         TeraGSS__windows_i386.13.10.00.02

After Installation restart your machine, and it will resolve TDOLEDB regestration issue. I resolved same thing with method described above.

following might be further helpful:

http://msdn.microsoft.com/en-us/library/dw70f090.aspx#_OleDb

http://connectionstrings.com/teradata

BR

Joni