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.
Catalog Error Topic by jgirish 15 Oct 2008

I am getting the following error when trying to connect to Teradata from UNIX (Sun OS). This connection was working couple of weeks back and stopped working after the server crashed due to user libraries were deleted (do not know how). I am trying to connect using ODBC entry and below is how my ODBC is setup. ---------------------------[tdp1_ip]Driver=/usr/odbc/drivers/tdata.soDescription=Dev TeradataDBCName= am using to test my odbc connection. Below is the error message: -----------------------------------./demoodbc DataDirect Technologies, Inc. ODBC Sample Application../demoodbc: will connect to data source 'tdp1_ip' as user 'user1/passwd1'.SQLConnect: Failed...SQLSTATE = S1000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLSTATE = 28000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLConnect: Retrying Connect.SQLConnect: Failed...SQLSTATE = S1000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLSTATE = 28000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLConnect: Retrying Connect.SQLConnect: Failed...SQLSTATE = S1000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLSTATE = 28000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLConnect: Retrying Connect.No connection could be established. ----------------------------------------Any help on this is greatly appreciated. Thanks,

4 replies, 2 years ago
ODBC v13 Single-Signon Error Topic by Archon 30 Dec 2011

Hello everyone!

We are in the process of upgrading our warehouse from v12 to v13.10.  Our first task is to roll out the ODBC to various users to see if things are still happy. 

4 replies, 2 years ago
CLIv2 not working with LDAP mechanism Topic by mo186006 21 Feb 2012 cli, ldap

Hi, I'm trying to connect to TD server via CLIv2 console application using LDAP logon mechanism, but I get the following error: CLI2: BADLOGMECH(507): Requested logon mechanism is not available.

I have set up LDAP option by passing "LDAP" string to DBCAREA logmech_name variable:

2 replies, 2 years ago
Can I get by temporarily with ODBC driver 12.0 accessing Database V13.10? Topic by dennisfortier 06 Mar 2012

We are upgrading our database from V12 to V13.10.  In preparation for our upgrade, we have upgraded our TTU components to 13.10.  We have also installed Viewpoint to replace Teradata Manager, TDWM, ect.

It looks like our effort to upgrade desktop ODBC drivers from 12 to 13.10 across our enterprise will not be complete when the database is upgraded to V13.10.

0 replies
[Teradata][ODBC Teradata Driver] SQL request exceeds maximum allowed length of 1 MB Topic by CCMM 02 Aug 2011

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 ?


5 replies, 2 years ago
Teradata Error while connecting to the TeraDatabase using Ibatis plugin.Getting JDBC exception Topic by Patnaik 28 Feb 2012

Hi,I have used the Ibatis Teradata plugin in Rational Application Developer.I have written a simple sql select query which is mapped in a SQL Map.Then i have created a DAO from the SQL Maps.When i run the JUnit test using the build.xml i am getting the following exception.

1 reply, 2 years ago
How to coonect to teradata server with business object tool? Topic by neetu1.a 01 Mar 2012

I recently joined business objects team for report development activity. my database server is teradata server.How can i connect to teradata server from business objevts tool? what drivers i needed , & from where i can download them? what steps i should follow for connectivity?

0 replies
.Net framework version 2.0 3.0 3.5 must be installed before installing .Net data provider for TD. Installation aborted. Topic by praj 09 Nov 2011 installation, .net framework 4.0

I have .Net framework 4.0 installed.

where do we get TD .Net data provider for 4.0 version? I don't want to downgrade my app to 3.5 or less from 4.0.

5 replies, 2 years ago
Problem executing .net batch program from server Topic by AndrewMaass 12 Jan 2012

Hi - I'm new to posting to forums.  I'll do my best to describe my problem.

4 replies, 2 years ago
dwhwrapper - cli wrapper for Teradata data warehouse utilities (BTEQ,etc..) Topic by FelixBarbalet 21 Feb 2012 bteq, python, mload, csv, fastld, fastexp

Hi All

We wanted to share a python tool we've developed recently which provides a cli to teradata bteq and other utilities to allow:
* easy execution of scripts/SQL queries from the command line
* download to csv (and binary) format without third-party conversion tools
* upload from csv (and binary) format without third-party conversion tools

0 replies
Slow .Net data provider. Topic by Jakob.E_SuperG 13 Feb 2012


We have a Teradata 13.10 backend installation and a front-end installation on MS SQL 2008, using Microsoft SSAS. Due to our data model and a minor "design-glitch" in MS SSAS, we have been forced to make a MOLAP solution, generating materialized cubes on the SQL server.

2 replies, 2 years ago
Installing Teradata .NET data provider on Windows 7 with Visual Studio 2010 Professional Topic by bishtawi 17 Feb 2012

I am having problems with the install.

I am doing the complete install but messes up visual studio packages.


Has anyone had issues with installing the .NET data provider on Windows 7 and VS 2010?

0 replies
ODBC driver (32-bit) installation on 64-bit machine Topic by pcavanaugh 21 Sep 2010 odbc connection, 32-bit connection

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.

6 replies, 2 years ago
[SQLState 22003] A character string failed conversion to a numeric value. Topic by hidekoji 01 Feb 2012 jdbc case when

I was trying to do following with Teradata JDBC (


ps = conn.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY );


And it gives me following error:

6 replies, 2 years ago
BTEQ/Fastload CLI Data Transfer Encryption Topic by TSchmolzi 30 Jan 2012 cli, bteq, fastload, encryption, dataencryption

Can anyone provide information as to the encrytion strength of BTEQ/Fastload/Multiload etc when DATAENCRYPTION is ON?

I have not been able to find the specification in the Manuals. I have found where the ODBC/JDBC encryption strength is AES-128 when using the TD2 mechanism. I would like to see a similar documented specification to be able to show to management.


2 replies, 2 years ago
TPTAPI not able to connect with Teradata database with the error [PXOPL_Open: slopen_error...] Topic by ujaiswal 20 Jan 2012


I did install Teradata 13.0 drivers on 64 windows setup.

I got below DLL's in location

C:\Program Files\Teradata\Client\13.0\Teradata Parallel Transporter\bin64









But, still I am getting this error?

1 reply, 2 years ago
OdbcParameter TIMESTAMP in .Net C# problem Topic by pjozwiak 12 Jan 2012 odbc, timestamp, parameter, c#, procedure

I am trying to call Stored Procedure with parameters. Procedure have two TIMESTAMP parameters for example use below one:

    select cast(timestamp '2008-06-24 01:02:33' as timestamp(6)) into pOUT;

One IN and one OUT.

2 replies, 2 years ago
Java and .net connectors for Teradata Topic by DavidThi808 05 Jan 2012

Hi all;

We're now adding OLAP support to our reporting system and I want to make sure we handle Sql Server, Oracle, & Teradata out of the box. Where can I get information on how to access Teradata from both .net and Java?
thanks - dave

2 replies, 2 years ago
teradata .net provider usage Topic by az_maverick 06 Jan 2012 .net provider, connection string, teradata connection

Hello folks,

                I am new to Teradata , and was hoping to connect to the Teradata DB using the .net provider.

However I am unable to connect. I am getting a invalid connection string error.


I was wondering if you have to follow certain steps to connect using the .net provider ?


What is the connection string used?

1 reply, 2 years ago
Informatica/ Teradata INSERT Access WITH GRANT Issue while Loading Topic by aamirhussainciit 04 Jan 2012 teradata, informatica, insert with grant option

Hi all,


i am trying to load data in my database using informatica but getting the error that is placed below:


 Execute Direct -- [Teradata][ODBC Teradata Driver][Teradata Database] An owner referenced by user does not have INSERT WITH GRANT OPTION access to BATABASE_NAME.TABLE_NAME.ID.Unable to get catalog string.


0 replies
JMS Universal Connector feature request Topic by msschenck 26 Dec 2011 jms universal connector

Would it be possible for the next release for JMSUC to NOT hardcode the Metadata Tables DDLs and names ? I found it quite inconvenient to integrate in an existing EDW infrastructure, which follows strict naming conventions and database objects structure...

0 replies
Teradata Erro 8017 using SQL Assistant Topic by JustMe 16 Dec 2011 8017, connecting

Our users have been receiving the [8017] The UserID, Password or Account is invalid error more frequently lately.  Normally, I can reset the password and they are fine.

However, today I have a user experiencing the problem repeatedly after resetting the password.  He is attempting to connect vi SQL Assistant and using Teradata .NET Data Provider.

1 reply, 2 years ago
Teradata ODBC on Red Hat Enterprise Linux 5 64bit System Topic by Daniele.Passarella 28 Jan 2010

Hi,I tried to connect Teradata 12 Database from Red Hat Enterprise Linux v5.2 64 bit. I have installed drivers in this sequence:tdicu__linux_indep. have also installed but, when I try to connect to my DB i receive the error:Connect failed.Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [IM003:0: on HDBC] [DataDirect][ODBC lib] Specified driver could not be loadedMy odbc.ini is as follow:----------------------------[ODBC]InstallDir=/opt/teradata/client/ODBC_32/Trace=0TraceDll=/opt/teradata/client/ODBC_32/lib/odbctrac.soTraceFile=/MSTR/bin/odbctrace.outTraceAutoStop=0[ODBC Data Sources][svil]Driver=/opt/teradata/client/ODBC_32/lib/tdata.soDescription=Teradata_12_ServerDBCName=10.XX.XX.XXX LastUser=Username=Password=Database=DefaultDatabase=[default]Driver=/opt/teradata/client/ODBC_32/lib/tdata.soDescription=Teradata_12_ServerDBCName=10.XX.XX.XXX LastUser=Username=Password=Database=DefaultDatabase=----------------------------My question is: is Teradata ODBC Driver ver.13 (I tried also with 12 and 8) supperted on a Red Hat Enterprise Linux 5.2 64 bit platform?Many thanks in advance.

2 replies, 2 years ago
SQL Server linked server to Teradata specifying authentication mechanism (LDAP) Topic by tjwong 01 Nov 2011 sql server linked server ole db provider teradata authentication mechanism ldap

Have had success establishing and using SQL Server linked server (SQL Server 2008 R2) connected to Teradata using OLE DB Provider for Teradata (Version using native Teradata (TD2) authentication.
Our Teradata data source will transition to use LDAP authentication, so we must adapt our linked server for this new authentication method. (To prepare for that transition and to conduct tests, we’re provided access to a Teradata database that requires LDAP authentication.)

3 replies, 2 years ago
Calling Teradata sp from .Net Topic by Kazzie 09 Nov 2011 .net, teradata stored procedures


I am new to using Teradata and am trying to use it with to build a user app.

Can anyone please tell me how to call a teradata sp from (Visual Studio 2005)

I have a simple sp with input and output parameters, something like:

REPLACE PROCEDURE dbname.spname (IN inputnumber Integer, OUT outputnumber Integer)


2 replies, 2 years ago