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.
Connection Pool issue(Connection reset by peer: socket write error) with server in DMZ Topic by PheobeChang 30 Nov 2012

I am using connection pool with Tomcat 7.  The web server sits in the DMZ, while Teradata is in the internal network.  Port 1025 opened in the web server.  When the application first starts up, everything works fine.  But it seems after a short time, the pooled connection fails, with the following error:

3015 views
1 reply, 2 years ago
64 Bit OLE DB Provider for Windows Server 2008 or alternative to MSDASQL? Topic by cliffk 13 Nov 2012

We have software that does not have an ODBC option for connection to database, only OLE DB.
The software is on 64 Bit Windows Server 2008.
MSDASQL - microsofts OLE DB to ODBC Provider will not work as it is not compatible with .NET.
MSDATASHAPE does not appear to work as an alternative to MSDASQL.
1) When will the Teradata 64 Bit OLE DB Provider be released?

1377 views
0 replies
Using Named Parameters from SQL Server Reporting Services Topic by mr_tim 22 Apr 2011 odbc, .net data provider, parameter, named parameters, ?, @, reporting services, bids, report builder

Named Parameters are a great feature when using Teradata SQL Assistant. All one has to do is put "?my_parm" in the SQL. This can be very helpful in testing a query and can be a great time saver.

Microsoft's report development tools also provide the same feature... using "@my_parm" syntax within the query of a report. This works great with other databases. However, it does't work when using the Teradata .NET Data Provider nor ODBC to Teradata. One has to use an unamed parameter markert, simply "?", in their SQL.

8201 views
2 replies, 2 years ago
JDBC DatabaseMetadata.getColumns Seems Slow Topic by vlewis 22 Mar 2012 jdbc, performance, slow, databasemetadata, getcolumns

When I call

ResultSet rs = dbmd.getColumns(null, "CUSTDATA", "TRANS", null);

it takes 16 seconds to get an answer back on a fairly unloaded system.  This table has 27 columns.

 

This seems to be excesvily slow.  Is there anything that can be done to speed this up?

 

8090 views
10 replies, 2 years ago
Could not initialize class javax.crypto.SunJCE_b Topic by sreevaddi 06 Nov 2012 jdbc, r, teradatar

 

Hi,

 

I am trying to connect to TeraData from R.

 

RStudio v0.96 (R v2.15.1)

JDBC v14.00.00.21

JDK v1.7.0_07

Mac v10.7.4

 

...

library(DBI)

library(RJDBC)

library(rJava)

6467 views
5 replies, 2 years ago
JDBC works fine but RJDBC fails Topic by sreevaddi 07 Nov 2012 rjdbc jdbc single sign-on teradriver connectivity

Hi,
I have successfully connected to teradata from standalone java application using jdbc.
But fails to establish connection using RJDBC.

RStudio v0.96 (R v2.15.1)

JDBC v14.00.00.21

JDK v1.7.0_09

2867 views
2 replies, 2 years ago
Problem Authenticating through JDBC running on Linux. Topic by gbrenneman 24 Sep 2012

Hi all,
I am trying to connect to Teradata Database 14 using the Teradata JDBC 14 driver.  The Java code is running on a Linux server using Ubuntu 12 and JVM 6 (64-bit).  I keep getting the following error....
com.teradata.jdbc.jdbc_4_util.JDBCException: [Teredata Database] [TeraJDBC 14.00.00.14] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.

5423 views
4 replies, 2 years ago
DAO Error When Exporting To MS Access Topic by myokitis 11 Oct 2012

Whenever I try to export my dataset from SQLA 13.10.0.04 into an MS Access 2007 table I get the following error:
SQLA Version: 13.10.0.4
System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Access.Dao.Recordset'.

Any ideas how this can be rectified?
Thanks.

2298 views
2 replies, 2 years ago
How to Call Teradata Stored Procedure Topic by mahesh21.r 01 Mar 2010 error in stored procedure call

Hi,
When i try to call the stored procedure "ACEREWARDS_CUSTOMERPREF(?)", it throws error "something missing between "(" and "?" ", i dont know what it exactly looking for. If i removed the "(?)", it throws "stored procedure does not exists.
I am using Terdata.Client.Provider 13.0 in C#.NET3.5.
Any suggestions.

16543 views
5 replies, 2 years ago
OBIEE sourcing from Teradata nQSError: 43113] Message returned from OBIS Topic by L809rd 26 Oct 2012

Experts,
We are sourcing from Teradata 13 on our OBIEE 11g running on Windows server 2008 64Bit but we are getting errors in the dashboards as follows:

4563 views
2 replies, 2 years ago
Install Teradata SQL Assistant Topic by ddesore 10 Oct 2008

I am trying to install SQL Assistant7.1 but am getting the error - "Teradata SQL Assistant not supported on 64 bit Windows".Can anyone please provide information/link to resolve this issue ? Or if some kind of a patch exists ?Thanks,

31600 views
12 replies, 2 years ago
Java exception | locked <0x00000007c53633f0> (a com.teradata.jdbc.jdk6.JDK6_SQL_PreparedStatement) Topic by pallila 15 Oct 2012

We are getting this error when we are the doing inserts/updates from multiple threads. Has anyone seen this error before and what could be the problem. Below is the stack trace. Any pointers appreciated.
 
 
java.lang.Thread.State: RUNNABLE
        at java.net.SocketInputStream.socketRead0(Native Method)

2207 views
1 reply, 2 years ago
org.hibernate.exception.GenericJDBCException: could not execute query Topic by XenBeven 11 Oct 2012

I am getting a weird exception which I have no clue how to fix it. My scenario is:
When I execute following parameterized query using java hibernate(via jdbc driver) everything works great:
StringBuffer hqlStringBuffer = new StringBuffer("from student where name like :Name and class=:Class and section:Section");
 

5621 views
3 replies, 2 years ago
"Invalid date supplied for" error Topic by stani75 04 Oct 2012 odbc, date format, ms query

My database is a Teradata version 13.00.01.19
I retrieve data with a MS Excel v2003 file (using MS Query)
Before to do that, I installed "the tdodbc__windows_i386.13.10.00.05" products on my desktop : Teradata Client 13.10, Teradata 13.10.00.05 ODBC driver. I created a System DSN etc.

11200 views
8 replies, 2 years ago
ExecuteUpdate -- -row count return type is int Topic by emilwu 14 Feb 2011 jdbc, executeupdate, 32-bit range, row count

I noticed that the statement.executeUpdate() method returns int data type , which conforms to JDBC standard. However, here is the question: it is Teradata!!! the affected row count can easily blow away the integer range. How to deal with such issue?

8741 views
6 replies, 2 years ago
Error - Only an ET or null statement is legal after a DDL Statement. Topic by bedum 01 Oct 2012 ddl statement

I runtime combined 4 create table commands into a string. However, when i run this string as below in C#, 
 

5296 views
3 replies, 2 years ago
Perl DBI and show procedure Topic by dmtoropov.sbt 03 Oct 2012

Hi Guys. I am trying to execute 'show procedure ' using Perl DBI, but always getting wrong result. The same code with 'show view' works correctly. Does anybody help me?
 

1826 views
0 replies
ODBC--call failed error Topic by Min 08 Oct 2007

Hi,I have created views in a teradata database and i am trying to link these in access using the link function. However a pop-up box with the following error message appears when trying to link the tables:"ODBC-call failed[NCR][ODBC Teradata Driver][Teradata Database]The user does not have any access to database DB1.

23138 views
3 replies, 2 years ago
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.

2311 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

15375 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

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

Folks,
 

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

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

4777 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

1985 views
0 replies

Pages