350 - 400 of 1062 tags for Connectivity


What is the charset that I need to choose for writing the turkish characters using jdbc drivers ? Tried with UTF8 and UTF16 but none of them helped.

Unable to login into TD Demo express Evaluation version 14.10


Hi All,


I have installed TD evaluation demo version 14.10.When I trying to log into Bteqwin using below credentials I am getting different errors.I have given the login details,errors and hostfile entries as well below.Can some help me out in this:

I have a table with same column title(not the column names), runing a SQL on it from Java is returing same values for both the columns, it is because of same column title, but same SQL in SQL Assitant returns correct values, where can i find and confirm if same title is reason. is there a driver documentation which states this behaviour.

Does anyone know the Target Date or Release Date for an OSx TTU release? 

I want to connect to teradata.net via batch file. Version of teradata i am using is 13.10, i don't know whether it has bteq enabled or not?

Does anyone have experiece using .NET Provider with Mono CLR on Linux? I cannot find any information in the help file or Teradata site. 

In order to use Teradata with .NET, do I need to do a full install of the drivers on the web server or do I just need Teradata.Client.Provider.dll and the Teradata.Net.Security.Tdgss.dll?

I am using integrated security with TeraData and ASP.NET MVC3.  I am getting the following exception when trying to open a connection:
Server Error in '/' Application.
The NTLM authentication token is not supported.
ErrorCode: -452984668 Severity: Error Facility: DotNet

I am trying to import into MySQL with the MySQL Workbench migration wizard.
I can connect to source DBMS (Teradata), I can retrieve schema list from source, but I can't reverse engineer schemata.
Can someone let me know if this should be possible, or if I should rather use a tool like Kettle
I'm on Windows2008r2

Suppose I have two node teradata setup  having two different IP each assigned to a node.
Then from COP entries perspective I can have like below in etc host file on server.... TDXXXXCOP1 TDXXXXCOP2
This will help TTU to hit TDTDXXXX  from local server.

I have an ASP.NET MVC3 application that uses integrated security.  I have both the driver and the Teradata.Client.Provider.dll and the Teradata.Net.Security.Tdgss.dll in my bin directory.  I am unable to connect to the TeraData database. 
[Teradata Database] [8017] The UserId, Password or Account is invalid.

I need to do a connection to Oracle (Version 11g) using ODBC, from a OS Linux Suse 11 64Bits. Do you know, what the driver version is?
Thank you! 

I have downloaded TTU14.10 but i dont see any installable componnets for Teradata library(ICU) and teradata connector(PIOM).
also i am facing issue while installing some package
when i opened tar file i got  following fodlers which had rpms

Unable to connect to Teradata Database.
Getting below error while pinging on Teradata Studio Express.
IPs ahve been added to hosts file also.
Request to provide resolution as soon as possible.

Hello everybody,
I need to configure LDAP Authorization using the native directory schema. 
I already configured LDAP Authentication using simple binds and an Identity Search (since I needed to look for the sAMAccountName in the Active Directory).

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Mon Nov 25 00:48:26 COT 2013 socket orig=testServer cid=3dc01d78 sess=0 java.net.UnknownHostException: testServer   at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)   at java.net.I

Hi All,
Need your expertise in connectivity. I need to connect Mainframe DB2 on Z/OS to Teradata Client V13.10
Can anyone please guide me on what steps are to be taken for this ?
Thanks for your help.

Can somebody tried or did any poc to connect from Teradata to Haddop or Hana
Do we have any Teradata connectors available where can use. Want to use Bi -Directional either way
Ravi Shanker Ayyadevara

       Is it possible to stream data from a DB2 table to Teradata table using a Unix script ? Can this be done using CONSUMER/PRODUCER operators and not ODBC operators ?

Hi Team,
I need information on below points , we are looking to pull data from SAP ECC system into teradata:

If I have 500 GB of data to be tptied to TD, how much shared memory from the client system, should I allocate?
Thanks and regards,

I have succesfully set up an Access front-end that links tables from a Teradata database.  Everything works fine when I have the tables linked through a DSN.  I am trying to set up a DSN-less connection, but I am encountering the following error:  "Reserved Error (-7778): there is no message for this error"

I'm generally more of a forum lurker, but every once in a while I get something working that doesn't readily work out of the box the way you'd expect and feel that its worth posting about to ease the path of others (and maybe leave a trail for Google to scan so I don't have to remember where I left my notes!)

the teradata driver requires libicudatatd however the files included in the driver, TeraGSS and tdodbc, don't include that file,
do you know where to find this file?

Has anybody tried extending the Enterprise Libraray Data Access Application Block so that it works with the Teradata .Net Provider?
To get things up and running, my prototype extends the abstract Database class and passes TdFactory as a constructor argument..  

Hi all,
I'm importing data from Teradata database into MS Access database (Windows 7) using an ODBC driver. The decimal symbol is set to '.' (because the 'Use Regional Settings for Decimal Symbol' is unchecked in the ODBC driver options). The decimal symbol is different in OS (',') thus the import of decimal values is not correct.

I tried configure Teradata SQL Assistant, but said next error with tittle "Logon failed":
ODBC IM014: The DSN specified architecture mismatch between the driver and the application.
teradata version: 12
windows 7 64 bit
please help me thank you so much

Dear friends, my connection not working, please help me.
OS: windows 7 professional 64 bit
Teradata SQL assistant version: 12
ODBC Controller:
Name: Teradata  | Version: | organization: NCR Corporation, Daytin OH |file: TDATA32.DLL | date: 01-06-2007 (2007-06-01)
thank you,

When using a Java Stored Procedure from within the Oracle 11g database, an attempt to open a connection to Teradata using the JDBC driver version 14 throws the following error.
Exception in thread "Root Thread" java.lang.NullPointerException

Is there a 64 bit version of the OLE DB Teradata Provider? If so where can I get it?

We are having an issue with users attempting to logon to the system using LDAP authentication.
They are able to logon using a set password with no mechanism chosen.
Any suggestions regarding resolution?

I use Hibernate to read and load data into a database Terdadata.
I have large files (xml) to be stored in a table. For that I use a BLOB field.
I did not encounter any problem to store files via BTEQ, but when I go through hibernate, I get the following error :

HI Team,
Here is the log file for connectivity through JDBC application from Application server to TD server on linux.

Noticed this error:
Caused By: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC] [Error 1382] [SQLState HY000] The batch is empty.

Can anyone advise if an F5 load balancer should be used over a DNS, each configured with all Teradata COP's.  We have a 2650 Appliance running TD 13.10 with 15 nodes, 10 of which are Network connected.

Hi guys

I'm accessing Teradata through a python based web application, using pyodbc.  I get the error [Teradata][ODBC Teradata Driver] Beyond SQL_ACTIVE_STATEMENTS limit'

The project I am working has a java front end and it connects to TD.
Now they claims that when they were using mysql or oracle and if the connection with DB goes down , Java automatically connects to the DB when its up.
But in TD they are forced to restart the Java application to establish the connection with Teradata again.

The password for my user id is L4sQ&dS8.
I did the following :
Ran a bteq as .logon prod/subrata_das_admin,L4sQ&dS8;  ---> This worked fine
when  ran a MLOAD as below it failed with error -->  13:55:53 UTY1008 RDBMS failure: 8017, The UserId, Password or Account is invalid.   

We are using JDBC Driver for our connectivity to Teradata 13.10 version. What we are observing is that for every INSERT statement into a table in TeraData the logs show multiple SELECT .... FROM DBC.TABLES, ... DBC.COLUMNS and HELP statements.

Hi, I'm migrating from Cognos 8.4 in Win2003 to Cognos 10 in Red Hat 5.5 64 Bits.
In ODBC for Win2003 i have these setting :

I've installed ODBC Driver 14.10 on zLinux. While trying to test my installation using 'tdxodbc' shipped in 'bin' directory, I got the following error. Is there any hint about why this could happen?

Hi, I'm trying to install Teradata on a Linux machine, which is using a Debian Distribution. How can i setup Teradata on this machine and use BTEQ in order to execute some queries on a TD database?

Is the Teradata .NET Provider more efficient (faster) than connecting to the database via ODBC? This may be a silly question, but can Informatica use the Teradata .NET provider?
Todd Thompson
Habitat For Humanity

I'm having trouble with the configuration of TPT 14 on an AIX 64 bit server and Informatica 9.1.0 64 bit.

While trying to set-up Oracle Transparent Gateway on redhat Linux 6.4(64 bit system), we are getting the following error.
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [DataDirect][ODBC lib] Specified driver could not be loaded {IM003} ORA-02063: preceding 2 lines from TERADATA

I am getting below Error .
Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (IES 10901) (WIS 10901)Database error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (IES 10901) (WIS 10901)

Can someone provide the ICU Library  I need to uninstall it but it won't unless it has the orginal tdicu.msi.  The closest one available for download is icu but it doesn't work.