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:

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?

After following the the example shown here :

http://developer.teradata.com/blog/tnguyen/2010/11/retrieving-entity-types-with-a-stored-procedure

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:

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

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.

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.