350 - 400 of 752 tags for Connectivity

Hi,

Hi,

I need to get the following information of all table indices of a table with the JDBC 'getIndexInfo()' method
to be able to create a similar table but with modified indices.

- The index number
- The index column name of the index number
- The index column position of the index number
- The unique index flag of the index number
- Primary or Secondary index flag of the index number

The first 4 are returned nicely by the 'getIndexInfo()' method.

But I'cant see any information returned by the 'getIndexInfo()' method that
looks like a 'Primary or Secondary Index' flag.

I am trying to create a db connection odbc on linux and php. I have installed unixODBC 2.3.0 and the latest Teradata utilities, TeraGSS, TDICU, and TD ODBC.

I can connect to Teradata and query and view data using the ISQL application that is part of unixODBC. However, when I use odbc_connect() in php, it will not connect.

I have traced the failed connection, and find this in the trace log:

245 TS:250: SSOLibSetMechName calling gss_get_actual_mech_name -> ret = 0 [ SingleSignOn.cpp 665 ]

Hi

I faced a problem with Teradata 13.1 ODBC driver installation.
I can successfully install tdicu on my machine. But when I was trying to install TeraGSS, installer always report error as follow:

"package TeraGSS_suselinux-390-13.10.00.02-1 is intended for a 390 architecture"

Hi,
I am having issues to connect to TearaData using ODBC drivers provided by Teradata TTU's. If i try to connect using Information Server provided ODBC drivers, it is not able to source the libraries - could be due to 32 bit drivers of TeraGSS. Any one ran into similar issue?
Appreciate any information. Also i am looking for an example how to connect from Linux command line to Teradata using ODBC drviers?

Here is my environment info -

Operating system = RedHat Linux 5.5
Information Server = 8.5 version
TTU's on Linux box = 13.0 version with few patches for TPT

Hi all, i am new to this forum. I need your help on a issue of a Java application which we are facing into production. The app is talking with teradata db (v 12) via JDBC api; It is working fine, but recently app is unable to talk with db in few instances. I have got below exception in catalina.out file. Appreciate if anyone can put light on the issue.

Exception:

INFO | jvm 1 | 2011/02/21 14:32:21 | 2011-02-21.14:32:21.306 TERAJDBC4 ERROR [pool-3-thread-2] com.teradata.jdbc.jdbc_4.TDSession@2ea70c Read message 1: Incomplete LAN message header: read 0 bytes

Hi,

Hello everybody,

I have setup a linked server in SQL 2005 using:
1. 64-bit Teradata ODBC drivers (native OLE DB does not support 64-bit)
2. I use the Microsoft OLE DB provider for ODBC.

When executing a count from SQL Server to a teradata table it does work, i.e.:
1. Query:
SELECT COUNT(*) FROM TD..PRD_edw_views.offg;

2. Result:

-----------
4656

(1 row(s) affected)

When I try to select (*) the data from the table I get the following error. It does look like some sort of table definition is returned but not data, the error:

I noticed that the statement.executeUpdate() method returns int data type , which conforms to JDBC standard. However, here is the question: it is Teradata!!! the affected row count can easily blow away the integer range. How to deal with such issue?

One of our application teams just installed TTU13.0 on a server. When trying to connect, they receive the following error:

[.NET Data Provider for Teradata[]1150009] Message truncation error, not all data was received.

Any ideas as to what causes this and what the solution is?

Thank you

Hi!

This might very well be an easy problem to solve - but I obviously need help doing so.

I'm using a dev environment (BIDS) on Server1 (Windows Server 2008 x64). Analysis Services is running on Server2 (Windows Server 2008 x64). The data is in a Teradata database on Server3.

Is it possible to log in to the "MONITOR" partition of the Teradata DB using the .NET Driver? And then use the PMPC sub-system commands like: "MONITOR PHYSICAL RESOURCE"

I know it is possible with the JDBC Driver...

I'm not sure this is the correct forum for my question, but I'll give it a try!

After installing the .Net Data Provider for Teradata, I am unable to use it, since I can't see the provider in any list over data providers.

Details:
I've installed the .Net provider ver. 13.10.0.0 on a Windows Server 2003, SP2. .Net framework is version 2, SP2.

The installation seems to do it's job, I find all the dll:s in the GAC and everything is in place (according to the .Net Data Provider for Teradata Help, which is also installed).

I am kind of stumped here maybe some one can help shed some light. I connect to the db with this connection string

URL += "://" + host + "/" + database+" /CHARSET=UTF8,COMPAT_DBS=true,DBS_PORT=" +port;

url is the jdbc:teradata

we have it as a variable because we are an etl tool and connect to diffrent dbms. I am currrently trying to add support for teradata. II can get a successful connection using that string but if i try to send a sql statement or use

else if (dbms.equals(TERADATA))
{
tableTypes = new String[] { "TABLE" };

I am connecting to a db server with the .Net Provider. I have a macro that accepts an integer parameter. When I add the parameter, I get a mismatch error:

[Teradata Database] [3939] There is a mismatch between the number of parameters specified and the number of parameters required.

Not sure what I am doing wrong. Here is what I have:

using (TdConnection cn = new TdConnection("Data Source = " + TeraDataServer + ";User ID = " + userid + ";Password = " + password + ";"))
{
cn.Open();
TdCommand command = cn.CreateCommand();

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.

Pages