![]() |
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.
17 Jun 2022
,
|
![]() |
Introduction
09 Mar 2015
,
|
![]() |
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.
25 Feb 2015
| 4 comments
,
|
![]() |
Hi All,
13 Jul 2014
| 2 comments
,
|
![]() |
Hi,
14 May 2014
| 2 comments
,
|
![]() |
Hi,
19 Apr 2014
| 5 comments
,
|
![]() |
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.
21 Oct 2013
,
|
![]() |
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.
15 Oct 2013
,
|
![]() |
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.
27 May 2013
,
|
![]() |
Hello. I'm working with some .NET code at the moment that performs the following operations:
13 Mar 2013
| 3 comments
,
|
![]() |
Teradata Database supports Inline and Deferred Large Object Retrieval modes. The LOB retrieval modes control the content of rows and accessibility of LOB columns.
24 Dec 2012
,
|
![]() |
I have added reference to Teradata.Client.Provider (.NET Data Provider for Teradata 14.0.0.0, Runtime v2.0.50727) to my Visual Studio C# 2010 project I included the namespace for Teradata.Client.Provider
24 Jun 2012
| 1 comment
,
|
![]() |
The following reference documentation is available:
03 May 2012
,
|
![]() |
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.
06 Apr 2012
| 3 comments
,
|
![]() |
This blog outlines the steps to create a SQL Server 2008 (64-bit) R2 Linked Server to the Teradata Database.
15 Dec 2011
| 15 comments
,
|
![]() |
How can a connection to a Teradata database be implemented as a PowerShell script using ODBC, .Net Data Provider, or other protocol.
16 Nov 2011
| 8 comments
,
|
![]() |
Hi, 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. [TeraGSS Security Library] [115022] Exception occurred in TeraGSS layer. See inner exception for details. I am using the following connection String:
22 Aug 2011
| 2 comments
,
|
![]() |
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?
15 Aug 2011
| 6 comments
,
|
![]() |
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.
22 Apr 2011
| 4 comments
,
|
![]() |
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?
08 Apr 2011
,
|
![]() |
This blog describes how to convert .NET Data Provider for Teradata Learning Examples from C# to VB or C++.
22 Dec 2010
| 2 comments
,
|
![]() |
Data Source with Fully Qualified Domain Name can speed up logons plagued with slow "Name to IP-Address resolution".
17 Dec 2010
,
|
![]() |
In this BLOG I will describe how to register a .NET Data Provider with the ADO.NET DbProviderFactories Class.
16 Dec 2010
| 2 comments
,
|
![]() |
18 Nov 2010
,
|
![]() |
26 Oct 2010
| 1 comment
,
|
![]() |
14 Oct 2010
| 1 comment
,
|
![]() |
The Release Note of "Teradata .NET Data Provider 13.01.00.01" says it support OSs below. Then it means this version will not support R2 editions? Client Operating Systems: Microsoft Windows XP Professional x64 Edition
19 Apr 2010
| 3 comments
,
|
![]() |
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.
09 Oct 2009
,
|