0 - 45 of 45 tags for .net

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.  

The Teradata Developer Tools for Visual Studio is available from the Visual Studio Gallery. The release contains a query tool that enables queries to be composed and executed against a Teradata Database. Queries are composed using a custom editor window with intellisense capabilities. Separate windows are used to display results and history.

Hi,
I'm writing a program that connects to TD.
During execution i'm creating a class structure that i need to move to TD DB.
In .net i can use Bulk Copy or write the data into text files and then use Bulk Insert.
Is there an easy direct way of doing that in TD (like bulk copy or bulk insert)?

Hi,
I am developing an application in .Net and using .Net provider for TD. I have the code as below. I am selecting the session no, setting a queryband and running a query and setting the query band off. Few of the values are coming from my windows form textboxes. This code runs at the click of a button on my form.

I need to query a teradata table by referencing a column that is of type Timestamp(6). I'm not successful at getting the right format so far. What do I need to set the Size, Precision, and Scale values to for this to work. (By size, precision, and scale I mean these parameter values in Visual Studio's Dataset Editor)

I have a VB2012 application that I have successfully setup to connect to our Teradata server. I have set it up using the data adapter for .NET. With my testing I can hit the Teradata db via the TdDataReader or TdDataAdapter (resultsing in a DataTable) and all that is working great.

I have the following unit test which is failing due to a TdException with the message "[Teradata Database] [2689] Field is null for column defined as NOT NULL."

I am attempting to execute a parametrized non-query SQL command using TdCommand.ExecuteNonQuery().  The parameter in question is DbType.DateTimeOffset and TdType.TimestampWithZone; the parameter value was generated using DateTime.Now and appears to be completely defined (as verified via the Visual Studio debugger).

Hello,
I have a simple unit test which is failing the final assertion:

This will be part 1 of a multi-part blog about how the .NET Data Provider for Teradata 15.0 can now In-Line Large Objects (LOB)  that are sent to a Teradata Database when executing an INSERT or UPDATE statement.  This first blog will introduce In-Lining of LOB.   Blogs will also be written that discuss how to take advantage of this featur

.NET Data Provider for Teradata version 14.11.0.1 (or above) supports integration with Visual Studio 2012 and Visual Studio 2013. This exposes the .NET Data Provider for Teradata objects necessary for development of ADO.NET applications utilizing the Teradata Database within Microsoft Visual Studio 2012 and 2013.

I am using the Teradata 13.10 virtual machine and I have assigned it a static IP address (192.168.88.10) for host only access.  I am able to connect via BTEQ  - .LOGON 192.168.88.10/dbc,dbc - and with SQL Assistant.   When I try to connect via the .NET provider, I get an error saying that it cannot resolve 192.168.88.10 to an IP address.

Alright. So I looked at this page: http://developer.teradata.com/doc/connectivity/tdnetdp/14.10/webhelp/EntityProviderCanonicalFunctions.html. It mentions that canonical functions for .NET 4.0 are supported under the "Teradata" namespace. Where in the world is this namespace?

We perform ETL on a table of transactions.  After loading the transaction table, we want to use Stored Procedures (SPs) to perform the very complex business validations, and then to apply the transactions against a dozen permanent state tables.

Hi there. My organisation is just beginning with Teradata development, and I'm wondering which connectivity option (.NET Provider, ODBC etc) we should use. We develop against version 4 of the .NET framework using Visual Studio 2010 and 2012. Could anyone recommend one connectivity option over the others, or perhaps list the pros and cons of each?

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

The following reference documentation is available:

The Teradata Database has support for several data types where there is no equivalent Framework Class Library (FCL) type.  For these types, the Teradata Data Provider has a corresonding Provider Specific Type.  All the provider types support:

This is a brief introduction to the new provider specific type called TdNumber .  It will be released in the 14.0 version of the .Net Data Provider for Teradata.  This new type corresponds to the NUMBER data type introduced in 14.0 release of the Teradata Database.  
 

Support for a new dynamically allocated parameter type (TD_ANYTYPE) is available in Teradata Database 14.0. This Teradata enhancement supports input and result parameter types that may be defined dynamically at execution time. The use of the TD_ANYTYPE data type definition in functions and external stored procedures will be discussed.

Im able to connect to teradata DB through SQL assistant with required credentials

But unable to connect to teradata through .Net ODBC

The connection string that i used is

driver={Teradata};DBCName=provided Server address; UID=*****;PWD=*****;

 

Pls let me know if anything is needed

Hi,

I am new to using Teradata and am trying to use it with vb.net to build a user app.

Can anyone please tell me how to call a teradata sp from vb.net (Visual Studio 2005)

I have a simple sp with input and output parameters, something like:

The Open Data Protocol (OData) is a protocol to share or exchange data over the web.  The protocol was developed by Microsoft in 2007 as part of the ADO .NET Data Services technology (a.k.a. Project Astoria) for creating and consuming data services using the Web. This protocol became widely used that Microsoft gave the protocol its own identification, named it OData and considered ADO.NET Data Services as the .NET implementation of OData.

Using Sql server and connecting to Teradata 13.0 using 64 bit .net bring data FROM Teradata - everything is fine
When I try to do an Update to my table on Teradata - I have nothing that lets me specify the Database or Table I want to update - but I get a response saying everything completed successfully.

I'm trying to run a query from a search form by date and I'm receiving the following error: [Teradata Database] Partial string matching requires character operands.

The code for the search is:

ElseIf OptDate.Checked = True Then
sSQL &= "DATE_SUBMIT Like ('" & txtDateRec1.Text & "%')"
End If

The Entity Provider for Teradata 13.10 did not support the VIEWS and VIEWCOLUMNS store schemas.  Therefore, views were not accessible when using the EDM Wizard.

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?

Hi,
I have Windows Server 2003 SP2 64 bit and I spent last few days trying to install SQL Assistant. It fails to install. The Message I get is:

This setup requires the .NET Framework 2.0 or greater. Please install the .NET Framework 2.0 and run this setup again.

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.

A common question about the Entity Framework(EF) is how to use stored procedures within the framework for insert, update and delete operations. The answer is that leveraging stored procedures for insert, update and delete is actually a built-in capability of EF.

A Stored procedure that is defined in a database can be exposed in a conceptual model in two ways:

The .NET Data Provider for Teradata is integrated with Microsoft's Visual Studio 2005 and 2008.  This article addresses the Visual Studio Server Explorer integration with a Teradata data connection and the various database objects that are supported. 

This blog will show you how to retrieve the SQL statement that is generated by the Entity Provider when it processes a  LINQ to Entities or Entity Sql statement.  LinqPad will be used to show you how this can be done.  The blog Using LINQPad to Access Teradata

In this blog I am going to show you how to setup LINQPad v2.26.2 to access a Teradata Database.

LINQPad is a very flexible query tool.  I use LINQPad to primarily execute LINQ to Entities and Entity Sql statements against Teradata when testing the Entity Provider for Teradata.  It is free to use and is available here:

Support for the Entity Framework 3.5 SP1 is coming in .Net Data Provider for Teradata (TDNETDP) 13.10. This release of the Data Provider for Teradata includes the Entity Provider for Teradata.

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.

Hi:

I left this post on the main Teradata website forum, but I thought this might be more appropriate and perhaps get a response. Thanks for taking a look. I just found this little nook inside of Teradata and I'm glad it exists.

I've created a Windows named pipe in a vb.net application using the System.IO.Pipes namespace. I'm creating a pipe, my process appears to be connecting to the pipe block and waiting to read and now I would just like to feed the pipe from Teradata.

This blog discusses how Query Bands have been implemented in the .Net Data Provider for Teradata 13.01.00.00.

Microsoft and Teradata worked together last year to integrate SQL Server Reporting, Analysis and Integration Services with Teradata Database. Some MSDN links that provide additional information:

.NET Framework has a very broad support for Asynchronous operations including a well defined Asynchronous Programming Model. All asynchronous operations are started by invoking a Begin method; later a corresponding End method is invoked to retrieve the result.