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 create a new forum topic.

How to Call Teradata Stored Procedure Topic by mahesh21.r 2 weeks ago
Tags:
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...
144 views
2 replies, 1 day ago
Set the TdCommand.CommandText to the Stored Procedure Name and Set the TdCommand.CommandType to CommandType.StoredProcedur e. Data Provider will gen...
NetFx
OBDC Segmentation fault / core dump on Solaris Topic by ErVa 2 weeks ago
Tags:
Hello everybody Here it is the problem : I install - the odbc drivers 12 install on solaris 10 (sparc) - teradata 12 - unixODBC (2.2.14). When i try the connection (isql) with a bad login/password it fail and it is of course normal but when i try with a good login/password my con...
109 views
1 reply, 1 day ago
Why do you list unixODBC? Are you trying to use unixODBC Driver Manager with ODBC Driver for Teradata?
NetFx
.NET Provider performance Topic by rluebke 11 Jun 2008 Is there anyway to get the .NET provider to perform anywhere near as well as fastload for loading data? We have several applications, in c#, that need to monitor directories and then load those files into a Teradata warehouse. I would prefer not to have to shell out to call fastload.
Curr...
46586 views
21 replies, 1 week ago
how about creating a console app that will run fastload then accepts a parameter which is the name of the file("test.fld") then calling that consol...
xer
VS2010 Beta Topic by rluebke 1 week ago Has anyone successfully integrated the TD12 or TD13 .NET provider into VS2010 Beta? I realize it is not going to be supported as VS2010 is still in beta. I can use it, but I was hoping for a little tighter integration on par with VS2008. R
65 views
0 replies
Teradata ODBC-Connect from PHP (Linux Red Hat) Topic by vfpde 2 weeks ago
Tags:
Hi, I am trying to connect Teradata from Linux Red Hat ( LAMP-Installation ) via ODBC-Driver. isql works fine, but i cant connect Teradata with PHP. SQL error : SQl State in 00000 in SQLConnect ... ( Teradata ODBC Version 13.0 - Red Hat 4.0 ) Has anybody working a PHP/Teradata Co...
87 views
0 replies
Error while executing Stored Procedure Topic by tmrmodest 4 weeks ago Hi all,
I have installed Teradata Demo version 12.0 in my PC. While i compiled a simple stored procedure the following error was prompted.
Error: C/C++ compiler is not installed.

Does C/C++ compiler is required for running Stored Procedure?
Where can i get this comp...
265 views
1 reply, 2 weeks ago
Yes you do need a C/C++ compiler. Search for: Visual Studio Teradata Demo
NetFx
ODBC parmeter help Topic by lucasfilm 3 weeks ago Does anyone know where I might find help for ALL the Input paramameters in the ODCB setup for Windows? The User help file I found for ODBC on the Teradata Support site just says "make editing changes". But doesn't say anything in detail about the different parameters, and there's a lot of them!
121 views
1 reply, 2 weeks ago
Did you try the online help? each dialog box has a "Help" button which displays the online help for each dialog-box. At this point, you must click...
NetFx
ODBC Installation interrupted Topic by vp 3 weeks ago Hi,

I'm trying to install ODBC driver 12.0 on my Windows server. I installed the GSS and the shared libraries. When installing the ODBC driver, it stalled at deleting backup files for over 2 hours. So, I stopped it using task manager. I rebooted and retried the installation. I get th...
165 views
0 replies
Teradata Forums migration imminent Topic by Host 4 weeks ago Dear users,



Per recent communication, we are pleased to announce the consolidation/merger of the Teradata Discussion Forums and the Teradata Developer Exchange Forums. The integration of the forums will create a single location - http://forums.teradata.com - for you to ...
107 views
0 replies
Teradata ODBC on Red Hat Enterprise Linux 5 64bit System Topic by Daniele.Passarella 7 weeks ago Hi,



I tried to connect Teradata 12 Database from Red Hat Enterprise Linux v5.2 64 bit. I have installed drivers in this sequence:



tdicu__linux_indep.13.00.00.00

TeraGSS__linux_i386.13.00.00.00-1

tdodbc__linux_...
351 views
0 replies
cross database comparison Topic by rychitre 7 weeks ago Is their any free utility to compare tables/data of two different databases (sql server and teradata)?
189 views
0 replies
the data is screwed when returning special characters in teradata client 13.0 Topic by manumanishk 8 weeks ago i have windows server 2008 64 bit version and there i have installed teradata 13 driver. when I run select query the special characters is convert to some junk character but in other machine it works fine. do i have to do any settings on the server specific to language. please help.
289 views
1 reply, 7 weeks ago
Post additional information; for example a) Teradata 13 Driver: Do you mean ODBC Driver? b) Session Character Set: Are you using ASCII sessio...
mkandaaa
Error selecting Date when using jdbc Topic by twc87 01 Apr 2009 I have a table with a few columns of DATE type. I am able to select data from this table using BTEQwin. However, as soon as I use something which connects via the jdbc driver I get the message "TeraResultSet:getTimestamp function failed".



I am using driver 12.00.00.107....
3013 views
3 replies, 9 weeks ago
Teradata JDBC Driver version 13.00.00.07 and earlier versions of the Teradata JDBC Driver do not support the implicit data type conversion of calli...
Flavio Cavalcante
Connection String for VB.NET OLEDB class? Topic by CapsuleCorpJX 9 weeks ago This is the connection string an application using VB 6 uses to open a connection:
"Driver={Teradata};DBCNAME=" & lsDB & ";UID=" & lsUID & ";pwd=" & lsPWord & ";DATAENCRYPTION=Y;"


How do I open a DSNless connection for VB.NET? (using the OleDB.OleDBConnection class).
346 views
1 reply, 9 weeks ago
Use ".NET Data Provider for ODBC" not ".NET Data Provider for OLE DB". I suggest ".NET Data Provider for Teradata" if there is no specific requir...
mkandaaa
any limitations with large number (10,000) parameters to sql SELECT via JDBC? Topic by mikereiche 9 weeks ago I need to query on up to 10,000 different values :

SELECT * from MYTABLE where COL1=? OR COL1=? OR COL1=? ...

Is there a maximum number of parameters that can be passed, or a maximum length to the query string?

Is there any configuration or tuning that migh...
390 views
1 reply, 9 weeks ago
The Teradata Database imposes a limit of 1 MB for SQL request text. Also, I suspect that you would hit a Teradata Database parser limit for too ma...
Flavio Cavalcante
ODBC driver for OS X Topic by sfkeydel 29 Sep 2009
Tags:

Hello, I'm trying to locate any official or unofficial ODBC drivers to connect from OS X to Teradata. Can anybody point me in the right direction? Thanks, Stefan
483 views
3 replies, 10 weeks ago
I know of a couple of ODBC-to-JDBC bridge drivers: from OpenLink - http://uda.openlinksw.com/ odbc/st/odbc-jdbc-bridge-s t/ from EasySoft - htt...
tomnolan
Teradata .Net Drivers on Windows 7 Professional 64 Bit Topic by krravi 18 Dec 2009 I migrated to Windows 7 64 bit, while every other piece of software works, Teradata doesnt. Its the CLI that doesnt install on Windows 7 no matter what compatibility mode i have it set to.

Is Teradata aware of this and is there any solution ?

Thanks.
773 views
2 replies, 12 weeks ago
Yes but unfortunately, we have some applications using ODBC (still ?) for which we need GSS and the rest of the pieces.
rajesh.jain
RSA Encryption in Teradata Topic by bhavani1 16 Dec 2009 Hi,

We are currently working in host mainframe applications that runs on the Teradata database.
We have a situation where some of the data are being encrypted in a Unix C application usnig RSA encryption.
They also have the decryption routine and the key. Is it possible f...
444 views
0 replies
Java UDF on Teradata 13 demo is very slow. (Vista OS) Topic by pganelin 07 Dec 2009 Test Case:
Table INDATA with two column X,Y. Create table OUTDATA with two columns S and D which are sum and difference of X and Y respectively.
Using SLQ the problem can be solved easily as


CREATE TABLE OUTDATA AS
( SELECT X+ Y AS S, X - Y AS D FRO...
656 views
1 reply, 14 weeks ago
Here is the full source code for calculate method: public static void calculate(double x, double y, ...
suman
install error for DBD-Teradata-Cli-12.001 Topic by sky_zh 07 Dec 2009 Hi all,

According to install desc(http://www.presicient.com/tdatdbd/), I installed DBD-Teradata-Cli-12.001 to connect teradata.
But it was failure. Could anyone help me to resolve ?
Red Hat AS4
Perl 5.8.8
DBI-1.609

Btw, I can connect teradata by u...
512 views
0 replies
Teradata C/++ UDF Tutorial Topic by caudex-9011 26 Nov 2009 I am looking to write a simple UDF in Teradata 13 Express.
This method will take in 2 parameters, both of these will be the type ST_Geometry.

I am looking for a tutorial which will guide me through the following process:
1. Obtaining the C/++ Headers for Teradata
2....
1196 views
3 replies, 15 weeks ago
The ST_Geometry type is a type not a system function, but you can't access them within a UDF. You can always pass in the WKT or WKB to a UDF and p...
catchme1210
Teradata JNDI connectivity Topic by rajivgupta1107 02 Dec 2009 Hi,

We have teradata12 installed on my machine. I am trying to connect to teradata from a java application. When i try to connect through JDBC, i can connect. But when we try to connect using jndi, i am getting the error as:


Error occured while trying to connect t...
777 views
2 replies, 15 weeks ago
thanks a lot, it worked :)
ennis
Connection timeout with .NET provider 13.01 Topic by vankaz 15 Nov 2009 I have installed the Teradata .NET driver 13.01 and have tested it using the NDQuery from a desktop machine. The connection to the server works and I am able to run queries also.

But, I need to have the driver installed on a server grade machine, and on that machine, the NDQuery app...
864 views
1 reply, 17 weeks ago
.NET Data Provider also uses port number 1025 by default. The port number is configurable via the Connection String. It is documented in the Help-...
mkandaaa
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 help

big apple
1557 views
3 replies, 17 weeks ago
If your Windows machine has an Intel CPU that supports virtualization (Intel VT feature), I recommend the new Teradata Express for VMWare, which yo...
gururaj_cse
SSO Integration through site minder or LDAP Topic by Subhash.Gander 04 Aug 2009 In our project setup BO uses hard coded user id and password to fetch the data from teradata. So for each user the generic ID is there in DBQL. Now we want to integrate the SSO authentication either using LDAP or site minder. Like if user ABC is the entered from BO then the same id should be...
791 views
5 replies, 18 weeks ago
Hello, I neither do get LDAP working in my environment. I've a simple LDAP service on Win2K3 and trying to authenticate users thouth this lda...
jwernert
You must login to create a new forum topic.