350 - 400 of 952 tags for Connectivity

Hi All,
I have installed Teradata 13.10 and i m using .NET data provider for connection. I am getting connection time out error when connecting database, though i m having access to the database.
11/04/2013 19:42:10
SQLA Version:

I am new to the forum so forgive me if this post seems remedial or incomplete.  We work with data coming from two types of data sources (MS SQL Severs, and Teradata Servers).  For a number of projects, we need to compare information across these two server types.  There are probably a number of ways to accomplish this but we are looking for an approach th

I am working on a Narrow Cast Server project in Microstrategy; teradata is the database. We have configured an ODBC connection to connect the NCS to teradata.
I get an ODBC error while trying to execute a multi pass sql using the ODBC connection. However, a simple query runs fine.  

Hi I installed the latest version of the .Net driver (14.10).
I have both VS 2010 and VS 2012 installed.
In VS 2010 the Server Explorer shows the .Net provider for Teradata but VS 2012 does not.
I was expecting the latest version to work with the Visual Studio 2012.
Can someone please clarify.

Hello. I'm working with some .NET code at the moment that performs the following operations:

I launched a Teradata 14 express on Amazon ec2 following instructions here: http://developer.teradata.com/database/articles/teradata-express-14-0-for-ec2-config-guide
When I try to connect through JDBC from an app, I get the following error. (This used to work fine with another instance last week.)

I have problem connectivity from data stage to Teradata database.
The error is "The connector could not establish connection to Teradata Server prdtdcop1. RDBMS Code 224MTDP : EM_NOHOST(224) ... "

Hi there,

Hi there,
I am still looking for a kind a compatibility table between Jdbc driver version level and Instance version level.
I would reckon jdbc drivers are not expected to be upward compatible (ie: using V12 versus instance level V14) and that it would be recommended to align Jdbc version level to Instance version level.

We have an application which connects to Oracle before, now our database migrated to teradata, so need to connect. 
Here is what we use for oracle, 
Data Source=;User ID=;Password=;Provider=OraOLEDB.Oracle.1;Persist Security Info=True;

Hi there,
we upgraded from jdbc  12 to 13 (also made some tests with a jdbc 14) and we consistently get this error message
[TeraJDBC] [Error 1382] [SQLState HY000] The batch is empty
though for sure the select member executed on another jdbc connection/techno is returning rows.

I have strange problem. Consider below Teradata Stored Procedure:

How can we connect Aster and Teradata. 
Using load_from_teradata and load_to_teradata cammands, how are the 2 databases getting connect?
And what is Aster-Teradata adaptor? Is it a physical device or some driver that i can download or  what exactly is it and does  does it work?

my app connects to Teradata DB via JDBC driver. When I try to update a row of a ResultSet (the ResultSet is CONCUR_UPDATABLE), I get the following error:
com.teradata.jdbc.jdbc 4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC] [Error 858] [SQLState 07004] No value has been set for parameter 3

Hi there. My organisation is just beginning with Teradata development, and I'm wondering which connectivity option (.NET Provider, ODBC etc) we should use. We develop against version 4 of the .NET framework using Visual Studio 2010 and 2012. Could anyone recommend one connectivity option over the others, or perhaps list the pros and cons of each?

Is there a way to tweak ODBC/Stata to work with volatile tables in Linux?
Stata (a statistics package) allows SQL statements to be issued directly to ODBC data source. I believe SAS has similar pass-thorugh functionality. There's some description of this here: http://www.stata.com/help.cgi?odbc

Since past one month, we are getting the error below in some of our informatica sessions during the daily load.
 013-02-22 02:11:10 : ERROR : (15655 | PRE-SESS) : (IS | IS_NAME) : node01_abc.com : CMN_1022 : Database driver error...
CMN_1022 [

Dear All
I have recently moved from Windows to Mac and am trying to get used to the change. At the same time I am new to Teradata and want to learn it. I have installed Teradata Studio on Mac but I am unable to create a database connection and database to start working on it. 

I have installed Datastage with fix pack 3, and TTU 12 with TPT 12, and teradata connector return following:
Teradata_Connector_5: Error loading connector library libcctera12.so. 0509-022 Cannot load module /ds_sw/IBM/InformationServer/Server/DSComponents/bin/libcctera12.so.



Hi, I am trying to understand what is Teradata_ICULibraries_D and purpose of it.


I would really appriciate If someone could provide me littlr information or point me to the right documentation.


I cannot find a single webpage on google or teradata website regarding this.


When I try and do an import into hadoop using the JDBC driver I recieve error 857 - Two different data types are being set for parameter 42
The data type in the file aligns with the data type in the TD table. Anyone know anything else I should check or try?
JDBC version is 14

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. 

How to, is possible?

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

I'm trying to connect using Teradata's OLE DB provider and most of the time the connection works, but occasionally it returns an error with two messages:
[OLE DB Provider for Teradata] Not enough information to log on
[OLE DB Provider for Teradata] Login timeout expired


I am trying to set up a connection in SSIS 2012 and get i the following error. 


Test connection failed because of an error in initializing provider. The 'TDOLEDB.1' provider is not registered on the local machine.



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

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

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 :       localhost localtdcop1       localhost tdadmincop1

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:

I can establish the connection just fine.... 
My connection statement:

jdbcCon <- dbConnect(drv = JDBC("com.teradata.jdbc.TeraDriver"),user = UID, password = PWD, 

paste("jdbc:teradata://",DSN,"/database=",DataBase, ",TMODE=TERA,CHARSET=UTF8", sep = ""))

I'm new to Teradata and Websphere Application Server(WAS). I have installed Teradata JDBC Driver 14.00 (terajdbc4.jar

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.


R fails to connect to teradata using RODBC.
Installed required packages/drivers on OS in ksh (pdksh)

R v2.15.1

RedHat Enterprise Linux 6




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




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






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:

We are getting this error when we are the doing inserts/updates from multiple threads. Has anyone seen this error before and what could be the problem. Below is the stack trace. Any pointers appreciated.
java.lang.Thread.State: RUNNABLE
        at java.net.SocketInputStream.socketRead0(Native Method)

Dear All,
    I need to connect to TD by ODBC. But It didn't work after I installed ODBC and configured it. The detail message is as below:
TD Server Version:13.10
Client OS:Red Hat 

[dsadm1@localhost example]$ uname -a

Whenever I try to export my dataset from SQLA into an MS Access 2007 table I get the following error:
SQLA Version:
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?

I am getting a weird exception which I have no clue how to fix it. My scenario is:
When I execute following parameterized query using java hibernate(via jdbc driver) everything works great:
StringBuffer hqlStringBuffer = new StringBuffer("from student where name like :Name and class=:Class and section:Section");

I got following error in my application(Web app deploying on JBoss EAP).
It seems exception generated at "CheckValidConnectionSQL.isValidConnection", when JDBC Driver try to check validity of connection.
I checked the JDBC User guide and SET LOB_SUPPORT to OFF, but still getting the same error.
Any advice?

My database is a Teradata version
I retrieve data with a MS Excel v2003 file (using MS Query)
Before to do that, I installed "the tdodbc__windows_i386." products on my desktop : Teradata Client 13.10, Teradata ODBC driver. I created a System DSN etc.

Hi Guys. I am trying to execute 'show procedure ' using Perl DBI, but always getting wrong result. The same code with 'show view' works correctly. Does anybody help me?

I runtime combined 4 create table commands into a string. However, when i run this string as below in C#,