550 - 600 of 991 tags for Connectivity


I am using .NET Data Provider to connect from Microsoft Analysis Services (BI Studio 2008) to Teradata. In general that works fine and I connect to Teradata database systems.

But there is a specific Teradata system (Teradata 13.10) that I am unable to connect using .NET Data Provider.
I always get the following error message:

[TeraGSS Security Library] [115022] Exception occurred in TeraGSS layer. See inner exception for details.

I am using the following connection String:

If this isn't a true connectivity query, please forgive.

I've mounted the Teradata Express for VMware image and can access the evaluation DB from within VMWare Workstation.

I'm now attempting to connect to the Teradata database on the VM over my local network to query the DB with the .NET provider. Can someone point me in the right direction on how to connect to the VM database?

I am getting the following error trying to use this with DBI 1.6.16 on an AIX app node, using the Presicient 12.001 GPL driver:
'DBD::Teradata::st execute failed: Failure 7968: FD622_Determine_Date_Range_SP:The recipient of the result set does not support dynamic result sets.'

I am new to Teradata. I am using Hadoop Java map-reduce to connect to Teradata via JDBC. I am using the Teradata JDBC Driver 13. I am using Hadoop 20.2.

I am gettign the following stack trace.

11/08/08 14:51:42 INFO mapred.JobClient: Task Id : attempt_201106221259_0073_m_000010_0, Status : FAILED
java.io.IOException: com.teradata.jdbc.TeraDriver
at org.apache.hadoop.mapred.lib.db.DBOutputFormat.getRecordWriter(DBOutputFormat.java:162)
at org.apache.hadoop.mapred.MapTask$DirectMapOutputCollector.(MapTask.java:662)

Hi!, I'm trying to integrate Teradata with our Identity Management Solution. I would like to know the way for adding users via command line, SQL/JDBC query, API, and so on.

Best regards

What does the SQL request mean? Is the maximum allowed length configurable? Why still need the limitation in 64bit ODBC driver? Is there any workaround ?


Good afternoon

In Datastage as ETL tool i can connect to differeny RDBS and checkup its configuration by means of .odbc.ini file

But checking out this file i can see entries for relevant information to acces the DB like Database, LogonI, Password just for only SQLSEVER database servers (Windowws Servers)
But for ORACLE Databases i just can see Driver information but no Database, LogonI, Password

Is there anywhere else can i get these relevant information to access oracle Databases?

This is an example for .odbc.ini


Hi all,
I'm getting an error around names not being in the HOSTS file or names database when trying to connect to a Teradata system using BTEQ or SAS from Linux. This happens when I try to use the hostname vs. the IP address. Is the fix as simple as adding the IP address and host names to the /etc/hosts file on the Linux servers or is there a special hosts/names database file that BTEQ, etc. use to resolve hostnames? Also, just curious why is this necessary if we are using DNS and can ping the hostnames with no issues from the Linux servers?


SAS Error:

Good evening

Im a dummy about Teradata and i have a question
in an Production system there are a lot of process that extracts information from heterogenous and operational database system.

In Director Program i can see graphically which tables are accessing i.e odbc stage icon but cant see which connection is used, a sid datanase, user y password because the info is encrypted.

i've heard about Medatada engine and Metadata Services. the question is by means of teradata engine can i find out what i was lookjong for? if yes how.

Ok the setup is RHEL 5 with unixODBC 2.2.11 python 2.4 using pyodbc 2.1.5

I have followed the instructions located here:


To try and get this working but with no luck. I can get sql server and mysql working and everything like that but just can't get teradata to work. I've tried downloading and using the 13.0 bundle and the 13.10 bundle linking the files and everything like that. When i look at the trace it looks like this:

SQLHENV 0x13a13830

Am trying to deploy the JMS Universal Connector to WLS 10.3.4.

I have tried finding out the 'How-To' documents related to deploying JDBC driver mentioned in the JMSUC Install Guide, no success...

When creating the Data Source with JNDI name jdbc/com.teradata.terajmsa.MetaDS, the connection test succeeds, however when trying to deploy the DS to any server, I get the following:
[Teradata Database] [TeraJDBC] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.

I need help on how to connect from SQL Server 2008R2 which is on my Windows 7 64-bit PC.
I tried linked server but not sure which provider to pick. Nothing on the provider dropdown has references to Teradata.
From looking at Control Panel, I think I have all the drivers needed.

During the connect, when I use cnewp.xxx.com in the Server field I get following error

SQLA Version:
[.NET Data Provider for Teradata] [115006] Could not resolve DataSource=cnewp to an IpAddress.
at Teradata.Client.Provider.WpTcpTransport.WpResolver.FirstLookup()
at Teradata.Client.Provider.WpTcpTransport.WpResolver.UnknownCopLookup()
at Teradata.Client.Provider.WpTcpTransport.WpResolver.GetHost()
at Teradata.Client.Provider.WpTcpTransport.Connect(Int32 timeout)

I am new to Teradata and was trying to setup something similar to sql loader to load delimited files into tables.

Below is the script i ran from my unix prompt.
tdload -c ASCII -j tdloadjobvars.txt

Below are the contents of my "tdloadjobvars.txt" file.

TargetLogonMechData='authcid=xxxx password=xxxx',
TargetWorkingDatabase = 'xxxx',
SourceFileName = 'tdload.csv',
TargetTable = 'tdload_1',
SourceTextDelimiter = ',',
TargetMaxSessions = 5

We are getting this exception when running a query in a web application which coonects to Java API through a web service. The jar being used is terajdbc4.jar and the version of JDBC being used is TeraJDBC I have run the query using bot ANSI mode and Teradata mode both using CLI,ODBC and Terardata.NET;no such error has been seen.

We are getting the following exception when connecting from AIX machines using JDBC 13 drivers to a Teradata 12 database.

The exception ceases to occur, when we switch to the JDBC 12 jar files of the drivers.

My customer is claiming that LCC and round-robin DNS will still cause potential balancing/availability issues. They state that although Windows XP will randomly choose a DNS entry, Vista and Windows 7 will always connect to the nearest host (by IP address) so you do not get a consistent load balance situation.

I have a C executable program that has embedded SQL in it connecting to Teradata. The program was coded, compiled, and linked on an AIX development server. To promote it to production, we will just copy the executable program to an AIX production server.

I have just complete some testing with a application I have made using the JDBC teradata driver. However, when I read from my resultset it appears that I lose non standard characters such as (± ¼ »). These are typically used within xml which is what I am also retrieving from the database, and they return as question marks, with an int value of 65533.
The values themselves are correctly shown in Teradata SQL assistant.
I have also tried creating a mysql database, which I could return the same characters from successfully.

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(ErrorFactory.java:93)

I have to execute several SQL request in parrallel.
Can you confirm me if the "execute" JDBC Method (with all my requests in parameter) will execute all the requests in parrallel or in sequential ?


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.


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)

I am trying to use the .Net Provider with a Web Application however at runtime I keep getting the following error:

exePath must be specified when not running inside a stand alone exe.

[ArgumentException: exePath must be specified when not running inside a stand alone exe.]
System.Configuration.ConfigurationManager.OpenExeConfigurationImpl(ConfigurationFileMap fileMap, Boolean isMachine, ConfigurationUserLevel userLevel, String exePath) +179166
Teradata.Client.Provider.TeraAppConfig..ctor() +58
Teradata.Client.Provider.TeraAppConfig..cctor() +21

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.