350 - 400 of 1026 tags for Connectivity

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.

Hello everyone - I have the Oracle 11g client and components installed but the Oracle OleDB Provider will not show up in the list of options in the OleLoad tool.  I have manually registered the oraoledbb11.dll file and complete the installation multiple times.  Has anyone ever used the Oracle OleDB provider before?

I am trying to connect to Teradata ( from a Java application (Rational Software Architect). I have tried with both the version 14 and 13 JDBC drivers from the below site but still no luck.

Iam newbie to Teradata. I downloaded and installed Teradata Express database 13.0 (default setup) on my windows xp pro sp3 successfully.
Here I am little bit confusing what are the username/password to connect in SQL Assistant. How to connect samples in SQL Assistant.?

I have some problems accessing Teradata from EXCEL with a ODBC driver.
The Teradata database BASE_A, has user access restriction set on the base itself.
Here I can setup the ODBC driver so that I get access to BASE_A from Excel.

I'm trying to write VBA code that will allow me to run a macro in Microsoft Excel 2007 that connects to Teradata SQL assistant (version 13.10), runs SQL (it says ODBC, if that is meaningful), and brings back the results to Excel.

I am trying to install teradata 13.10 on RHEL6 server. We have RHEL 6.1 with UnixODBC-2.2.14-12.el6_3.x86_64. Drivers were downloaded from teradata website and were installed in following sequence :
1. TeraGSS
2. tdicu
3. tdodbc
ODBC.INI configured and env variable was pointed to the location. 

After installation  of Teradata client 14.00 for Oracle GW and configure the environment I've got an error
ERROR at line 1:
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 HSTERADATA

Hi all, please, help me. I can not connect in Teradata 13 database from visual studio 2012.\
My code:


Hi, I have had a search through the forums (and google) and have found plenty of discussions about teradata ODBC drivers, but none that seem to quite match the issue I am seeing....

Hello. I need to have the aster ncluster odbc driver installed on my computer. I follow the directions provided -- but when I get to Admin Tools ==> data tools (odbc) ==> system dsn (add)... the driver does not appear in the window. Any direction or guidance is appreciated.

We are seeeing connection timeout problems via teradata java driver v13.10. We tried to set the connection keep alive from the connection pool manager, still no luck. we still the socket failure excrption. Any pointers what could be done to get around this issue? Any solution ASAP would really help.

ERROR org.hib

Trying to install the teradata odbc drivers for Red Hat, but the downloaded RPM complains about dependencies (tdicu/teragss), which I cannot find anywhere for download. 
My employer has the necessary licenses. I asked support, but all they said was to ask here... *roll* 

I tried to connect to my Teradata server through C# (VS 2012 Express). But I kept getting error. I used MSSQL before. This is my first time using Teradata. I tried a few connectioin strings, but it did not help.
My OS is Windows 7 SP1 (64-bit). I have Teradata SQL Assistant ( installed and connect to Teradata through ODBC.

Developing job using Spring batch module, new jobs requirement is to write data to TeraData. Can anyone share user guide or tech spec on how to support from Spring Batch with Teradata.

Have freshly loaded Terdata Express 14 on a Macbook Pro using VMware Fusion 5.  The bteq utility is working and can connect.  The Teradata Studio Express is able to connect.  However, when I start firefox I get the following error:

Unable to connect


Firefox can't establish a connection to the server at localhost/

Hello !
I create this case because I have a question relative to the access to Teradata through SQL Assistant and BTEQ.
The situation here is the following :
- I have two users USER 1 and USER 2
- With USER 1, from my workstation, I can connect to the Teradata server either by using SQL Assistant or BTEQ

I have looked at the new Studio 14.02, but it seems that it has only the Teradata connection. Is it not possible to select an ODBC connection like in the Teradata SQL Assistant? How do I select a ODBC connection? I like to select a ODBC connection that I have setup in the Control panel … Data sources (ODBC) … System-DSN.
Peter Schwennesen

Hello ,
We have a java program that connects to Teradata using the ODBC Drivers and uses Global Temprory Tables for retrieving data for a Report
The Global Temprory Tables have been created with a preserve rows after commit option
here are the steps in the program

Alright. So I looked at this page: http://developer.teradata.com/doc/connectivity/tdnetdp/14.10/webhelp/EntityProviderCanonicalFunctions.html. It mentions that canonical functions for .NET 4.0 are supported under the "Teradata" namespace. Where in the world is this namespace?

I am trying to add Teradata in vs 2010. Can anyone please help me?

Hi Every one , I'm a new seed in the teradata & interested very much in it .Hence I Installed Teradata Studio Express Version:  and JDK and trying to create and connect new data Base and getting the below Error : 
Could not connect to localhost.

Hi ...i have installed Teradata SQL assistant 13.10 , but i couldn't able to connect because it is asking me username and password and also ip address...can you please help me what i should give here for username, password and ip address

I just installed Teradata Express 13 VMWare instance. Everything installed and works fine, except I am unable to connect to the dbc database via a Teradata 13 JDBC driver. The URL supplied is:  "jdbc:teradata://localhost/DBS_PORT=1025,DATABASE=dbc,CHARSET=UTF8".
Please advise?
Thanks... Vince

Hi, I am able to create the cubes using the TDOLEDB provider in Analysis Service and only come across the following error when processing the cubes. "The provider 'TDOLEDB.1' is not registered."

I am running the following configurations

- Windows 7

- Database: Teradata on VMware

Asterdata extension framework mentions about installing ado.net drivers and they mention referencing nClusterDNProvider.dll file for the provider...however after finishing the install I dont see the file anywhere...  teh document doesnot mention any location adn searching my computer yields no result...

Has anyone had any luck installing the TeraData JDBC drivers on WebLogic 12c?  Are Teradata JDBC drivers supported in WebLogic 12c?

Is there a list of error codes (and the associated messages) of all the SQLExceptions that the Teradata JDBC driver throws? I can't find it anywhere in the documentation...

Hi All,

I have installed Teradata ODBC driver version "" and unixODBC-2.3.1 on SunOS and able to execute the queries from isql but unable to fetch the data using dblink.


From dg4odbc trace file I am finding the below message,

hgopoer, line 231: got native error 0 and sqlstate IM001; message follows...

We are using Teradata database 12 as our production database and as part of policy we are required to see if we can upgrade JRE to 1.7
I have seen prior posts for Teradata database compatibility metrics with JDBC but couldn’t see Teradata database compatibility with JRE or JDK versions.

i am trying to connect to Teradata using JDBC from my Linux server using Pentaho and i get the following error.
can you please help
GSSException: Failure unspecified at GSS-API level (Mechanism level: UserFile parameter null)
        at com.teradata.tdgss.jtdgss.TdgssParseXml.<init>(Unknown Source)

Hi All,
After creating a connection using the Teradata .Net Provider, how to know what is the session id/number of the session/connection created ?
Thank You.

Hi all,
when i tried a normal connection in script shell like point 1 no errors occurs.
when i add .logmech string (point 2) for mechanism LDAP the connection failure and errors occurs(see point 3 for spool).
bteq <<EOI
         .LOGON server/emyuser,mypwd;
Select date;

I apologize if this is a repeat topic, I tried to search through the forums here and found nothing useful about this topic.

Where can I download a .NET Data Provider instead of version, Thank you.

Hello I issued the following command on the Teradata Express Suse VM to test my ODBC setup, I have installed unixODBC and Teradata 64 bits drivers:
TDExpress14.0_Sles10:~ # isql -v testdsn vmtest vmtest
| Connected!                            |

I received this error when i run the query on my app, but when i run the same query on teradata studio, it run fine. Why???
I use jdbc driver for run this query.