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.
Could you tell me the reason why login time out? Topic by 30 May 2011 jdbc

I could connect the DBS via bteq when the program was retrying to connect to TD DBS(14f.00.00.00).
But who can tell me it is an issue of c3p0 module or TeraDriver?
DEBUG com.mchange.v2.resourcepool.BasicResourcePool - An exception occurred while acquiring a poolable resource. Will retry.
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC] [Error 1276] [SQLState 08S01] Exceeded login timeout for
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(

2 replies, 2 years ago
Problem with ODBC driver and MS Query? Topic by Halen5150 17 Jan 2007

I'm trying to import data into an Excel 2000 spreadsheet by SQL query (using Data>>Get External Data>>New Database Query). However, I receive 'Out of Memory' followed by 'Could not read the file' when attempting to connect using the Teradata ODBC DSN. I am able to connect to Teradata when using the same ODBC DSN in Teradata SQL Assistant 7.1 so I'm thinking that MS Query could be the problem. I've recreated the ODBC DSN with no luck.I'm using Windows XP SP2 with version of the ODBC driver for Teradata and Microsoft Office 2000.Does anyone know if the Teradata ODBC driver is flakey with MS Query?Any info or ideas would be greatly appreciated.Thanks-Brad

3 replies, 2 years ago
ODBC and TeraGSS 64-bit version on Red Hat Topic by piotrs 19 May 2011 red hat, odbc, teragss

Is it possible to install 64-bit version of ODBC driver on Red Hat Linux? I can't find 64-bit version of TeraGSS for Red Hat in downloads, there is only 32-bit version.

0 replies
Threads hanging permanently on Teradata requests Topic by iliaflax 16 May 2011 java jdbc


I'm using JDBC to query a Teradata server. There are up to 100 simultaneous requests, each one using a fresh connection, and closing it at the end. After some hours of work, some of the threads performing the requests get stuck indefinitely. Eventually a restart is needed.
From inspecting the call stacks, I see that the threads are in a socket read state, and that it happens when preparing a statement or when closing the connection:

Case 1:
java.lang.Thread.State: RUNNABLE
at Method)

1 reply, 2 years ago
2 replies, 2 years ago
Login failure for Packet transmit Topic by mrite 12 Apr 2011


Any help is much appreciated, when a test connection is being made, getting below error in the logs.

App runs on Weblogic and it connects via JDBC connection to Teradata DB.

5 replies, 2 years ago
.NET Teradata Driver in GAC Topic by Jeje 14 Nov 2008

Hi everybody,I have installed the last .net teradata driver on my pc (WinXp Pro SP2) and I created a small testing application to test the drivers.I use Visual Studio 2008.That works fine on my pc since the installation package has registered some assemblies into the GAC.I would like to know if is it possible to deploy my application on another pc without also installing the .net teradata driver into the GAC ?Apparently, we use only the Teradata.Client.Provider.dll assembly.So I would like to deploy this assembly in the bin folder on my application.But I receive this error: "Unable to find the requested .Net Framework Data Provider. It may not be installed."Is Somebody can tell me if it's mandatory to deploy the .net teradata driver into the GAC ?Thanks in advance for your answer.Jerome

9 replies, 2 years ago
executing imported teradata stored procedure from DATASERVICES Topic by IndNaga 21 Apr 2011

I am importing a teradata stored procedure into DATA SERVICES called sb_calc_sum and i am trying to use it in a script inside a dataservices job.
It gives me the following error when i try to execute the data services job.

ODBC data source error message for operation : <[Teradata][ODBC Teradata Driver][Teradata Database] 'sb_calc_sum' is not a macro. >.

1 reply, 2 years ago
Accessing TD using MS Access/Excel - using ldap Topic by Bilal_Abdeen 17 Apr 2011 odbc, ldap, connection, ms access, ms excel


I need to access TD (12) using MS Access and/or Excel. My login user name is configured to use ldap for authentication. ODBC version is

A. MS Excel 2007:
The connection steps seem to work smoothly until it displays the list of available TD tables. Then, it displays the ODBC connection dialogue. After entering the authentication details, which I use successfully with TD SQL Assistant, I get the following consecutive error messages.
1. [NCR][ODBC Teradata Driver][Teradata Database] The UserID, Password or Account is invalid.

3 replies, 2 years ago
ODBC via MS Access Topic by Larryag 25 Mar 2011 odbc, ms access

Hello... I am having a problem connecting to our Teradata database using an ODBC connection within MS Access. I'm using Access 2003, and can connect directly using v12.0 of Teradata SQL Assistant. I can connect to all tables I have been granted access to within Teradata SQL Assistant, however when trying to connect via ODBC within Access, I am presented with the error of "[NCR][ODBC Teradata Driver][Teradata Database] The user does not have any access to the database [my sign-on ID]. (#-3524)"

1 reply, 3 years ago
problem with jdbc/dialect Topic by tamer.s 04 Apr 2011 spring hibernate weblogic udfcallname

I Everybody,

I have to migrate an application from oracle to teradata DB.

This is a web application running on weblogic with spring+hibernate(with dialect from hibernate) with teradata last JBDC, using teradata vmware express edition.

when i start the application, for firsts test i've got this error:

:com.teradata.jdbc.jdbc_4.util.JDBCException:[Teradata Database] [TeraJDBC] [Error 3707] [SQLState 42000] Syntax error, expected something like an 'UDFCALLNAME' keyword between '.' and the 'language' keyword.

1 reply, 3 years ago
Connection close not returning Topic by iliaflax 07 Apr 2011 connection

The phenomenon

The operation Connection.close() on a Teradata connection sometimes gets blocked forever.

The relevant java stack trace

java.lang.Thread.State: RUNNABLE
at Method)

0 replies
UPGRADE 12 to 13 Topic by fusionobject 23 Mar 2011

We have upgraded from 12 to 13 ODBC driver on linux , since then we were not able to connect to teradata.

what are the missing thing could be.

10 replies, 3 years ago
problem with hibernate and mapped entity Topic by tamer.s 06 Apr 2011 spring hibernate weblogic string

I Everybody,

I have to migrate an application from oracle to teradata DB.

This is a web application running on weblogic with spring+hibernate(with dialect from hibernate) with teradata last JBDC, using teradata vmware express edition.

Everything is up and running but when hibernate load into an string entity the value found in the db, it seems that load a series of spaces as much as field lenght specified in the db.

1 reply, 3 years ago
Teradata 13.1 ODBC driver installation on zLinux Topic by bobwei 08 Mar 2011


I faced a problem with Teradata 13.1 ODBC driver installation.
I can successfully install tdicu on my machine. But when I was trying to install TeraGSS, installer always report error as follow:

"package TeraGSS_suselinux-390- is intended for a 390 architecture"

My system is SUSE Linux Enterprise Server 10 SP2 (s390x).

6 replies, 3 years ago
.net access to the native CLI Topic by mmccurrey 31 Mar 2011 .net cli c#

Is anybody directly accessing the native CLI api's instead of using the .net provider?

0 replies
MERGE & ODBC Topic by piotrs 11 May 2010 merge odbc

Are there any restrictions using MERGE via ODBC? I have MERGE statement which returns an error:

"[NCR][ODBC Teradata Driver][Teradata Database] The search condition must fully specify the Target table primary index and partition column(s) and expression must match INSERT specfication primary index and partition column(s)."

4 replies, 3 years ago
TTU (odbc, cli) on GENTOO linux? Topic by textures21 24 Mar 2007

I was just wondering if anyone has tried this? I am a fan of the Gentoo distribution of linux so I wanted to see if anyone managed to get the odbc/cli packages installed on this distribution.-Peter

1 reply, 3 years ago
SQL 2005 64-bit - Teradata Linked server...not working Topic by RainoBotha 16 Feb 2011

Hello everybody,

I have setup a linked server in SQL 2005 using:
1. 64-bit Teradata ODBC drivers (native OLE DB does not support 64-bit)
2. I use the Microsoft OLE DB provider for ODBC.

When executing a count from SQL Server to a teradata table it does work, i.e.:
1. Query:
SELECT COUNT(*) FROM TD..PRD_edw_views.offg;

2. Result:


(1 row(s) affected)

When I try to select (*) the data from the table I get the following error. It does look like some sort of table definition is returned but not data, the error:

1 reply, 3 years ago
Teradata ODBC-Connect from PHP (Linux Red Hat) Topic by vfpde 02 Mar 2010 odbc, php


I am trying to connect Teradata from Linux Red Hat ( LAMP-Installation ) via ODBC-Driver.
isql works fine, but i cant connect Teradata with PHP.

SQL error : SQl State in 00000 in SQLConnect ...

( Teradata ODBC Version 13.0 - Red Hat 4.0 )

Has anybody working a PHP/Teradata Connection and know a solution ?

Thanks !

4 replies, 3 years ago
Connecting from Linux PHP to Teradata using ODBC Topic by frider 11 Mar 2011

I am trying to create a db connection odbc on linux and php. I have installed unixODBC 2.3.0 and the latest Teradata utilities, TeraGSS, TDICU, and TD ODBC.

I can connect to Teradata and query and view data using the ISQL application that is part of unixODBC. However, when I use odbc_connect() in php, it will not connect.

I have traced the failed connection, and find this in the trace log:

245 TS:250: SSOLibSetMechName calling gss_get_actual_mech_name -> ret = 0 [ SingleSignOn.cpp 665 ]

1 reply, 3 years ago
Teradata SQL Assistant ODBC connection cannot find Teradata driver 64bit Windows server 2003 Topic by afg3975 11 Jun 2010 odbc, 64bit, teradata sql assistant

I have installed 64 bit Teradata ver on a 64 bit Windows Server 2003 R2 server in the following order (not an upgrade):
TDICU, TeraData GSS client, ODBC Driver, .Net Provider for Teradata
I then installed the Teradata SQL Assistant which appears to have installed in the Windows 32 bit path.
We created an ODBC connection via ODBC Administrator successfully with the Teradata driver recognized.
Opening Teradata SQL Assistant and making a connecting using .Net is successful. The ODBC connection does not show any data sources.

3 replies, 3 years ago
JDBC 'getIndexInfo()' method return data lacks 'is Primary Index' flag? Topic by Marcus1 17 Mar 2011 jdbc, index, getindexinfo, primary, secondary, flag


I need to get the following information of all table indices of a table with the JDBC 'getIndexInfo()' method
to be able to create a similar table but with modified indices.

- The index number
- The index column name of the index number
- The index column position of the index number
- The unique index flag of the index number
- Primary or Secondary index flag of the index number

The first 4 are returned nicely by the 'getIndexInfo()' method.

But I'cant see any information returned by the 'getIndexInfo()' method that
looks like a 'Primary or Secondary Index' flag.

1 reply, 3 years ago
TPT connection question Topic by niyasu 01 Mar 2011


0 replies
CONNECTIVITY ERROR Topic by JustMe 11 Feb 2011

One of our application teams just installed TTU13.0 on a server. When trying to connect, they receive the following error:

[.NET Data Provider for Teradata[]1150009] Message truncation error, not all data was received.

Any ideas as to what causes this and what the solution is?

Thank you

2 replies, 3 years ago