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 metas.wzh@gmail.com 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 13.10.00.18] [Error 1276] [SQLState 08S01] Exceeded login timeout for 153.64.211.204
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)

5088 views
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 3.6.0.0 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

24529 views
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.

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

Hi,

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 java.net.SocketInputStream.socketRead0(Native Method)

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

Hi,

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.

4865 views
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

22245 views
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. >.

4556 views
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

Hi,

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 12.0.0.1.

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.

7406 views
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)"

6283 views
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 13.10.00.10] [Error 3707] [SQLState 42000] Syntax error, expected something like an 'UDFCALLNAME' keyword between '.' and the 'language' keyword.

4679 views
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 java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:474)
at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:818)

4640 views
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.

7077 views
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.

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

Hi

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-13.10.00.02-1 is intended for a 390 architecture"

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

5299 views
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?

1758 views
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)."

6306 views
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

14302 views
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:

-----------
4656

(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:

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

Hi,

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 !

10296 views
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 ]

5570 views
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 13.0.0.1 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 13.0.0.8 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.

6159 views
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

Hi,

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.

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

Hi,

4323 views
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

4922 views
2 replies, 3 years ago

Pages