All Forums

Covers all topics related to Teradata database connectivity, including the use of client technologies such JDBC, ODBC, .NET Provider etc. For articles, blogs and more, see the Connectivity section of this site.

You must login to post to the forums.
Teradata Connection Issue Topic by msubbura 12 Apr 2013 teradata connection time out

Hi All,
I have installed Teradata 13.10 and i m using .NET data provider for connection. I am getting connection time out error when connecting database, though i m having access to the database.
11/04/2013 19:42:10
SQLA Version:

0 replies
Connecting Teradata and MS SQL sources Topic by jedler 20 Mar 2013 MS SQL, ssis, CROSS SEVER PROGRAMMING

I am new to the forum so forgive me if this post seems remedial or incomplete.  We work with data coming from two types of data sources (MS SQL Severs, and Teradata Servers).  For a number of projects, we need to compare information across these two server types.  There are probably a number of ways to accomplish this but we are looking for an approach that is 1) scriptable and 2) can be parame

1 reply, 2 years ago
TPTAPI not able to connect with Teradata database with the error [PXOPL_Open: slopen_error...] Topic by ujaiswal 20 Jan 2012 connectivity


I did install Teradata 13.0 drivers on 64 windows setup.

I got below DLL's in location

C:\Program Files\Teradata\Client\13.0\Teradata Parallel Transporter\bin64









But, still I am getting this error?

1 reply, 2 years ago
Only an ET or null statement is legal after a DDL Statement Topic by barca4321 19 Mar 2013

I am working on a Narrow Cast Server project in Microstrategy; teradata is the database. We have configured an ODBC connection to connect the NCS to teradata.
I get an ODBC error while trying to execute a multi pass sql using the ODBC connection. However, a simple query runs fine.  

2 replies, 2 years ago
CommandTimeout issue Topic by Pradeep207 18 Mar 2013
1 reply, 2 years ago
Teradata Connectivity To Datastage Topic by martin_lai 06 Mar 2013

I have problem connectivity from data stage to Teradata database.
The error is "The connector could not establish connection to Teradata Server prdtdcop1. RDBMS Code 224MTDP : EM_NOHOST(224) ... "
The problem came when I use variable / server name for server in the properties Teradata Connector. But when I use IP then the job successfully run without error.

2 replies, 2 years ago
Which connectivity option should I use? Topic by adam.mcdonnell 24 Feb 2013 .net, odbc, connectivity

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?

2 replies, 2 years ago
Jdbc Driver - What's New in .. Topic by jld@fitc 04 Mar 2013 jdbc, docu

Hi there,

1 reply, 2 years ago
Teradata Express on amazon ec2 Topic by vganti 12 Mar 2013 jdbc connectivity

I launched a Teradata 14 express on Amazon ec2 following instructions here:
When I try to connect through JDBC from an app, I get the following error. (This used to work fine with another instance last week.)

0 replies
Teradata studio express 14.0.2 Topic by appi 11 Mar 2013 Teradata studio express connection profile error


0 replies
teradata .net provider name Topic by memostone 28 Feb 2013

We have an application which connects to Oracle before, now our database migrated to teradata, so need to connect. 
Here is what we use for oracle, 
Data Source=;User ID=;Password=;Provider=OraOLEDB.Oracle.1;Persist Security Info=True;

2 replies, 2 years ago
[TeraJDBC] [Error 1382] [SQLState HY000] The batch is empty Topic by jld@fitc 27 Feb 2013

Hi there,
we upgraded from jdbc  12 to 13 (also made some tests with a jdbc 14) and we consistently get this error message
[TeraJDBC] [Error 1382] [SQLState HY000] The batch is empty
though for sure the select member executed on another jdbc connection/techno is returning rows.

4 replies, 2 years ago
DECIMAL OUT parameter lost value after SP CALL when after VARCHAR IN parameter Topic by pjozwiak 27 Feb 2013 odbc, varchar, decimal, out parameter, in parameter, value lost

I have strange problem. Consider below Teradata Stored Procedure:

1 reply, 2 years ago
Unable to connect to TeraData v13.0 from .NET client Topic by venkateshsrini3 28 Feb 2013 database connectivity

Hi All,

1 reply, 2 years ago
Jdbc Driver < > Teradata Instance Version Level Compatibility Topic by jld@fitc 01 Mar 2013

Hi there,
I am still looking for a kind a compatibility table between Jdbc driver version level and Instance version level.
I would reckon jdbc drivers are not expected to be upward compatible (ie: using V12 versus instance level V14) and that it would be recommended to align Jdbc version level to Instance version level.
So should one stick to something like :

1 reply, 2 years ago
Need Sql Topic by ragavender 30 Jan 2012


I am trying this tera data Sql this is for curent month date.
select cast(current_date as date) - (extract (day from cast(current_date as date)) - 1) + interval '1' month - 1

I need tera data sql for Last month begin date and last month end date. I searched various forums but could not get the answer. Any suggesstions please.


13 replies, 2 years ago
Teradata-Aster Connectivity Topic by nancyjean 27 Feb 2013 teradata and aster connectivity

How can we connect Aster and Teradata. 
Using load_from_teradata and load_to_teradata cammands, how are the 2 databases getting connect?
And what is Aster-Teradata adaptor? Is it a physical device or some driver that i can download or  what exactly is it and does  does it work?

0 replies
Not enough information to log on Topic by Jimmy Yin 14 Oct 2012 odbc redhat

Dear All,
    I need to connect to TD by ODBC. But It didn't work after I installed ODBC and configured it. The detail message is as below:
TD Server Version:13.10
Client OS:Red Hat 

[dsadm1@localhost example]$ uname -a

Linux localhost.localdomain 2.6.18-53.el5 #1 SMP Wed Oct 10 16:34:19 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux


1 reply, 2 years ago
OLEDB Provider for TD13.10 issue Topic by Lenvdb 20 Sep 2012 oledb provider setup fail

Hi I am installing a few TD13 DLLS (Drivers and Providers etc) in order to provice me with connectivity to a Teradata Database.
Until 31Aug 2012 I had great success in doing this:
1) First install the ICU Libs
2) Then install the GSS Client
3) Then lastly do the TD OLEDB Provider.

2 replies, 2 years ago
volatile tables with ODBC and Stata Topic by dvmaster1 22 Feb 2013 odbc, volatile tables, stata

Is there a way to tweak ODBC/Stata to work with volatile tables in Linux?
Stata (a statistics package) allows SQL statements to be issued directly to ODBC data source. I believe SAS has similar pass-thorugh functionality. There's some description of this here:

0 replies
Query Timeout again.... Topic by mwoodall 28 Sep 2009

Hello, I am creating a reporting application that requires me to connect to a Teradata DW. know on small queries it works great but when it comes to the larger ones is where i have the issues. I know the default is 30 Sec but nothing i do seems to fix the problem. I have tried the TDcommand.connection timeout but it doesn't seem to like me it say the connection does exist even though i just pull info from it on a small query here is a sample: Dim ds As System.Data.DataSet = New System.Data.DataSet Dim OConn As Teradata.Client.Provider.TdConnection = New TdConnection() Dim da As Teradata.Client.Provider.TdDataAdapter Dim sql1 As String = "select names from empolyees" OConn.ConnectionString = "Data;User ID=123456;Password=teradata;" da = New Teradata.Client.Provider.TdDataAdapter(sql1, OConn) OConn.Open() Dim cmd As Teradata.Client.Provider.TdCommand = New Teradata.Client.Provider.TdCommand cmd.CommandTimeout = 0 <- errors here "Connection doesn't exist" da.Fill(ds) Me.GridView1.DataSource = ds Me.GridView1.DataBind()as you can see above i am running a query against the TDW and filling a DS which i attach to a Gridview so i can make sure its working. my questions are.1) what am i doing wrong above? 2) can i set the Teradata connection/query timeout another way? as i would rather create the dataset files in VS gui so i can attached to my control instead of coding everything.thanks,Matt

3 replies, 2 years ago
Teradata Setup on MAC - Connection, Database etc. Topic by AbhinavBansal 19 Feb 2013 jdbc, teradata, mac, connection

Dear All
I have recently moved from Windows to Mac and am trying to get used to the change. At the same time I am new to Teradata and want to learn it. I have installed Teradata Studio on Mac but I am unable to create a database connection and database to start working on it. 

0 replies
Problem with the Teradata Sessions Topic by kottiprasad 12 Feb 2013 teradata, session


1 reply, 2 years ago
Why would teradata return both "Login timeout expired" and "Not enough information" Topic by Kenny54 10 Jan 2013

I'm trying to connect using Teradata's OLE DB provider and most of the time the connection works, but occasionally it returns an error with two messages:
[OLE DB Provider for Teradata] Not enough information to log on
[OLE DB Provider for Teradata] Login timeout expired
My question is, if there is not enough information then why would it wait to timeout?

2 replies, 2 years ago
Datastage teradata connector in TD12 Topic by 12 Feb 2013

I have installed Datastage with fix pack 3, and TTU 12 with TPT 12, and teradata connector return following:
Teradata_Connector_5: Error loading connector library 0509-022 Cannot load module /ds_sw/IBM/InformationServer/Server/DSComponents/bin/
0509-150 Dependent module /usr/lib/ could not be loaded.

0 replies