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.
Cannot get stored procedure call from C# with output parameters to work Topic by kwhibray 27 May 2008

Hi, I'm new to posting to this forum, so please forgive any procedural/protocol issues...I'm trying to make a call to a stored procedure from a C# program using the ODBC drivers (TTU version 8.2). I found a post at this location http://www.teradataforum.com/teradata/20040329_110933.htm that I'm using as an example. I could not get my modified version to work, so gave up and copied their example exactly (including the creation of the TestProc stored procedure) yet get the same error messages. When the code reaches the lineOdbcDataReader r1 = sampleCMD.ExecuteReader();I get a dialog pop-up indicating: "The LAN message RequestNo field is invalid".Followed by the exception error message {"ERROR [HY000] [NCR][ODBC Teradata Driver] Stored procedure parameter markers are not bound."}Is it the code, or my system (i.e., some incompatibility with the .NET version I'm using? I had recently migrated the code from Visual STudio 2003 to 2005), though this is brand new functionality I'm coding in. If I could get confirmation that the example code from the forum post should/does actually work, that would be a big step. Or, another example/method for me to try would also be appreciated.thanksKevin Hibray

43761 views
7 replies, 2 years ago
TPT API with Informatica throwing invalid row length error. Topic by csesatya 29 Jan 2013 tpt, invalid row length, max row length, informatica tpt api

We are Informatica Powerexchange for TPT. When we tried to load a table with 140  columns and row length of 55k, TPT connection is throwing invalid row length error. However same is working fine with relational connection. 

2005 views
0 replies
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

19619 views
8 replies, 2 years ago
Need Help with Teradata ODBC driver on Oracle/AIX Topic by Thomas.l.Coffing3 21 Dec 2010 teradata, aix, oracle, odbc, error, tnsping

Hello everyone,

I'm trying to get a Teradata ODBC driver to work on an Oracle/AIX platform instead of windows. I've gotten the Tnsping working, however when I go to use the link I recieve the following error message:

ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from LINK_TDDEV

7326 views
3 replies, 2 years ago
Trying to set up ODBC connection Topic by Sociodude 28 Jun 2006

I've been trying to set up the ODBC connection for Teradata while using the program Advanced Query Tool. I've already downloaded the latest driver and installed it on the computer. When I go to add a new system data source and click on teradata, it gives me the following error message: "Unknown error occurred in terasso library."Then it pulls up the window that allows me to enter information such as name, description, Teradata Server Info, Default database, Username, Password, and Account String. After entering this information, I get another error message: "Unable to write Accountstring into private profile."Does anyone have any ideas?

120054 views
31 replies, 2 years ago
Unable to find compiler for CREATE FUNCTION Topic by davidp 03 Apr 2007

Hello,I'm getting the error "5600: Error Creating UDF/XSP/UDM/UDT: no compiler available" in SQL Assistant when trying to create a UDF.I've got Visual Studio 2005 installed on a Windows 2003 SP1 Server. I've set the environment variables for command line Visual C. I've successfully compiled a small c program via the command line. Any ideas why Teradata doesn't recognise the compiler?

29942 views
4 replies, 2 years ago
Atser Data JDBC drivers Topic by bunbury 11 Jan 2013 jdbc

Hello,
 
does anybody know where to download the latest JDBC drivers (4.5.1 or higher) for Aster Data?
 
thanks

5327 views
0 replies
Teradata OLE DB Provider 13.0 64 bit for Windows 2008 is not available Topic by pbarysch 21 Jun 2010

I couldn't findTeradata OLE DB Provider 13.0 64 bit for Windows 2008 on the download site.

15073 views
14 replies, 2 years ago
First attempt fails. 20 min. later connection results. Topic by hagedorn 04 Dec 2012 teradata, restart, connect informatica, catalog string

Hi,
I have a problem with Informatica connection to Teradata. Every night we kick off a job which gets an error connecting to Teradata. It gives the error message Unable to get catalog string. We restart the job and it connects after 20 min. and runs successfully. Any ideas regarding what the issue could be? Could it be a Data Source Resolution error?
Regards,
Richard

3259 views
5 replies, 2 years ago
Teradata XML services - help needed Topic by rs131112 07 Aug 2008

I have installed Teradata XML services into our test environment. During the installation I needed to modify the scripts to increase the spoolspace max for the SYSXML logon to 2GB to get the libraries to load properly - that was a bit painful. Now, I am trying to work through the first example in the document - generate a canonical schema from an existing table/view. Here's the command that I am using:call sysxml.gen_query_canonical_schema('select * from ttmp.rs_xml_test','logon','pass', outv);I am running this through TSA. It just sits there and runs with the hourglass - over 20+, 30+ minutes before I kill it. Seems like something is not right. Any comments or advise on this problem?

21665 views
8 replies, 2 years ago
Remote Access Issue Topic by TDW 14 Dec 2012

Hi All,
I am not sure of the exact perameters, so please bear with  me.

2228 views
0 replies
Excel Connector for Teradata Topic by Bajju 08 Feb 2012

Hi,

Is there any Excel connector availble to execute the query from Excel for teradata?

It should support to user to runs the query from excel & the result should populate in the same excel / other excel workbook from predefined column & row

 

Thanks in advance

Bajju

15351 views
9 replies, 2 years ago
how to configure fastload connection to informatica Topic by sanjeeviravi 12 Dec 2012

 
Hi Friends,
 
Can someone share me how to configure loader connection to informatica
we are using Informatica 9.1 hf4 on unix IBM AIX 64bit server
 
Regards,
Sanjeevi 

2566 views
0 replies
Event number 33-13810-00 (severity 10, category 12) Vconfig GDO is missing or corrupt. Topic by manish27 04 Dec 2012

HI forum,
I am new to teradata, installed demo version 12 in my pc having windows xp sp2. After installing, the "start teradata" button is showing disabled in the teradata service control. Also I have loggin issues though the host entry in etc is :
127.0.0.1       localhost localtdcop1
127.0.0.1       localhost tdadmincop1
127.0.0.1       localhost tdusercop1

2560 views
0 replies
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:

3282 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?

1532 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.

8751 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?

 

8506 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)

7011 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

3114 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.

5716 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.

2537 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.

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

4905 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,

32053 views
12 replies, 2 years ago

Pages