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.
SSO Integration through site minder or LDAP Topic by Subhash.Gander 04 Aug 2009

In our project setup BO uses hard coded user id and password to fetch the data from teradata.
So for each user the generic ID is there in DBQL.

Now we want to integrate the SSO authentication either using LDAP or site minder.
Like if user ABC is the entered from BO then the same id should be there in DBQL rather then generic id.

Any Idea ?

11040 views
7 replies, 2 years ago
Byte Field value is returing as "?" and Box Symbol in vb 6.0 Topic by ramsiva 02 Jul 2012 byte value in vb 6.0, byte value .net

Byte Field value is returning like Box Symbol with "?" Symbol , it is not in readable format in VB 6.0 after that i checked in Teradata SQL Assistant, in that byte field is returning value in readable format like 00-00-00. And i am very sure this problem is not happened due to my code problem and it is not a problem of ADO Object Library also.

3106 views
2 replies, 2 years ago
.NET Data Provider, Provider Factory, cannot create DataSource Enumerator Topic by ysrinu 24 Jun 2012 odbc, .net data provider, provider factory, datasource enumerator

I have added reference to Teradata.Client.Provider (.NET Data Provider for Teradata 14.0.0.0, Runtime v2.0.50727) to my Visual Studio C# 2010 project
Now, i want to get list of all ODBC names for Teradata

I included the namespace for Teradata.Client.Provider

3868 views
1 reply, 2 years ago
python / odbc connection to TD Topic by vijaynori 21 Jun 2012 teradata, odbc, python

 

Windows setup: tdodbc__windows_i386.14.00.00.04.zip (tdicu, TeraGSS, tdodbc), Python-2.7.3, pyodbc-3.0.3

 

I am able to extract data from using tdxodbc.  The following piece of python code also works fine -- 

 

========

>>> import pyodbc

4736 views
0 replies
Problem with starting teradata 13.0 service control Topic by yaragalaramesh 19 Jun 2012 i need immediate solution please

 

 

   Hi,

 

    I installed Teradata 13.0 express edition after completion of installation for few days it is working good.

3282 views
1 reply, 2 years ago
Problem with starting teradata 13.0 service control Topic by yaragalaramesh 19 Jun 2012 i need immediate solution please

 

 

   Hi,

 

    I installed Teradata 13.0 express edition after completion of installation for few days it is working good.

2856 views
0 replies
Problem with starting teradata 13.0 service control Topic by yaragalaramesh 19 Jun 2012 urgent

 

 

   Hi,

 

    I installed Teradata 13.0 express edition after completion of installation for few days it is working good.

1632 views
0 replies
Execute Teradata Stored Procedure from SAS Topic by danl 19 Jun 2012

Been attempting to execute an SP from SAS using: 

 Libname td teradata server="nn.nnn.nnn.nnn"

user=xxxxxxx password="xxxxxxxx" schema=xxxxx

connection=global cast=yes dbcommit=0;

 

PROC SQL;

   execute (call td.SP_01('Test_ID2', '77', 0);) by teradata;

QUIT;

 

2012 views
0 replies
Using RubyCLI Topic by mmartelli 14 Jun 2012 linux, ruby, rubycli, dbi

I'm trying to establish a connection from my linux box to a Teradata server

 

My odbcinst.ini looks as the example does

 

     [ODBC DRIVERS]

     Teradata=Installed

 

     [Teradata]

     Driver=/opt/teradata/client/ODBC_32/lib/tdata.so

     APILevel=CORE

     ConnectFunctions=YYY

2225 views
0 replies
[TeraJDBC 13.10.00.31] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 33 Topic by kerr.ding 08 Jun 2012 jdbc

I execute the sql by TeraJDBC13.1, but throw the exception:

 

 

16:55:31  [SELECT - 0 row(s), 0.000 secs]  [Error Code: 1005, SQL State: HY000]  [Teradata JDBC Driver] [TeraJDBC 13.10.00.31] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 33

2745 views
1 reply, 2 years ago
Teradata.Net Provider and Entity Framework Entity Not being filled by Stored Procedure Topic by Jasonviera 26 Mar 2012 stored procedure, .net, entity framework, teradata.net provider

After following the the example shown here :

 

http://developer.teradata.com/blog/tnguyen/2010/11/retrieving-entity-types-with-a-stored-procedure

 

I get this error when EF trys to execute the stored procedure:

3452 views
1 reply, 2 years ago
Install Teradata Express Edition on 64-bit Topic by notsan 05 Jun 2012

Hi,

As you know TD 13 is not supported on 64-bit. Is there a way of installing TD 13 Express edition on a 64-bit machine that does not support Virtualization? What are the options available?

Thanks for your time in advance!!!

Regards.

3075 views
0 replies
No more room in database All. Topic by terausr123 31 May 2012

Hi,

I once created a DB which I filled with 5000 images (50MB each). Unfortunately I dropped the table lately so I am trying to recreate the table. But

after a few hundred entries the following message appears:

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.00.13] [Error 2644] [SQLState HY000] No more room in database All.
 

6423 views
1 reply, 2 years ago
Why is TeraData JDBC complaining about these parameters? Topic by t t 23 May 2012

I have a SQL such as this:

4055 views
7 replies, 2 years ago
Using != throws an error in [TeraJDBC 13.10.00.03] Topic by M..S 30 May 2012 jdbc, bug, !=, not equals

As per subject, really.  Got a simple query:

SELECT * FROM dbc.databases WHERE databasename != 'foo'

When I try and run it through the JDBC connection I get the error:

2150 views
1 reply, 2 years ago
Using fastload from java application Topic by caleb 25 May 2012 java fastload jdbc

Hello

 

Can you kindly post a code snippet on how can one load data with fastload from csv in java application ?

I'm able to connect to TD via JDBC but I cannot find any useful docs with examples how to use fastload in an application.

 

Thank you in advance
 

4235 views
1 reply, 2 years ago
Delphi - ADO Connection String? Topic by Hanco 22 May 2012 teradata, odbc, connectionstring, delphi

Hi

The environment my Windows app runs in has recently changed and uses LDAP as the authentication method for connection to the Teradata warehouse.

But I'm really stuck, I am unable to connect using my app now.  I can connect ok using the Queryman application, using the same User ID and Password values, so I know the connection is possible and queries will run and return results from the Queryman application.

My ConnectionString looks like this:

4498 views
2 replies, 2 years ago
ADO.Net 13.11.0.1 Provider hangs when trying to create Entity Model in Visual Studio 2010 Topic by saintperez 07 Mar 2012 entity framework, visual studio 2010, aso.net provider

Trying to create Entity Framework Model in Visual Studio 2010 but it seems to hang at the point where I select the tables and hit Go. I'm able to open the connection and see the objects in TerraData but never finishes this dialog. 

 

Any help is greatly appreciated. 

4925 views
3 replies, 2 years ago
Chinese character are not displaying properly Topic by trekker 27 Apr 2012

I am using Teradata ODBC 13.0 with php and session is set to UTF16 but not able to display them properly on php page. Is there an issue with Teradata ODBC while converting Unicode characters.

The problem was persisted even I used jdbcodbc. It worked fine with Type 4 jdbc driver. 

Please Suggest 

6046 views
5 replies, 2 years ago
no "execute procedure" rights for judf Topic by terausr123 05 May 2012

Hi

I created a very basic JUDF as described in the official tutorials:

http://developer.teradata.com/tools/articles/getting-started-with-teradata-plug-in-for-eclipse

http://developer.teradata.com/tools/articles/creating-a-simple-java-user-defined-function-using-the-teradata-plug-in-for-eclipse

3702 views
1 reply, 2 years ago
Teradata JDBC driver behavior different than other drivers using Eclipse and Servoy Topic by lgormley 04 May 2012 jdbc

I am using Eclipse and Servoy (www.servoy.com) to create a CRUD application.  Using other JDBC drivers works well in Servoy but the Teradata (v14) JDBC driver does not work as well for CRUD operations.  However, the things I can do using the Teradata drivers are single SELECT statements and INSERT, DELETE, UPDATE statements and I can also make

3488 views
1 reply, 2 years ago
How can I connect from FileMaker on Mac to Teradata? Topic by smacdonald 20 Jan 2012 teradata filemaker odbc jdbc sql

Hello!

I have need to connect to a Teradata source to view (read-only) or import data into a single table of hosted FileMaker Pro database. Although Teradata provides ODBC drivers for most platforms, there is no such driver for the Mac. Actual technologies makes approved ODBC drivers for FileMaker, but nothing approved for Teradata. 

4686 views
2 replies, 2 years ago
Teradata ODBC paramter insert using SQL_ATTR_PARAMSET_SIZE not working. Topic by expressor 16 Apr 2007

Has anyone had success using the SQL_ATTR_PARAMSET_SIZE parameter with SQLSetStmtAttr for bulk inserts? When ever I set this parameter to lets say 32 if I then proceed to do a SQLGetStmtAttr(statement, SQL_ATTR_PARAMSET_SIZE, ...), the return value is still one.I have followed the instructions in the “ODBC Driver for Teradata Users Guide” in the “Using Parameter Arrays” section. This code works with all of the other major RDBMS vendors.The ODBC version being used is 03.05.00.04 on Windows 32 (2000 sp4) which should work. I have tried all version of the ODBC driver 03.05 and higher and none seem to work.Thanks-

16512 views
3 replies, 2 years ago
Unicode Conversion Error using 13.10 and 14.0 ODBC Topic by DO255001 18 Apr 2012

We are testing one of our applications and some of tests fail with the following error 

 

Teradata.Twm.Data.DataAccessException:  Unicode Conversion Error ---> System.Data.Odbc.OdbcException: ERROR [HY000] [Teradata][ODBC Teradata Driver][Teradata Database] Unicode Conversion Error

4576 views
3 replies, 2 years ago
TPT API - Delay before returning the "No more room in database" error. Topic by ggo 24 Apr 2012 tpt parallel transport api 2644 no more room database putbuffer connection

Hello,

I have a C++ application using the TPT API in "TD_STREAM" Mode (TeraData Client 13.10 + Linux VMWARE TeraData 4GB 13.10) in order to write data to some tables.

I have created a user with limited storage (something like 1MB).

3373 views
0 replies

Pages