350 - 400 of 801 tags for Connectivity


We need to install teradata libraries on UNIX server (AIX-6.1).

The version of Teradata is TTU12.

Please let us know the steps for the same.






I am using Teradata jdbc driver, and trying to upload a flat file with 100 million rows to teradata.

I start off with a clean table.

First I tried to iterate through the entire file, do addBatch() for each of the rows, and only in the end do a single executeBatch():

I am unable to connect using the following snippet of code:

drv = JDBC("com.teradata.jdbc.TeraDriver","./TeraJDBC/terajdbc4.jar")

conn = dbConnect(drv,"jdbc:teradata://db1/TMODE=ANSI,CHARSET=UTF8",user="user1",password="pswrd1",dbname="test_db")

I get the following error messages:


As a part of our Teradata evaluation effort, I have created a java ETL process which attempts to batch load data from an Oracle instance into a Teradata 13.10 Express VM instance.

Has anyone else seen this? Currently if I run up a connection via the JDBC driver under a 64bit JVM of 32bit JVM under a 64bit Ubuntu I get an unexpected hang. Under a 32bit JVM on a 32bit Ubuntu install everything works fine. The really weird thing is if I run the connection thread through strace it appears to be spinning never really connecting.

I've contacted many people within my company who use SAS, but I can't figure out how to resolve my issue and am running out of places to turn.


   Datastage8.1 install SUSE 10 64-bit

   Teradata install vm on SUSE 10 64-bit

In the DS server i install the TD ODBC driver. also used the ./adhoc can connect to the TD  and can execute the SQL command. but i don't know two the configuration the ODBC and the env on the DS server?


Accroding to the explanation of this error in the Messages document,

Hi Guys,

I have installed the teradata 13 client in my machine (Win XP). Whenever i run a query in SQLA  it gives the error msg

'object reference not set to an instance of object'

If any of u people encountered this error kindly help me out the solution ASAP    thanks

Using Sql server and connecting to Teradata 13.0 using 64 bit .net bring data FROM Teradata - everything is fine
When I try to do an Update to my table on Teradata - I have nothing that lets me specify the Database or Table I want to update - but I get a response saying everything completed successfully.


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.