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=10.206.68.19DateFormat=AAASessionMode=ANSIDefaultDatabase=UserName=Password=---------------------------I 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,

26185 views
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. 

5342 views
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:

4193 views
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.

2531 views
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 ?

Thanks

7085 views
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.

4900 views
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?

2665 views
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.

6215 views
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.

5774 views
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

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

Hi.

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.

5577 views
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?

2715 views
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.

34731 views
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 (14.00.00.09)

String sql = "SELECT DISTINCT CASE WHEN 'All' = ? THEN LOV.VAL  ELSE ? END  FROM  LOV"; 

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

 

And it gives me following error:

15762 views
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.

 

3913 views
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

Hi,

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

loadop.dll

pxicu.dll

exportop.dll

opcommon.dll

streamop.dll

telapi.dll

telapi.lib

updateop.dll

But, still I am getting this error?

4198 views
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:

REPLACE PROCEDURE tsTestInOut
(
    IN pIN TIMESTAMP,
    OUT pOUT TIMESTAMP
)
BEGIN
    BEGIN
    select cast(timestamp '2008-06-24 01:02:33' as timestamp(6)) into pOUT;
    END;
END;

One IN and one OUT.

6623 views
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
 

4358 views
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?

4457 views
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.

 

4677 views
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...

4510 views
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.

6611 views
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.13.00.00.00TeraGSS__linux_i386.13.00.00.00-1tdodbc__linux_x64.13.00.00.02I 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]default=tdata.sosvil=tdata.so[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.

7248 views
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 13.10.0.1) 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.)
 

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

Hi,

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

Can anyone please tell me how to call a teradata sp from vb.net (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)

BEGIN

5969 views
2 replies, 2 years ago

Pages