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

2196 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

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

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

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

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

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

2145 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
 

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

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

4913 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 

6019 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

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

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

16509 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

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

3371 views
0 replies
TDLOAD Error 8017: The UserId, Password or Account is invalid. Topic by kapil_gra 01 Jul 2011

I am new to Teradata and was trying to setup something similar to sql loader to load delimited files into tables.

Below is the script i ran from my unix prompt.
tdload -c ASCII -j tdloadjobvars.txt

Below are the contents of my "tdloadjobvars.txt" file.

TargetLogonMech='ldap',
TargetLogonMechData='authcid=xxxx password=xxxx',
TargetTdpId='idwprd',
TargetWorkingDatabase = 'xxxx',
TargetUserName='xxxx',
TargetUserPassword='xxxx',
SourceFileName = 'tdload.csv',
TargetTable = 'tdload_1',
SourceTextDelimiter = ',',
TargetMaxSessions = 5

6945 views
2 replies, 2 years ago
Import Query Can be called through the Stroed Procedure Topic by isingh59 11 Apr 2012

I am importing data from Excel (CSV) file to teradata using Insert into table_name values (?,?,?),but now what i want is to use the same statement in the stored procedure .

 

The probelm i am facing is that in the stored procedure i am not able to turn on import mode .So is there any possiblity to turn on the import mode thorugh command line in the SQL assistant .

 

3392 views
0 replies
Can I switch between LDAP and Standard Authentication? Topic by M..S 23 Mar 2012 ldap, authentication

I have a Teradata user called FREDBLOGGS. 

He has an account on Teradata (UserID FREDBLOGGS / password TERADATA). 

He also has an entry in LDAP (UserID FREDBLOGGS / password LDAP).

If I set up my Teradata server to authenticate via LDAP, can this be overridden by the authentication mechanism chosen by Fred when he logs in?

4633 views
1 reply, 2 years ago
Connection Reset when clicking on Session Info Topic by terausr123 07 Apr 2012

I have installed Teradata Express 13 on Windows 7, 32 Bit. After the installation I start Teradata Service Control and click on "Start Teradata!". After a few seconds it is started.

As stated in the Getting started guide I know click on File/Session Info. After 2 seconds a popup appears which states the following error:

10054: WSA E ConnReset: Connection reset by peer

3816 views
0 replies
MORE HERE Topic by JanayTyler 07 Apr 2012

hello there

3364 views
0 replies
[Teradata Database] [TeraJDBC 14.00.00.12] [Error 6760] [SQLState HY000] Invalid timestamp. Topic by hidekoji 28 Mar 2012 jdbc timestamp error 6760

I have a test case where I bind current time (milliseconds) and it fails with [Error 6760] [SQLState HY000] Invalid timestamp. 

My question is do I have to take care of some timestamp formatting before I bind it with setTimestamp method of PreparedStatment ? Or is this a knwon issue and I can expect a solution for it?

Here is the test case details:

4381 views
2 replies, 2 years ago
Teradata connection when proxy server is on Topic by MohsinAli 04 Apr 2012

Hi,

I am using JDBC Driver 13.10 in my application, my connection is working fine, but as soon as I turn on the proxy server under internet explorer, application is not connecting and giving error server not found. While i have checked option "by pass proxy server for local addresses"

Any thoughts?

Regards
Mohsin Ali

 

2228 views
0 replies
Java XSP Error 7832 Topic by marklane1 28 Mar 2012

I have been deploying Java XSP for a couple of months.  No problems and very useful for the right scenario.  All of a sudden, a working program starts throwing this error:

"Failure 7832 XSP Application FACTSII.JXSP_BUILD_SF133 caused protocol error : authentication fields don't match (igtw-009)"

Has anyone encountered this issue?

Here is our version info:

3323 views
0 replies

Pages