550 - 600 of 937 tags for Connectivity

These are the teradata jars in my classpath:

tdgssconfig-12.00.00.110.jar
terajdbc4-12.00.00.110.jar

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

Hi,

We are working on a TPT-JMS Script where data from a JMS queue will be loaded to Teradata.
We need help on the following issues:
a) When executing the script we are getting following error in the log:

Since the error code 24 represent in-compatibility of Access module with the software.
So is this error because the files at this /export/home/teradata/java/lib location are not compatible with TPT version (or) not compatible with weblogic server.

Log1:
***************************
**** 06:32:01 JMSAM (ERROR): Java_Receive() - Error occurred in
NewDirectByteBuffer().

HI,

I need to install Teradata client on a unix server where SAS is installed . We need to access Teradata using SAS. We got SAS Access to teradata. But i want to know where i can get the Teradata client software so that i can install on the server. the OS on the server is SUN SOLARIS 10 X86.

thanks.

In the process of some heavy query (in the mean of data amount) execution my Java application got an Exception

caused by: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 12.00.00.110] [Error 1013] [SQLState HY000] Request requires message size: 6080294, exceeds system limit: 1048500

Teradata messages documentation tells nothing but this information in TERAJDBC Driver Error Messages chapter:

____
1013 Request requires message size: %1,
exceeds system limit: %2
Explanation: Information not available.
Remedy: Information not available.
____

User SQL Server 2008 to connect to Teradata

Can anyone help me on how to do this? I am using Teradata Version : 13.0.0.13 / Provider Version : ODBC 13.00.00.05 / Database Version : Teradata 13.00.0013 13.00.00.13.

How might I use SQL Server 2008 with it. Do I need to make a Linked Server, and if so how might I do that for ODBC?

Can we connect Mainframe to Teradata Express that is running on VM ware slice? If so can someone provide any details.

I developing perl utilities on windows against Teradata using DBD::ODBC with no issues. However, when I port them to our AIX server, I can't event connect successfully. ODBC appears to be correct as I can connect using the dsn using the isql utility. But when I run my perl script, it fails with "Illegal instructure" durig the connect.

Hello,
I have a strange error.
I am creating one table with foreign key on the same table :

CREATE TABLE TEST_B
(TID INTEGER NOT NULL,
PASSRESETDATE TIMESTAMP,
BACTIVE BYTEINT NOT NULL,
TEST_ID INTEGER,
CONSTRAINT PK_TEST_B PRIMARY KEY (TID));

ALTER TABLE TEST_B
ADD CONSTRAINT FK_TEST_B FOREIGN KEY (TEST_ID)
REFERENCES WITH CHECK OPTION TEST_B(TID);

I insert some data with java program :

PreparedStatement pstmt =null;
pstmt= conn.prepareStatement("INSERT INTO TEST_B (TID,BACTIVE,PASSRESETDATE,TEST_ID) VALUES (?,?,?,?)");
for(int i=1;i<3;i++){

Got a bit of a head-scratcher here.

I've got an Access front-end to some Teradata tables.
There are a couple of dozen folks using it, and 2 have encountered the following error in the last few days.

"Continue request submitted but no response to return"

The error occurs when Access is trying to bring back a result set with more records than will fit in the subform or listbox which is displaying them.

ODBC Driver version is 13.00.00.04

One of the problem users is using Access 2003, and the other is using Access 2007.

I have a Spring and Ibatis application being deployed to WebSphere 7. This application already uses a DB2 database connection, and I am adding a Teradata connection.

I created the Teradata JDBC provider and data source in WebSphere following the instructions here:

http://developer.teradata.com/connectivity/reference/using-teradata-jdbc-driver-with-websphere-application-server

(As far as I can tell, anyway... most of the images on that page don't display for me.)

We are using the PooledConnections using V13 versions of the JDBC driver and have noticed that the volatile tables seem to stay even when we call the close method on the connection.

E.g.
TeraConnectionPoolDataSource dataSource = new TeraConnectionPoolDataSource();
.. do connection
PooledConnection pc = dataSource.getPooledConnection();
Connection conn= pc.getConnection();
Statetment st= conn.createStatement();
st.execute( Create volatile table);
st.close();
.. execute somemore inserts and selects
conn.close(); // AT ths point the volatile table should go away.

But if we do

Hi! We have installed Teradata V13.10 64bit ODBC Driver on Red Hat Linux V5 and configured the odbc.ini to point to a database on TERADATA Express V13 VM on another Linux.
First we encountered a bit mode problem, apparently Teradata V13.10 ODBC Driver installation sets up all the symbolic links to point to the 32bit llibraries instead of the 64bit libraries even though our Linux is 64bit, so we manually reset all the symbolic links to point to the 64bit libraries.

I attempted to install a Teradata DB on my new work desktop today and it seemed like everything went well. Except that the Teradata ODBC driver was not recognized.

I have tried to uninstall as well as perform a cleanup. Twice. And yet, when trying to install, it says that a Teradata ODBC driver is already installed. But the wizard fails instantly, saying that the install was interrupted and that no changes to the system has been made.

I'm running Windows XP, attempting to install Teradata 12, with the 12.00.00.01 driver.

Hi,

Can some one tell me how to do the silent installation of teradata client ( terGSS, tdicu and cliv2) on NT?

Thanks,
Sowmya.

Hi,

Can I redistribute the JDBC jar files with an application? Or must I have the user get that on their own?

I remember reading about this topic somewhere, but search leads me nowhere.

Q

I have a 64-bit operating system on a server running Windows Server 2008 R2. I am attempting to create a 32-bit ODBC connection for BusinessObjects XI 3.2. I located the SysWOW64/odbcad32 application to create the 32-bit connection.

I am trying to use TPT to move a table from Oracle 10g to Teradata 12 using the ODBC operator with Oracle ODBC driver 10.2.0.3. When I execute the script with tbuild, I get

EMAIL_SRC_CD_LK_ODBC: connecting sessions
**** 12:38:34 Fatal error received from ODBC driver:
STATE=S1C00, CODE=0,
MSG='[Oracle][ODBC]Driver not capable.'
=================================================================
= =
= ODBC Driver Information =

There is a standard X.12 interface in the healthcare industry. I am new to this industry. Does anyone know if Teradata has a standard X.12 interface for healthcare? Sorry, due to lack of understanding on my part, this question may seem vague.

I am converting my .Net application from visual studio 2005(.Net 3.0) to Visual Studio 2010(.Net 4.0).
I am using the Teradata .net provider version 13.0.0.1. My development machine is on 32-bit Windows 7

After converting my .net application into Visual Studio 2010(.Net 4.0), the Teradata .net provider doesn't seem to work with .Net 4.0

Howdy, I'm having a problem installing the ODBC driver, Version 12 on my Windows XP laptop. I'm getting the following error. "Unable to Locate File C:\WINNT\Temp\pft11f~tmp\ODBC Driver for Teradata.msi". The file is there. I tried registering it by hand and still no luck. Anybody with any thoughts or suggestions? Thanks

Hi!

I'm new to Teradata. I have installed the Teradata SQL Assistant 13 and I am connected to an Oracle-DB (Oracle ODBC-driver and Oracle Net-Manager).
With The SQL Assistand 12 I got the date values as timestamps (e.g. 08.08.2010 09:53:12).
Now with the verstion 13 I only get the date (e.g. 08.08.2010).

Greetings everyone. New to TeraData and am in need of a 64-bit, Windows compatible driver (ODBC and/or OLE DB) for Windows 2003 / 2008 OS using Xeon processors. I've seen references made to such a driver but am unable to locate on this site, TeraData's site or others.

Can anyone shed some light as to its availability?

Best Regards,

Windows ODBC driver downloads are not currently available from the usual location on your web-site.
http://www.teradata.com/DownloadCenter/Forum90-1.aspx
Please update the site content.
Thank you

Hi All!

I'm use Teradata ODBC driver ver. 13.10.00.01-1. I need to bind variables but I've got a problems with VARCHAR variables (the INTEGER or DOUBLE variables are OK)

The source:

SQLBindParameter(v_stmt->stmt,
i,SQL_PARAM_INPUT_OUTPUT,col->obtype,col->dbtype,
col->dblen,scale,v_col->data,col->dblen,
v_col->len)

col->dbtype=SQL_VARCHAR;
col->obtype=SQL_C_CHAR;
col->dblen=255;
scale=0;
v_col->data; //pointer to data
v_col->len; //pointer to data's length

Hi

Is there a way to tell the character set from a char/varchar column in a TdDataReader?

The DBC tables contain a field "CharType" which is 1 for "character set latin" and 2 for "character set unicode" columns. The "ColumnLength" is also doubled for unicode.

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

I tried to issue the query banding statement along with my SQL query in a single transaction, like:
SET QUERY_BAND='AppName=B;'FOR Session;SELECT ....

This ran successfully in the Teradata SQL Assistant but not in Teradata Administrator as well as not in my application which uses JDBC connection via Teradata's JDBC driver.

Hello All,

When running some reports against the below version of Teradata, I am getting the following error. It seems to happen when the system is under load. A report which fires this error may run fine an hr later. I am pretty sure it's a connection or env limitation being hit but I am relitavely new to Teradata and need advice on how to troubleshoot from the DB side. I am very experienced with RDBMS just not that familiar with Teradata.

Error:

[NCR][Unix system error] 131 Socket error - Connection reset by peer, BufferLength = 512, TextLengthPtr = 69

Env

I am trying to install the Teradata 13.0 ODBC drivers on a RedHat Linux 5 server (fresh install, no migration) to access a Teradata 12.0 database.

I am receiving a "Segmentation Fault" whenever I connect. I am currently using the sample adhoc provided by Teradata. I get the same error regardless of what software I use to connect.

Hi,

I have installed teradata ODBC client "TTU 12.0 SOLARIS-x8664 tdodbc.12.00.00.01" on Solaris Intel platform.
The driver got installed correctly. And with other configurations (like LD_LIBRARY_PATH setting and ~/.odbc.ini configuration), I am able to connect to a teradata database and execute queries using the sample c++ program provided with the teradata client package.

To join Business Technology Summit 2010 as a speaker is a great opportunity to build brand equity for both you as an individual and for your organization.

Hi,

I need to install Teradata ODBC client on Solaris Intel platform.
Which one I should go for, from the list of clients mentioned in "Teradata Download Center"?

Thanks
VIS123

On Solaris I can't logon DB server via Teradata OBDC 13.0, even I input correct username and password.
It returns below error message:
Error: message = [Teradata][ODBC Teradata Driver][Teradata Database] The parcel stream is invalid. , sqlstate = HY000, native code = -8019

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

Hi,

We installed this teradata driver:
cliv2_WINDOWS_x8664.13.00.00.01.ZIP
on a windows 2008 box. It's a 64 bit teradata driver. But when I go to add a System DSN in ODBC, none of the Teradata drivers show up as choices. Any ideas as to why the no show?

Hi,

I have installed 64 bit Teradata ver 13.0.0.1 on a 64 bit Windows Server 2003 R2 server in the following order (not an upgrade):
TDICU, TeraData GSS client, ODBC Driver, .Net Provider for Teradata
I then installed the Teradata SQL Assistant 13.0.0.8 which appears to have installed in the Windows 32 bit path.
We created an ODBC connection via ODBC Administrator successfully with the Teradata driver recognized.
Opening Teradata SQL Assistant and making a connecting using .Net is successful. The ODBC connection does not show any data sources.

OK, so i want to pass parameters to the install when it runs to create a DSN entry etc.

Can this be done, as ive tried running with /V variable name=value but had no joy?

Please HELP

Hi Friends,

I want to do link exchange with instant payday loans website(s).... if anyone interested
please let me know

my site - [url=http://www.usainstantpayday.com/]USA Instant PayDay[/url]

Thanks
sabrinamgmt

hi ,

I am new to Teradata. I am trying to connect to Teradata DB using teradata driver. i am getting Error in DriverManager.getConnection() Method. I am not able to understand why this is comming. I have tried with the latest driver avaliable in net for teradata.

String url="jdbc:teradata:///AMRROCD"
Class.forName("com.teradata.jdbc.TeraDriver");
Properties x = new Properties();
x.put("user","xxxx");
x.put("password","xxxx");
Connection con = DriverManager.getConnection (url, x);--> I am getting Null Pointer Exception at this line .

hi ,

I am new to Teradata. I am trying to connect to Teradata DB using teradata driver. i am getting Error in DriverManager.getConnection() Method. I am not able to understand why this is comming. I have tried with the latest driver avaliable in net for teradata.

String url="jdbc:teradata:///AMRROCD"
Class.forName("com.teradata.jdbc.TeraDriver");
Properties x = new Properties();
x.put("user","xxxx");
x.put("password","xxxx");
Connection con = DriverManager.getConnection (url, x);--> I am getting Null Pointer Exception at this line .

We would like to create internal incidents in our Incident Management system when Teradata errors occur - Those reported on the AWS today.

This process is in place for errors tracked by MOM/SCOM.

Is it possible to use MOM/SCOM to report the errors generated by Teradata? (Restart, Node down...)

Regards
Klaus.

Hi.

I'm from Teradata Japan.
I'd like to let you know about great library for Teradata-Ruby connection.

We have rocking programmer, he is one of the Ruby commiter, in our PS division and he made the library for Teradata-Ruby connection.

I have installed the icu libraries and GSS client succuessfully but i get the error:
Error 1720 There is a problem with the Windows installer package. A script required for this install could not be run.....Custom action uninstall_pre_version6432, script error 214682823

It works perfect with x86 odbc driver, but failed with x8664 odbc driver.

Does anyone has suggestion on this issue? I had installed tdicu, teragss and td odbc driver.

Error message is 'Specified driver could not be loaded due to system error 126 (Teradata)'

Hi,

I am using TD .NET provider 12.x and have stored procedures. All my SPs have IN & OUT parameters. In my understanding, TD has a strange way to returning the OUT params as a dataset & it works fine. When I have SP that delete records from a table, and also returns OUT params.

When I execute this Sp from .NET, I get a empty dataset (tables = 0). On checking the data, it actually deletes the data correctly. But how can I know that records are deleted? I don't want to unnecessarily check the data for delete confirmation.

any help is appreciated. Thanks.

SP Code:

Are there any restrictions using MERGE via ODBC? I have MERGE statement which returns an error:

"[NCR][ODBC Teradata Driver][Teradata Database] The search condition must fully specify the Target table primary index and partition column(s) and expression must match INSERT specfication primary index and partition column(s)."

I connect to Teradata using ODBC and I would like to create very simple stored procedure. When I call SQLPrepare I receive error "[Teradata][ODBC Teradata Driver][Teradata Database] Syntax error: Invalid SQL Statement.", but when I call the same CREATE PROCEDURE... statement using SQLExecDirect then it works.

Hi,

Can someone pls help with the following.

Teradata service control is not able to retrieve session info as part of the verification step mentioned in the getting started manual. I followed the below steps to install TDW 12.0 today first time on my laptop with WINDOWS XP.

1. Installed all softwares listed. Installation was successful except .NET Framework 2.0 SP1, which threw an error while installing it. Restarted the system.
2. started the Teradata DB initiator thru Services.msc.