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
|
655 views
|
4 replies,
5 years 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.
|
339 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.
|
272 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
|
490 views
|
2 replies,
5 years 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.
|
331 views
|
5 replies,
5 years 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
|
995 views
|
7 replies,
5 years 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)
|
718 views
|
17 replies,
5 years 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
|
22460 views
|
11 replies,
5 years 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:
|
212 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...
|
203 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)
|
4264 views
|
7 replies,
5 years 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
|
1935 views
|
5 replies,
5 years 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.
|
333 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".
|
394 views
|
3 replies,
5 years 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 :
-----------------------------------------------------------------------
|
236 views
|
1 reply,
5 years 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.
|
211 views
|
3 replies,
5 years 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.
|
856 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
|
471 views
|
4 replies,
5 years 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.
|
260 views
|
1 reply,
5 years 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)
|
254 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.
|
193 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
|
2462 views
|
5 replies,
5 years 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?
|
213 views
|
1 reply,
5 years 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-
|
1980 views
|
3 replies,
5 years 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.
|
327 views
|
1 reply,
5 years ago
|