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

3677 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

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

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

16493 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

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

3363 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

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

 

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

4610 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

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

hello there

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

4361 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

 

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

3320 views
0 replies
How to restrict connection according to IP adress or Client Topic by LUCAS 27 Mar 2012 logon, inhibit

Hi,

a somewhat odd question about a simple method to restrict (inhibit) connection using a "production" User that is over-used among developpers (everybody knows User and Pwd).

In a basic context (no LDAP, no active Mechanism ...) of SQLA requests.

How to inhibit a connection when sign on is sent from some IP adresses and just sent via SQLA ?

3915 views
1 reply, 2 years ago
unable to change expired password through ODBC connection in ASP web page using VB Topic by CoderRon 22 Mar 2012 web services, connection strings, odbc connections, changing passwords

Hello. I have an inward facing ASP web app that I am changing to connect to Teradata instead of an AIX box.  I am able to connect to the Teradata Server and execute queries using an ODBC connection using VB 6 (so I'm told.

4263 views
2 replies, 2 years ago
mt.exe error - Compiling of SP. Topic by indrajit_td 26 Feb 2012

Hi,

 I am trying to compile stored procedure and I am getting mt.exe not found error. COuld you please help me with it:

Database - 13.02 (Teradata 13 express edition)

VC++ Express 2010 - installed

PC is 32-bit operating system.

 

Thanks

 

 

4903 views
1 reply, 2 years ago
JDBC driver pagination support Topic by Duri83 16 Mar 2012 viewpoint, java, jdbc, sql scratchpad, hibernate, viewpoint sql scratchpad

Hi,

3477 views
2 replies, 2 years ago
JDBC Encryption Topic by TSchmolzi 19 Mar 2012 jdbc, encryption

I have a couple application are are using ENCRYPTION=ON in their connection strings.  Is there any way to tell on the database side (DBQL, etc) so that I may verify that the encryption parameters are being accepted?

3205 views
3 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. 

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

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

2537 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

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

4910 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

Pages