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.
Enterprise Library Data Acccess Application Block Implementation using Teradata .Net Provider Topic by ayman 04 Nov 2013 enterprise library, data access application block, daab

Has anybody tried extending the Enterprise Libraray Data Access Application Block so that it works with the Teradata .Net Provider?
To get things up and running, my prototype extends the abstract Database class and passes TdFactory as a constructor argument..  

0 replies
ODBC - decimal symbol Topic by h.h 04 Nov 2013

Hi all,
I'm importing data from Teradata database into MS Access database (Windows 7) using an ODBC driver. The decimal symbol is set to '.' (because the 'Use Regional Settings for Decimal Symbol' is unchecked in the ODBC driver options). The decimal symbol is different in OS (',') thus the import of decimal values is not correct.

0 replies
bteq .logon error Topic by 24 May 2013

Hey all,
having an issue with connecting to the teradata 13 server with bteq
if i do this
.LOGON localhost/dbc,dbc
*** Error: Invalid Logon!
but if it try this
UserId: dbc
Password: dbc
*** Logon Sucessfully complete

3 replies, 2 years ago
Error 8017: The UserId, Password or Account is invalid. Topic by JustMe 21 Oct 2013 ldap, 8017

We are having an issue with users attempting to logon to the system using LDAP authentication.
They are able to logon using a set password with no mechanism chosen.
Any suggestions regarding resolution?

1 reply, 2 years ago
OLE DB Teradata Provider for Windows (64-bit) Topic by warrent 28 Oct 2013

Is there a 64 bit version of the OLE DB Teradata Provider? If so where can I get it?

2 replies, 2 years ago
ODBC IM014: The DSN specified architecture mismatch between the driver and the application. Topic by AlexQuiroz 30 Oct 2013 ODBC IM014

I tried configure Teradata SQL Assistant, but said next error with tittle "Logon failed":
ODBC IM014: The DSN specified architecture mismatch between the driver and the application.
teradata version: 12
windows 7 64 bit
please help me thank you so much

0 replies
JDBC Connection from Oracle 11g Java Stored Procedure Topic by cjeanmarie 29 Oct 2013 jdbc, oracle 11g

When using a Java Stored Procedure from within the Oracle 11g database, an attempt to open a connection to Teradata using the JDBC driver version 14 throws the following error.
Exception in thread "Root Thread" java.lang.NullPointerException

at com.teradata.jdbc.jdbc_4.parcel.ClientAttributesParcel.<init>(

1 reply, 2 years ago
JDBC Bug with exact batch sizes Topic by lil-dice 16 Oct 2013 jdbc bugreport

Noticed this error:
Caused By: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC] [Error 1382] [SQLState HY000] The batch is empty.

2 replies, 2 years ago
F5 versus DNS Topic by StevenSchmid 15 Oct 2013

Can anyone advise if an F5 load balancer should be used over a DNS, each configured with all Teradata COP's.  We have a 2650 Appliance running TD 13.10 with 15 nodes, 10 of which are Network connected.

3 replies, 2 years ago
Unable to create a connection using the jdbc:teradata:// Topic by vasu6 17 Oct 2013

HI Team,
Here is the log file for connectivity through JDBC application from Application server to TD server on linux.
16-Oct-2013 09:57:01IST Unable to create a connection using the jdbc:teradata://,TMODE=ANSI,CHARSET=UTF16 URL with dbc username because of the following error: [Teradata JDBC Driver] [TeraJDBC 1

1 reply, 2 years ago
ODBC SQL_ACTIVE_STATEMENTS limit error using Python / pyodbc Topic by Willimoa 14 Oct 2013 python pyodbc

I'm accessing Teradata through a python based web application, using pyodbc.  I get the error [Teradata][ODBC Teradata Driver] Beyond SQL_ACTIVE_STATEMENTS limit'
which has come up before :

2 replies, 2 years ago
Unable to Create Metadata Topic by balze 15 Oct 2013

Hi guys
I am a newbie and just downloaded TW Miner Express. Following the tutorial, I was trying to create metadata through "Metadata Creation". The "Select Data Source" pops up without any Data Source. I created Data Source on my win 7 machine and also through Tools -> ODBC Administrator in TWM, but it still does not show any Data Soure in my "Select Data Source" popup. 

1 reply, 2 years ago
Problem with teradata SQLA 13 'object reference not set' Topic by Selvazeal 25 Aug 2011

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

6 replies, 2 years ago
Visual Studio 2012 Server Explorer does not show Teradata provider Topic by fwaris 18 Mar 2013 VS 2012

Hi I installed the latest version of the .Net driver (14.10).
I have both VS 2010 and VS 2012 installed.
In VS 2010 the Server Explorer shows the .Net provider for Teradata but VS 2012 does not.
I was expecting the latest version to work with the Visual Studio 2012.
Can someone please clarify.

6 replies, 2 years ago
Doubt in connectivity with Java and TD Topic by Sun_shine_jgd 07 Oct 2013

The project I am working has a java front end and it connects to TD.
Now they claims that when they were using mysql or oracle and if the connection with DB goes down , Java automatically connects to the DB when its up.
But in TD they are forced to restart the Java application to establish the connection with Teradata again.

3 replies, 2 years ago
Unable to open informatica Admin Console on Browser. Topic by ah255012 14 Jun 2012 teradata 13, informatica 9.0.1, unable to open informatica admin console on browser, informatica admin console, informatica server services

Hello Guys!!!


I have installed Informatica 9.0.1 (Server + Client) on my laptop. Its was workng fine after installation but when i restarted my machine i got an issue that i am unable to open admin console. I have cross check and all my services are running. I have also tried to stop and start the services of my Teradata Database and Informatica Server but still stukced.

2 replies, 2 years ago
JDBC Driver - INSERT into TeraData tables shows SELECT from DBC.TABLES and HELP Statements Topic by merchanth 01 Oct 2013

We are using JDBC Driver for our connectivity to Teradata 13.10 version. What we are observing is that for every INSERT statement into a table in TeraData the logs show multiple SELECT .... FROM DBC.TABLES, ... DBC.COLUMNS and HELP statements.

1 reply, 2 years ago
Error Message - Parser: Temp File failure on open or write. code [104] Topic by eliot 24 Sep 2013

I've installed ODBC Driver 14.10 on zLinux. While trying to test my installation using 'tdxodbc' shipped in 'bin' directory, I got the following error. Is there any hint about why this could happen?
adhoc: (SQL Diagnostics) STATE=HY000, CODE=0, MSG=[Teradata][ODBC Teradata Driver] Parser: Temp File failure on open or write. code [104]

2 replies, 2 years ago
Configuring ODBC on Red Hat 5.5 64 Bits for connect to Cognos 10 Topic by Dixxie 26 Sep 2013

Hi, I'm migrating from Cognos 8.4 in Win2003 to Cognos 10 in Red Hat 5.5 64 Bits.
In ODBC for Win2003 i have these setting :

Use Columns Names = checked
Use Regional Settings for Decimal Symbol = checked
Enable Extended Statement Information = checked
Session Mode = Default
DateTime Format  = III
Return Generated Keys = No

0 replies
Newbie: Connecting Teradata, Access Sample Databe, Creating Users. Topic by 16 Sep 2013

Iam newbie to Teradata. I downloaded and installed Teradata Express database 13.0 (default setup) on my windows xp pro sp3 successfully.
Here I am little bit confusing what are the username/password to connect in SQL Assistant. How to connect samples in SQL Assistant.?

2 replies, 2 years ago
Install Teradata on Linux (Debian) Topic by andres.saavedra 24 Sep 2013

Hi, I'm trying to install Teradata on a Linux machine, which is using a Debian Distribution. How can i setup Teradata on this machine and use BTEQ in order to execute some queries on a TD database?

0 replies
No suitable driver found for jdbc issue even after downloading the teradata v 14 jdbc drivers Topic by sirisha.sindiri 16 Sep 2013

I am trying to connect to Teradata ( from a Java application (Rational Software Architect). I have tried with both the version 14 and 13 JDBC drivers from the below site but still no luck.

6 replies, 2 years ago
ODBC Connectivity Problem Topic by mahesh9sri 19 Sep 2013

I am getting below Error .
Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (IES 10901) (WIS 10901)Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (IES 10901) (WIS 10901)

1 reply, 2 years ago
ODBC DRIVER COULDN'T BE LOADED Topic by ArunaMuthusamy 19 Sep 2013 odbc, linux, connectivity, Oracle Transparent Gateway

While trying to set-up Oracle Transparent Gateway on redhat Linux 6.4(64 bit system), we are getting the following error.
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [DataDirect][ODBC lib] Specified driver could not be loaded {IM003} ORA-02063: preceding 2 lines from TERADATA
 Here’s the exact version of GSS,CLIV2 and TDICU installed.

1 reply, 2 years ago
Teradata .NET Provider vs ODBC Topic by thompsonhab 24 Sep 2013 teradata .net provider, odbc

Is the Teradata .NET Provider more efficient (faster) than connecting to the database via ODBC? This may be a silly question, but can Informatica use the Teradata .NET provider?
Todd Thompson
Habitat For Humanity

0 replies