550 - 600 of 966 tags for Connectivity

I've been struggling with this for a while.. has anyone had success getting this package to work? I've installed the driver using alien to convert the rpm to a deb package. The package installs, but the driver does not appear to be available when viewing the ODBCconfig gui.


Named Parameters are a great feature when using Teradata SQL Assistant. All one has to do is put "?my_parm" in the SQL. This can be very helpful in testing a query and can be a great time saver.

Microsoft's report development tools also provide the same feature... using "@my_parm" syntax within the query of a report. This works great with other databases. However, it does't work when using the Teradata .NET Data Provider nor ODBC to Teradata. One has to use an unamed parameter markert, simply "?", in their SQL.

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.


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.


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.

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)

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.

Has anyone installed ODBC client (GSS, ICU, ODBC) in UBUNTU ? Is there any documentation available ?

I tried using the RPM packages, the Linux Independent installer "tdodbc__LINUX_INDEP." comes with, but no success.


Dear all

I know, I know - I probably sound like I just stepped out of a Rip van Winkel fairytale 100 year sleep, but this is just how things are right now...B-)

I am using VB6 (still!! but for good reasons...) and we need to extract a few rows from a Teradata DB and Server.
My questions arise from the fact that not all users we support have the TTU installed on their PCs.

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.

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

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

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.



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.

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 ]


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"

I am having issues to connect to TearaData using ODBC drivers provided by Teradata TTU's. If i try to connect using Information Server provided ODBC drivers, it is not able to source the libraries - could be due to 32 bit drivers of TeraGSS. Any one ran into similar issue?
Appreciate any information. Also i am looking for an example how to connect from Linux command line to Teradata using ODBC drviers?

Here is my environment info -

Operating system = RedHat Linux 5.5
Information Server = 8.5 version
TTU's on Linux box = 13.0 version with few patches for TPT

Hi all, i am new to this forum. I need your help on a issue of a Java application which we are facing into production. The app is talking with teradata db (v 12) via JDBC api; It is working fine, but recently app is unable to talk with db in few instances. I have got below exception in catalina.out file. Appreciate if anyone can put light on the issue.


INFO | jvm 1 | 2011/02/21 14:32:21 | 2011-02-21.14:32:21.306 TERAJDBC4 ERROR [pool-3-thread-2] com.teradata.jdbc.jdbc_4.TDSession@2ea70c Read message 1: Incomplete LAN message header: read 0 bytes


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:

I noticed that the statement.executeUpdate() method returns int data type , which conforms to JDBC standard. However, here is the question: it is Teradata!!! the affected row count can easily blow away the integer range. How to deal with such issue?

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


This might very well be an easy problem to solve - but I obviously need help doing so.

I'm using a dev environment (BIDS) on Server1 (Windows Server 2008 x64). Analysis Services is running on Server2 (Windows Server 2008 x64). The data is in a Teradata database on Server3.

Is it possible to log in to the "MONITOR" partition of the Teradata DB using the .NET Driver? And then use the PMPC sub-system commands like: "MONITOR PHYSICAL RESOURCE"

I know it is possible with the JDBC Driver...

I'm not sure this is the correct forum for my question, but I'll give it a try!

After installing the .Net Data Provider for Teradata, I am unable to use it, since I can't see the provider in any list over data providers.

I've installed the .Net provider ver. on a Windows Server 2003, SP2. .Net framework is version 2, SP2.

The installation seems to do it's job, I find all the dll:s in the GAC and everything is in place (according to the .Net Data Provider for Teradata Help, which is also installed).

I am kind of stumped here maybe some one can help shed some light. I connect to the db with this connection string

URL += "://" + host + "/" + database+" /CHARSET=UTF8,COMPAT_DBS=true,DBS_PORT=" +port;

url is the jdbc:teradata

we have it as a variable because we are an etl tool and connect to diffrent dbms. I am currrently trying to add support for teradata. II can get a successful connection using that string but if i try to send a sql statement or use

else if (dbms.equals(TERADATA))
tableTypes = new String[] { "TABLE" };

I am connecting to a db server with the .Net Provider. I have a macro that accepts an integer parameter. When I add the parameter, I get a mismatch error:

[Teradata Database] [3939] There is a mismatch between the number of parameters specified and the number of parameters required.

Not sure what I am doing wrong. Here is what I have:

using (TdConnection cn = new TdConnection("Data Source = " + TeraDataServer + ";User ID = " + userid + ";Password = " + password + ";"))
TdCommand command = cn.CreateCommand();

These are the teradata jars in my classpath:


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


We are working on a TPT-JMS Script where data from a JMS queue will be loaded to Teradata.
We need help on the following issues:
a) When executing the script we are getting following error in the log:

Since the error code 24 represent in-compatibility of Access module with the software.
So is this error because the files at this /export/home/teradata/java/lib location are not compatible with TPT version (or) not compatible with weblogic server.

**** 06:32:01 JMSAM (ERROR): Java_Receive() - Error occurred in


I need to install Teradata client on a unix server where SAS is installed . We need to access Teradata using SAS. We got SAS Access to teradata. But i want to know where i can get the Teradata client software so that i can install on the server. the OS on the server is SUN SOLARIS 10 X86.


In the process of some heavy query (in the mean of data amount) execution my Java application got an Exception

caused by: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC] [Error 1013] [SQLState HY000] Request requires message size: 6080294, exceeds system limit: 1048500

Teradata messages documentation tells nothing but this information in TERAJDBC Driver Error Messages chapter:

1013 Request requires message size: %1,
exceeds system limit: %2
Explanation: Information not available.
Remedy: Information not available.

User SQL Server 2008 to connect to Teradata

Can anyone help me on how to do this? I am using Teradata Version : / Provider Version : ODBC / Database Version : Teradata 13.00.0013

How might I use SQL Server 2008 with it. Do I need to make a Linked Server, and if so how might I do that for ODBC?

Can we connect Mainframe to Teradata Express that is running on VM ware slice? If so can someone provide any details.

I developing perl utilities on windows against Teradata using DBD::ODBC with no issues. However, when I port them to our AIX server, I can't event connect successfully. ODBC appears to be correct as I can connect using the dsn using the isql utility. But when I run my perl script, it fails with "Illegal instructure" durig the connect.

I have a strange error.
I am creating one table with foreign key on the same table :



I insert some data with java program :

PreparedStatement pstmt =null;
pstmt= conn.prepareStatement("INSERT INTO TEST_B (TID,BACTIVE,PASSRESETDATE,TEST_ID) VALUES (?,?,?,?)");
for(int i=1;i<3;i++){

Got a bit of a head-scratcher here.

I've got an Access front-end to some Teradata tables.
There are a couple of dozen folks using it, and 2 have encountered the following error in the last few days.

"Continue request submitted but no response to return"

The error occurs when Access is trying to bring back a result set with more records than will fit in the subform or listbox which is displaying them.

ODBC Driver version is

One of the problem users is using Access 2003, and the other is using Access 2007.

I have a Spring and Ibatis application being deployed to WebSphere 7. This application already uses a DB2 database connection, and I am adding a Teradata connection.

I created the Teradata JDBC provider and data source in WebSphere following the instructions here:


(As far as I can tell, anyway... most of the images on that page don't display for me.)

We are using the PooledConnections using V13 versions of the JDBC driver and have noticed that the volatile tables seem to stay even when we call the close method on the connection.

TeraConnectionPoolDataSource dataSource = new TeraConnectionPoolDataSource();
.. do connection
PooledConnection pc = dataSource.getPooledConnection();
Connection conn= pc.getConnection();
Statetment st= conn.createStatement();
st.execute( Create volatile table);
.. execute somemore inserts and selects
conn.close(); // AT ths point the volatile table should go away.

But if we do

Hi! We have installed Teradata V13.10 64bit ODBC Driver on Red Hat Linux V5 and configured the odbc.ini to point to a database on TERADATA Express V13 VM on another Linux.
First we encountered a bit mode problem, apparently Teradata V13.10 ODBC Driver installation sets up all the symbolic links to point to the 32bit llibraries instead of the 64bit libraries even though our Linux is 64bit, so we manually reset all the symbolic links to point to the 64bit libraries.

I attempted to install a Teradata DB on my new work desktop today and it seemed like everything went well. Except that the Teradata ODBC driver was not recognized.

I have tried to uninstall as well as perform a cleanup. Twice. And yet, when trying to install, it says that a Teradata ODBC driver is already installed. But the wizard fails instantly, saying that the install was interrupted and that no changes to the system has been made.

I'm running Windows XP, attempting to install Teradata 12, with the driver.


Can some one tell me how to do the silent installation of teradata client ( terGSS, tdicu and cliv2) on NT?



Can I redistribute the JDBC jar files with an application? Or must I have the user get that on their own?

I remember reading about this topic somewhere, but search leads me nowhere.


I have a 64-bit operating system on a server running Windows Server 2008 R2. I am attempting to create a 32-bit ODBC connection for BusinessObjects XI 3.2. I located the SysWOW64/odbcad32 application to create the 32-bit connection.

I am trying to use TPT to move a table from Oracle 10g to Teradata 12 using the ODBC operator with Oracle ODBC driver When I execute the script with tbuild, I get

EMAIL_SRC_CD_LK_ODBC: connecting sessions
**** 12:38:34 Fatal error received from ODBC driver:
MSG='[Oracle][ODBC]Driver not capable.'
= =
= ODBC Driver Information =

There is a standard X.12 interface in the healthcare industry. I am new to this industry. Does anyone know if Teradata has a standard X.12 interface for healthcare? Sorry, due to lack of understanding on my part, this question may seem vague.

I am converting my .Net application from visual studio 2005(.Net 3.0) to Visual Studio 2010(.Net 4.0).
I am using the Teradata .net provider version My development machine is on 32-bit Windows 7

After converting my .net application into Visual Studio 2010(.Net 4.0), the Teradata .net provider doesn't seem to work with .Net 4.0

Howdy, I'm having a problem installing the ODBC driver, Version 12 on my Windows XP laptop. I'm getting the following error. "Unable to Locate File C:\WINNT\Temp\pft11f~tmp\ODBC Driver for Teradata.msi". The file is there. I tried registering it by hand and still no luck. Anybody with any thoughts or suggestions? Thanks