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.
10065 WSE E HostUnreach from XP to remote Teradata DB Topic by Harry Droogendyk 28 Sep 2012 odbc, 10065

There's lots of posts relating to the 10065 error, but I don't see any solutions that apply to this case.
Teradata is up and running and usable for 100s of others in my organization - not a problem on the TD side.

2060 views
0 replies
tdodbc.03.03.00.13: core dump Solari 5.8 Topic by esexton@ebay.com 04 Jan 2006

Hello-I upgraded tdodbc from 03.03.00.00 to 03.03.00.13, and when running an odbc connection (samples/C/adhoc), I receive a core dump.When I rollback to 03.03.00.00, everything works fine.Could you please let me know if any additional packages are required for this install?When I truss the process, I see it looking in a directory /usr/teragss which does not exist:10161: stat("/usr/teragss/solaris-sparc.32/client/lib/libtdgss.so", 0xFF9FE7E4) Err#2 ENOENT10161: Incurred fault #6, FLTBOUNDS %pc = 0xFE92654810161: siginfo: SIGSEGV SEGV_MAPERR addr=0x0000004810161: Received signal #11, SIGSEGV [default]10161: siginfo: SIGSEGV SEGV_MAPERR addr=0x0000004810161: *** process killed ***Thanks for any help or pointers.- Ed S.# pkginfo -l tdodbc PKGINST: tdodbc NAME: Teradata ODBC Driver CATEGORY: application ARCH: SPARC VERSION: 03.03.00.13 BASEDIR: / VENDOR: NCR Corporation

15109 views
1 reply, 2 years ago
Terada ADODB performance issue. Topic by WOCSI 15 Jul 2005

I am a loadtester test on of my groups and notice that the create Object method is not scaling. I am lucky to get 10 users running and response times are taking over a minute to create. Any ideas what could be taking so long? I am trying to run a test of 30 concurrent users against a teradata odbc driver with the following method below. What is happening is we are getting Intermittent high response times trying to connect. Is there a better method to use?Dim strId, strPW, strDSN Dim objConnection set objConnection = Server.CreateObject("ADODB.Connection") strId = "XXXXXX"strPW = "XXXXXX"strDSN = "TERA07"' -------------------objConnection.ConnectionTimeout = 180' -------------------objConnection.Open strDSN, strId, strPW

21707 views
3 replies, 2 years ago
MQ Websphere connection to Teradata Topic by EN186003 21 Sep 2012 mq websphere connection teradata

Folks,
 

3063 views
1 reply, 2 years ago
Teradata EntityFramework provider bug? Topic by Abbas82 20 Sep 2012 entity framework, .net teradata client, c#

Hi,
I am using Teradata EF provider and I seem to be unable to reference a string column in the table without having to specify it in the key as well.  If I have that column in the key then all is well, but if I don't then I get the following error.  Has anyone come across this?  Or know what the issue might be?
 
 

Stack Trace: 

2036 views
1 reply, 2 years ago
Auto-Abort of disconnected Sessions Topic by clintworld 27 Jul 2010 active sessions

Hi,

I have a problem with the Teradata Database when a user is disconnected e.g. by network error.

Let's assume the user is in manual commit, ANSI transaction mode, uses the SQL Assistant, and connects via ODBC to the server.

Now, while the user is connected to the server, the network connection is lost (e.g. cable removed).

On the server side, I can still see the session of this user! This causes problems - imagine that there was a transaction which locked some tables. These locks will now stay until the session is aborted by the server (we set the IDLE timeout to 60 minutes).

4403 views
1 reply, 2 years ago
CLI Access to Geometry Data Topic by andy.street@spatialbiz.co 16 Sep 2012 cli st_geometry

I am writing a C++ application to interact with Teradata ST_GEometry data types usign CLI.
My problem is that I am not sure how to access data returned from a DBHCL call where the dbc.resp_mode is set to 'M' - Multi Record mode

1747 views
0 replies
Force user to change password at first logon Topic by Pariksheet 10 Sep 2012 password, profile

Hi ,

I want to add functionality to force users to change their password at first logon.

 

Can this be achieved through profile parameters?

 

Any other way..??

 

 

Thanks in advance.

 

-Pariksheet

 

 

2268 views
1 reply, 2 years ago
Calling a macro via JDBC Topic by opolm 05 Sep 2012 jdbc, macro

Hi,

 

I'm trying to call a Teradata macro via JDBC. I'm using the following code

2989 views
3 replies, 2 years ago
Python odbc not returning Teradata errors Topic by Pat GoHabsGo 03 Apr 2012

I have a frustrating issue with ODBC in linux redhat.

I can run SQL and get accurate error messgaes from Teradata sample testing program using ODBC.

But when I use python or isql, odbc driver manager complain and returned a generic error message.

Below is a python example:

5332 views
5 replies, 2 years ago
Support for Named Parameters in .NET Provider Topic by penfold_001 05 Sep 2012

Hi,

I am new to Teradata and I am having to port some dynamically built queries that currently run against Oracle over to Teradata.

 

The current queries use named bind variables in the SQL with the colon syntax, for example :startDate

 

2936 views
1 reply, 2 years ago
Terasso Error? Topic by nahuna 24 Mar 2009

I'm using SQL Assistant and recently had some "systematic updates" pushed to my machine that appear to have affected my teradata configuration. Not sure if one of my config/dll files was deleted/moved but it appears that might be the case. I could probably troubleshoot if i knew what a baseline set of config files should be...

13958 views
6 replies, 2 years ago
ODBC setup error for Oracle Client Topic by babu.sreeram 05 Sep 2012

Hi,

I'm trying to setup ODBC connection for my Oracle client while installing BO. Following are the steps I followed.

2488 views
0 replies
Problems in connecting to Teradata from Java on AIX Topic by sid.de 29 Aug 2012

Hi Guys , 

 

  This is my first post here , so Hello to Everyone :) 

 

   I am trying to connect to a Teradata database from a AIX box using Java . 

   I have downloaded the TeraJDBC__indep_indep.14.00.00.14.zip file and after unzipping it on a Windows box I ftped the 3                         

4247 views
3 replies, 2 years ago
Insert Data into Teradata table from excel. Topic by hungtingforspoils 30 Aug 2012

Hi,

 

Please advise if this is the incorrect forum for my query however i was hoping someone may be of assistance.

 

I am looking to put together some vba code that will allow me to connect to teradata and insert the data held in my spreadsheet directly into a td table. 

 

2291 views
0 replies
load SAS dataset into Teradata Volatile table Topic by v_gabrielli 09 May 2012

I have several SAS tables that require to be copied over to Teradata platform V13.

I usually use the Fastload option and works very well, however I need to create and

10863 views
3 replies, 2 years ago
Create UDF Topic by srikant9099 16 May 2008

Hi All,Can anybody tell me, How to create and execute the UDF with simple example.RegardsSrikant

17668 views
3 replies, 2 years ago
Laddered Concurrent Connect (LCC) Topic by vincent91 08 Aug 2012 lcc

Thank you Darrick S, vhari, steveg for your article on Laddered Concurrent Connect (LCC): Client Performance Improvements
http://developer.teradata.com/connectivity/articles/laddered-concurrent-connect-lcc-client-performance-improvements

I didn't quite catch your explanation :"Once the first successful connect is recognized, any remaining occupied sockets are released (closed). A down node will no longer force the client interface to pause until the wait time interval has expired before it attempts to connect to another node."

3598 views
3 replies, 2 years ago
TERADATA SQL ERROR 3945: Invalid data length for VarChar, VarByte, orVARGRAPHIC while using JDBC connection Topic by Achieng 29 Jun 2011 database connectivity

We are getting this exception when running a query in a web application which coonects to Java API through a web service. The jar being used is terajdbc4.jar and the version of JDBC being used is TeraJDBC 13.00.00.22. I have run the query using bot ANSI mode and Teradata mode both using CLI,ODBC and Terardata.NET;no such error has been seen.

6079 views
4 replies, 2 years ago
08024 All virtual circuits are currently in use. Topic by spring-box 07 Aug 2012

Hello 

Now we use Tedradata Express 14.
We encountered the following errors and stoped this system. 
 08024 All virtual circuits are currently in use.

Please teach anyone how to resolve this issue?

Best regards,
 spring-box

3680 views
2 replies, 2 years ago
Where is the download URL for latest TeraGSS_suselinux-x8664 and TeraGSS_redhatinux-x8664 Topic by ericsun2 30 Jul 2012

I can't find it in the download center...

 

Please advise.

3009 views
1 reply, 2 years ago
Entity Framework, fluent api and trouble when mapping Boolean type to byteint Teradata database type Topic by extern 18 Jul 2012 entity framework fluent api boolean type

How can I map Boolean type using Entity Framework, Fluent Api?

I found this in Teradata type mapping documentation

"

Teradata does not natively support a Boolean type.

SSDL must be manually modified to enable Teradata ByteInt to Boolean Type mapping. Precision Facet must be set 1 as shown below:
Boolean Entity Type Mapping     Copy Code

4028 views
1 reply, 2 years ago
Not able to create/connect to new Database Topic by javed080787 18 Jul 2012

Hi,

 

I am new to Teradata, I have installed Teradata 13.0.

When i opened the SQL Assistant and try to connect or create a new database I am getting error

 

"160 specified driver could not be loaded due to system error 126 (teradata)"

 

Please let me know what is the resolution for this.

 

Thanks in advance.

 

3271 views
1 reply, 2 years ago
Problem with Teradata Express V13.0 Topic by learning_td 25 Jul 2012

Hi, I trying to install Teradata Express v13.0 in a Windows 2008 server machine, the installation finished succesfully, but when I click "Start Teradata" on Teradata Service Control, fails to display the message "Teradata is running", the last message display is "PDE state is RUN/READY".

Can someone help me?

Thanks. 

2796 views
0 replies
Unable Able to Run Access Update Query Topic by DRossmann 16 Mar 2012 odbc, update, ms access
6579 views
4 replies, 2 years ago

Pages