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.
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:

4188 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.

2530 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

7062 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.

4898 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?

2664 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.

6211 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.

5762 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

2927 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.

5567 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?

2714 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.

34475 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:

15658 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.

 

3908 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?

4195 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.

6586 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
 

4357 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?

4455 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.

 

4668 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.

6567 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.

7239 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.)
 

8683 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

5958 views
2 replies, 2 years ago
Errors Installing Teradata SQL Assistant Topic by saspert 23 Nov 2011 sql assistant 13.10

Hi,

I am having issues installing Teradata SQL assistant on my work laptop. We have Teradata 13.10 installation package and my system has Windows XP 2002.

None of my colleagues are able to help on this issue. So, I am posting it here.

6154 views
1 reply, 2 years ago
Connect Excel to Multiple sessions in Teradata, possible? Topic by Dr Zenith 22 Nov 2011

Hey Guys...

I am connecting excel to teradata through ADODB connection and getting the results in the recordset.

The thing is, I have a slew of SQL's to be run around (10-15) which need not be sequentially. Using the below method, I am able to run each SQL query one after the other,

5255 views
1 reply, 2 years ago

Pages