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-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
UTY1006 CLI error Topic by DennisC 05 Apr 2012

We are upgrading our scheduler to a new version.  When testing a multiload we get the following error message:

UTY1006 CLI error: 527, DBCHINI failed

Running the same script manually works with no issues.

Any insight into this would be greatly appreciated.

Thanks in advance.


2 replies, 2 years ago
Teradata_ICULibraries Topic by thisisKumar 04 Feb 2013 iculibraries, icu


Hi, I am trying to understand what is Teradata_ICULibraries_D and purpose of it.


I would really appriciate If someone could provide me littlr information or point me to the right documentation.


I cannot find a single webpage on google or teradata website regarding this.


Thanks in advance,


1 reply, 2 years ago
Terminating ODBC Connections using other programming languages such as Python Topic by martin.lawless 03 Jul 2012 odbc, session, python, odbc connection, terminate, termination, terminating


A problem that I have been coming across is that when I connect to Teradata via a third-party programming language (whether that be Python or C), the Teradata session does not terminate until the system times out even though I explicitly close the ODBC connection.  The following is an excerpt from my code:

2 replies, 2 years ago
TD JDBC Error 857 - Two different data types are being set for parameter 42 when using sqoop Topic by abnoel 30 Jan 2013

When I try and do an import into hadoop using the JDBC driver I recieve error 857 - Two different data types are being set for parameter 42
The data type in the file aligns with the data type in the TD table. Anyone know anything else I should check or try?
JDBC version is 14

1 reply, 2 years ago
Cannot get stored procedure call from C# with output parameters to work Topic by kwhibray 27 May 2008

Hi, I'm new to posting to this forum, so please forgive any procedural/protocol issues...I'm trying to make a call to a stored procedure from a C# program using the ODBC drivers (TTU version 8.2). I found a post at this location that I'm using as an example. I could not get my modified version to work, so gave up and copied their example exactly (including the creation of the TestProc stored procedure) yet get the same error messages. When the code reaches the lineOdbcDataReader r1 = sampleCMD.ExecuteReader();I get a dialog pop-up indicating: "The LAN message RequestNo field is invalid".Followed by the exception error message {"ERROR [HY000] [NCR][ODBC Teradata Driver] Stored procedure parameter markers are not bound."}Is it the code, or my system (i.e., some incompatibility with the .NET version I'm using? I had recently migrated the code from Visual STudio 2003 to 2005), though this is brand new functionality I'm coding in. If I could get confirmation that the example code from the forum post should/does actually work, that would be a big step. Or, another example/method for me to try would also be appreciated.thanksKevin Hibray

7 replies, 2 years ago
TPT API with Informatica throwing invalid row length error. Topic by csesatya 29 Jan 2013 tpt, invalid row length, max row length, informatica tpt api

We are Informatica Powerexchange for TPT. When we tried to load a table with 140  columns and row length of 55k, TPT connection is throwing invalid row length error. However same is working fine with relational connection. 

0 replies
how to install teradata express edition on windows 7 Topic by Big apple 07 Nov 2009

Hi all,I want to install teradata expression edition on my windows 7 machine. but it say windows does not support. so what should I do?please helpbig apple

8 replies, 2 years ago
Need Help with Teradata ODBC driver on Oracle/AIX Topic by Thomas.l.Coffing3 21 Dec 2010 teradata, aix, oracle, odbc, error, tnsping

Hello everyone,

I'm trying to get a Teradata ODBC driver to work on an Oracle/AIX platform instead of windows. I've gotten the Tnsping working, however when I go to use the link I recieve the following error message:

ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from LINK_TDDEV

3 replies, 2 years ago
Trying to set up ODBC connection Topic by Sociodude 28 Jun 2006

I've been trying to set up the ODBC connection for Teradata while using the program Advanced Query Tool. I've already downloaded the latest driver and installed it on the computer. When I go to add a new system data source and click on teradata, it gives me the following error message: "Unknown error occurred in terasso library."Then it pulls up the window that allows me to enter information such as name, description, Teradata Server Info, Default database, Username, Password, and Account String. After entering this information, I get another error message: "Unable to write Accountstring into private profile."Does anyone have any ideas?

31 replies, 2 years ago
Unable to find compiler for CREATE FUNCTION Topic by davidp 03 Apr 2007

Hello,I'm getting the error "5600: Error Creating UDF/XSP/UDM/UDT: no compiler available" in SQL Assistant when trying to create a UDF.I've got Visual Studio 2005 installed on a Windows 2003 SP1 Server. I've set the environment variables for command line Visual C. I've successfully compiled a small c program via the command line. Any ideas why Teradata doesn't recognise the compiler?

4 replies, 2 years ago
Atser Data JDBC drivers Topic by bunbury 11 Jan 2013 jdbc

does anybody know where to download the latest JDBC drivers (4.5.1 or higher) for Aster Data?

0 replies
Teradata OLE DB Provider 13.0 64 bit for Windows 2008 is not available Topic by pbarysch 21 Jun 2010

I couldn't findTeradata OLE DB Provider 13.0 64 bit for Windows 2008 on the download site.

14 replies, 2 years ago
First attempt fails. 20 min. later connection results. Topic by hagedorn 04 Dec 2012 teradata, restart, connect informatica, catalog string

I have a problem with Informatica connection to Teradata. Every night we kick off a job which gets an error connecting to Teradata. It gives the error message Unable to get catalog string. We restart the job and it connects after 20 min. and runs successfully. Any ideas regarding what the issue could be? Could it be a Data Source Resolution error?

5 replies, 2 years ago
Teradata XML services - help needed Topic by rs131112 07 Aug 2008

I have installed Teradata XML services into our test environment. During the installation I needed to modify the scripts to increase the spoolspace max for the SYSXML logon to 2GB to get the libraries to load properly - that was a bit painful. Now, I am trying to work through the first example in the document - generate a canonical schema from an existing table/view. Here's the command that I am using:call sysxml.gen_query_canonical_schema('select * from ttmp.rs_xml_test','logon','pass', outv);I am running this through TSA. It just sits there and runs with the hourglass - over 20+, 30+ minutes before I kill it. Seems like something is not right. Any comments or advise on this problem?

8 replies, 2 years ago
Remote Access Issue Topic by TDW 14 Dec 2012

Hi All,
I am not sure of the exact perameters, so please bear with  me.

0 replies
Excel Connector for Teradata Topic by Bajju 08 Feb 2012


Is there any Excel connector availble to execute the query from Excel for teradata?

It should support to user to runs the query from excel & the result should populate in the same excel / other excel workbook from predefined column & row


Thanks in advance


9 replies, 2 years ago