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.
Connectivity issue Topic by atiliomedina 09 Apr 2016 teradata driver, odbc, php

Hi All;
I have installed the drivers for php on a RHEL 7 system. I've configured the odbc.ini with the same settings I had on an older system but I am getting this error when trying to load a page that queries the database. Installed driver is 15.10

206 views
4 replies, 7 months ago
Failed to start REST service Topic by badlishah 08 Sep 2016

Hi,
I'm a newbie. My team have installed REST and Tomcat. However, we found that REST service failed to start. We rebooted and during the reboot we could see that 'tdrestd.. FAILED'. Starting it manually also gave us same 'FAILED' message. 
We checked REST logs only to find 'catalina.log' and 'init.log' in the logs folder. 

13 views
0 replies
IP address based access to TD. Topic by Dinesh1975 04 Sep 2016

Please Can anyone let me know how to implement IP address based access to TD.

20 views
0 replies
Teradata ODBC 15.10 32bit and MSAccess 2016 32 bit Cannot find Terasso library Topic by johnhrschuster 24 Aug 2016 #ODBC, msaccess, 2016

I am doing some testing on Windows 10 with Access 2016.
Both are 32 bit installations
The Teradata ODBC DSN works fine with SQLAssistant 15.10.00.02
The Teradatra ODBC DSN works fine with Bi-QUERY 10.5.2.462 and 10.5.2.462 Patch 2.
The installed Teradata GSS client is 15.10.00.02.  NT-i386

55 views
2 replies, 7 months ago
Can you get Teradata.Client.Provider for c#/dot.net just from disk? Topic by flash7gordon 22 Aug 2016

Hi,   Have one version of the Teradata Client installed on the laptop where I do my compiles.   I want to use another version of the Teradata.Client.Provider for my compiles.   Can I just point to the right disk files and use another Teradata.Client.Provider version other than the Teradata Client that is installed on my machine?   I know this works for the compile.

55 views
5 replies, 7 months ago
Excel 2016 VBA Connection Topic by tmw 06 Mar 2016 Excel 2016 VBA Macros

We use Excel 2010 VBA connections to run Teradata scripts (both inserts of data from Excel to user tables and selects to populate excel from teradata tables).  The VBA is like this:
Public Function Teradata_Connection()
Dim constr
pwd = frmTDconnection.txtPwd.Text
uid = frmTDconnection.txtUsr.Text
On Error GoTo Invalid

582 views
7 replies, 8 months ago
Teradata JDBC Driver returns the wrong schema / column nullability Topic by jasonmoore2k 17 Aug 2016 jdbc

I'm running an Apache Spark application that uses terajdbc4 to fetch data from a Teradata server.  It seems to be returning the wrong value for the nullability for many of the columns in the table.  I've found two scenarios at work:
1. If I use dbtable = "TABLE_NAME" all columns are returned with nullable = true (despite some not being nullable)

113 views
17 replies, 8 months ago
how to install teradata express edition on windows 7 Topic by Big apple 07 Nov 2009

Hi all,I want to install teradata expression edition on my windows 7 machine. but it say windows does not support. so what should I do?please helpbig apple

22225 views
11 replies, 8 months ago
query newline vs carriage return issue using Perl unixODBC and RHEL Topic by dastrauch 30 Aug 2016 perl, unixodbc, RHEL, newline, error

I have installed teradata 64bit drivers,  unixODBC 2.3.4 and perl DBD::ODBC 1.52 on  RHEL 6 linux.
Everything is working with short single line queries from both isql and perl.  However, multi-line queries fail with
set_err: state ('400') is not a 5 character string, using 'S1000' instead at /usr/local/lib64/perl5/DBD/ODBC.pm line 229.
DBD::ODBC::db prepare failed:

7 views
0 replies
Teradata performance mointoring for each querry Jmeter testplan Topic by bhushan.koli 25 Aug 2016

Hi,
I am connecting teradata db (located on remote location) from my local machin through
 jmeter 3.0 ,and my testplan contains 20 querries and i want to measure performance (cpu,memory)
for each querry seprately.
Jmeter's perf_mon plugin is available but it will measure whole testplan performance...
 

11 views
0 replies
Using RJDBC and connected successfully, I get errors when trying to write using "as.td.data.frame" or "dbWriteTable"... Topic by dcelta 29 Nov 2012 [error 3932] [sqlstate 25000], as.td.data.frame, dbwritetable

Hi,
I can establish the connection just fine.... 
My connection statement:
 

jdbcCon <- dbConnect(drv = JDBC("com.teradata.jdbc.TeraDriver"),user = UID, password = PWD, 

paste("jdbc:teradata://",DSN,"/database=",DataBase, ",TMODE=TERA,CHARSET=UTF8", sep = ""))

assign("tdConnection", jdbcCon, envir = .GlobalEnv)

4061 views
7 replies, 8 months ago
Querying Teradata from JavaScript/jQuery? Topic by PeterSchwennesen 07 May 2014 JavaScript jQuery

Is it possible to access Teradata from JavaScript/jQuery?
If it is possible, is there some example about how to connect to Teradata, send a Query, get a dataset back?
Peter Schwennesen

1626 views
5 replies, 8 months ago
Segfault fetching results via ruby-odbc on Mac Topic by ashbachj 19 Aug 2016 mac, odbc, ruby

Hello, we are attempting to connect to a Teradata database using ruby-odbc. Our code works properly on our Windows machines but it has a segfault on a Mac. I have reproduced the error message and crash log below. Prior to the crash, it appears to be able to connect and execute the query. It only crashes when we attempt to do anything with the results. 

 

12 views
0 replies
Teradata Client 15.0 to 15.11 for c# dot.net builds Topic by flash7gordon 17 Aug 2016 c#

Hi,   Work for a big company.   Recently we had a forced 15.1 from 15.0 Teradata Client install on our laptops where I do my c# builds.   Everything (builds and runtime) ran fine on my laptop but when I move my executable to a dev machine it failed with "System.IO.FileNotFoundException: Could not load file or Assembly "Teradata.Client.Provider".

80 views
3 replies, 8 months ago
Connecting to Oracle Topic by punitgupta87 17 Aug 2016 #Teradata #JDBC #Connectivity

Teradata ODBC Driver is giving an error while I am trying to access tables afer connecting to oracle database from Teradata SQLAssistant.
Error is as : 
-----------------------------------------------------------------------

23 views
1 reply, 8 months ago
CLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGON Topic by BRIANH 12 Aug 2016 beh

I have run several tests using BTEQ and have altered between logging on using an IP and a name in the Windows hosts file.

33 views
3 replies, 8 months ago
Connection to Presto with Teradata ODBC from Tableau stopped working Topic by Irka 16 Aug 2016 tableau, #ODBC, Presto, #Presto ODBC

I'm using Tableau 9.3 on a windows server.

I also have Presto for querying over Hive.

Using the Teradata ODBC connector to connect to Presto.

Presto release: 0.147

Hive version: 1.2.1

 

When using the Tableau Desktop to create a workbook, the connection works fine and I'm able to get data from tables correctly.

27 views
0 replies
OLEDB Driver of TD15.10 Topic by N_Raghu 12 Jul 2016 OLEDB Driver of TD15.10

Are there any plans to release oledb driver for TD 15.10? Because I have SSIS packages that were developed with previous OLEDB version and those SSIS packages are crashing when I open in visual studio

212 views
4 replies, 8 months ago
Teradata Presto Driver Connectivity INT Datatype Limitation Topic by sureshb79 10 Aug 2016 #Presto ODBC

Hello,
We are using Teradata ODBC driver for Presto to connect to Hive data.
We observed that, SELECT query with INTEGER Column just hungs.  If we cast the column with Varchar/BIGINT we are getting response.
We are able to fetch other columns with type Varchar, Bigint, Date etc.

79 views
1 reply, 8 months ago
ODBC Driver Suite - Windows 2008 missing for v14.10 Topic by gp19380 10 Aug 2016 #ODB C

https://downloads.teradata.com/download/connectivity/odbc-driver/windows

 

 

 

 

 

I am trying to download version 14.10.17 driver but I noticed in the readme that it does not mention in Windows Server 2008 in the ODBC read me file (tdodbc__windows_i386.14.10.00.07)

 

 

 

73 views
0 replies
ODBC connectivity to teradata from RHEL Topic by skbinwal 09 Aug 2016 #ODBC #Connectivity #FastExport #Utility

Hi,
As per a post dated 2013 Teradata odbc didnt support Fast Export or any other utilities. Is it still the case or has there been an update on this.
I need to connect to teradata database from RHEL box using odbc to extract the data. As of now I am only able to do so using tdxodbc.

20 views
0 replies
Connectivity issues for SQL Assistant 15 Topic by abhilash.nair 29 Dec 2014

I recently installed TTU 15. The Windows version is XP Sp3 32 bit.
I was using the TTU 14 previously and it was working fine.
Prior to installing the new version, I completely uninstalled all the tools related to v14 using the unintall vb script provided alongwith the TTU 15 package
Then I rebooted the system and installed TTU 15
 

1941 views
5 replies, 8 months ago
Error while getting database functions via JDBC Topic by iozee 08 Aug 2016

Hi,
when I call java.sql.DatabaseMetaData#getFunctions method, I get the following error:
[Teradata JDBC Driver] [TeraJDBC 15.10.00.22] [Error 165] [SQLState HY000] getFunctions: function not supported in this version
Is there a solution for this?

45 views
1 reply, 8 months ago
Teradata JDBC Connection Failure Topic by saubl 11 May 2016

Hi
I installed Teradata studio express 15 on windows 7-32 bit.
I am facing issue while setting Teradata connection.
Exception-

1213 views
3 replies, 8 months ago
Connecting to Teradata through PYODBC on Mac Topic by laura.barron@schwab.com 02 Aug 2016 pyodbc, os x

I have been trying to connect to Teradata using PYODBC from my Mac terminal. I have the Teradata ODBC drivers installed but PYODBC doesn't seem to be able to find them. This is the connection string I have created:
pyodbc.connect('DRIVER={Teradata};DBCName=XXX;DATABASE=XXX;Authentication=TD2;UID=XXX;PWD=XXX')
And this is the error I am getting.

35 views
1 reply, 8 months ago

Pages