0 - 28 of 28 tags for .net data provider

The .NET Data Provider for Teradata is an implementation of the Microsoft ADO.NET specification. It provides direct access to the Teradata Database and integrates with the DataSet. .NET Applications use the .NET Data Provider for Teradata to load data into the Teradata Database or retrieve data from the Teradata Database.  

I am trying to use the bulk load method using TDCommandBuilder in C# and also compare it to the individual insert statement performance using the following code. I move data back and forth between SQL Server and Teradata.

Hi All,
I am facing an issue with reconnect in .NET and ODBC connectors from SQLA when i do a DBS restart. I am seeing this in TD Expres 15.0 SLES 10 40GB  VM.
Teradata .NET Data Provider :
Issue here is that after a successful DBS restart, SQLA is not maintaining the current session context.

I downloaded the .net Data Provider for Teradata 14.11 from this link: 
and installed it on my machine using the installation program.

I have installed the .Net Data Provider (http://downloads.teradata.com/download/connectivity/net-data-provider-for-teradata) on 2 computers, as an Administrator. I tried 3 versions of VS - VS2013 Pro, VS2013 WD Express, VS2010 WD Express.
I found one tutorial, so I know that what Im trying to achieve should be possible :)

The XML data type was released in Teradata Database 14.10.  This type enables XML documents and fragments to be stored in a column defined as XML.  Support for the XML type was also added to the  .NET Data Provider for Teradata 14.10 release. 

The Teradata Database supports source files that can reside on the client or server machine that contains Data Definition Language (DDL) to create a function (e.g.

I am working on a small development project and trying to port a SQL Server .NET to Teradata. It utilizes the NHibernate add-on to handle the mapping between the database and POCO classes.
I saw some posts on some forums (via Google) and see references that "creating a suitable dialect wouldn't be too hard".

Hello. I'm working with some .NET code at the moment that performs the following operations:

Teradata Database supports Inline and Deferred Large Object Retrieval modes. The LOB retrieval modes control the content of rows and accessibility of LOB columns. 

I have added reference to Teradata.Client.Provider (.NET Data Provider for Teradata, Runtime v2.0.50727) to my Visual Studio C# 2010 project
Now, i want to get list of all ODBC names for Teradata

I included the namespace for Teradata.Client.Provider

The following reference documentation is available:

Do people actually have the .NET Data Provider for Teradata integrated in Visual Studio 2010? I know you can add a reference to the driver and write code against it, that works fine. I'm talking about integration, where Teradata shows up in the Data Source list when creating things like Entity Framework Data Models.

This blog outlines the steps to create a SQL Server 2008 (64-bit) R2  Linked Server to the Teradata Database.

How can a connection to a Teradata database be implemented as a PowerShell script using ODBC, .Net Data Provider, or other protocol.


I am using .NET Data Provider to connect from Microsoft Analysis Services (BI Studio 2008) to Teradata. In general that works fine and I connect to Teradata database systems.

But there is a specific Teradata system (Teradata 13.10) that I am unable to connect using .NET Data Provider.
I always get the following error message:

[TeraGSS Security Library] [115022] Exception occurred in TeraGSS layer. See inner exception for details.

I am using the following connection String:

I've mounted the Teradata Express for VMware image and can access the evaluation DB from within VMWare Workstation.

I'm now attempting to connect to the Teradata database on the VM over my local network to query the DB with the .NET provider. Can someone point me in the right direction on how to connect to the VM database?

Named Parameters are a great feature when using Teradata SQL Assistant. All one has to do is put "?my_parm" in the SQL. This can be very helpful in testing a query and can be a great time saver.

Microsoft's report development tools also provide the same feature... using "@my_parm" syntax within the query of a report. This works great with other databases. However, it does't work when using the Teradata .NET Data Provider nor ODBC to Teradata. One has to use an unamed parameter markert, simply "?", in their SQL.

TdCommandBuilder class, part  of  the .NET Data Provider for Teradata, generates Insert, Update and Delete commands for a Batch Update. But How can you associate a Transaction with CUD commands given that you have no direct control over the Command generation?

This blog describes how to convert .NET Data Provider for Teradata Learning Examples from C# to VB or C++.

Data Source with Fully Qualified Domain Name can speed up logons plagued with slow "Name to IP-Address resolution". 

In this BLOG I will describe how to register a .NET Data Provider with the ADO.NET   DbProviderFactories Class.

The Release Note of "Teradata .NET Data Provider" says it support OSs below. Then it means this version will not support R2 editions?

Client Operating Systems:
Microsoft Windows 2000 SP4
Microsoft Windows XP Professional SP2 x86
Microsoft Windows Server 2003 x86
Microsoft Windows Server 2008 Standard x86 Edition
Microsoft Windows Server 2008 Enterprise x86 Edition
Microsoft Windows Vista Enterprise SP1 x86 Edition

Microsoft Windows XP Professional x64 Edition
Microsoft Windows Server 2003 x64 Edition
Microsoft Windows Server 2008 Standard x64 Edition

Microsoft Visual Studio DataSet designer generates code (C#/VB.NET) to read data from a .NET Data Provider data source or apply changes to the data source. DataSet designer generates parameterized queries and sets the properties of DbParameter object to the corresponding column data type attributes.