100 - 150 of 897 tags for Connectivity

Hi guys.
I have some troubles with ODBC driver. I'm facing error HY092 Invalid attribute when try to run SQLPrepare function.
My connection sting to Teradata: DRIVER={Teradata};DBCName=192.***;uid="dbc";pwd=********;QUIETMODE=YES;LoginTimeout=210;UseNativeLOBSupport=Yes;NoScan=Yes;

I have the following unit test which is failing due to a TdException with the message "[Teradata Database] [2689] Field is null for column defined as NOT NULL."

I am attempting to execute a parametrized non-query SQL command using TdCommand.ExecuteNonQuery().  The parameter in question is DbType.DateTimeOffset and TdType.TimestampWithZone; the parameter value was generated using DateTime.Now and appears to be completely defined (as verified via the Visual Studio debugger).

I am using Teradata jdbc driver to connect to Teradata data base from my java application. Couple of days back I got the following issue 'TeraResultSet:getTimestamp function failed'.

I'm using VBA and the Microsoft ActiveX Data Objects 2.6 Library to access our Teradata server using Teradata ODBC Driver

I'm looking at the Teradata Appliance for SAS High Performance Analytics, which I see is connected directly to the BYNET. Is it possible to connect other non-Teradata servers to the BYNET for connectivity, or is this specific to Teradata appliances?

I have a simple unit test which is failing the final assertion:

I am getting error when trying to use vba code to connect teradata sql through excel 2010. I also want to execute records to excel. Can someone help me with the query for the same

I am currently using Datastage v9.1 and would like to know if I can use Teradata Connector to connect Teradata Aster.
If not do we have any alternate db connectors/stages to connect to Aster. Also please let me know the configuration details that I have to setup before connecting to Aster db.

I'm a bit of a novice in this arena, so I hope this doesn't seem like an odd question

Hi All,
I am facing an issue with reconnect in .NET and ODBC connectors from SQLA when i do a DBS restart. I am seeing this in TD Expres 15.0 SLES 10 40GB  VM.
Teradata .NET Data Provider :
Issue here is that after a successful DBS restart, SQLA is not maintaining the current session context.

Hi Folks,
Recently i started my carrier in teradata, i would like to install teredata in my personel lap tap while selecting datasource i am getting 10061 WSA EConnRefused error. Could you please provide the solution for this issue.

I am creating SSIS Package with Teradata OLEDB provider for teradata
my table has column with datatype "Character Large Object". When I try to use this table in my SSIS, it throws following error:
 Exception from HRESULT: 0xC0202009

I was hoping to use the TD-GeoImport tool to get some data into Teradata, but alas I have a 64 bit machine.  I should have read the "32 bit" in the label first, before getting this error:
Can't load IA 32-bit .dll on a AMD 64-bit platform
Any plans to release this tool for 64 bit machines ?

I have installed teradata express 14.10 edition in vmware player. I can logon using dbc/dbc and also can access it using Teradata express studio from windows 7. I have downloaded Informatica from https://edelivery.oracle.com on  windows 7.

I am trying to export data from hdfs to teradata using teradata connector cli version 1.3. I am contsantly hit with below error while executing in batchinsert mode. 

I'm trying to use TDCH 1.3 command line edition to import from TD to HCatalog.  I consistently get an exception.  I've tried various versions of Hive and HCatalog with no success: CDH4.5 with Hive 0.11, CDH5.0 with Hive 0.12, and HDP 2.1 with Hive 0.13.  All throw the same exception.
Here is my job setup:

I am new to Teradata.
Please help me to know how to execute the simple Teradata script from LINUX shell script.
I created  a shell file Sample.sh and the code inside the shell file is below:
#! /bin/bash
select * from employee where emp_id = $1;

Is there a way to redirect where the error tables are created in a JDBC Fastload operation?
My scenario is loading a staging table in a schema/database where the ID doing the load does not have CREATE TABLE privs. As per company standards the error tables are typically created in a separate database.

Hello all,

Hi guys,
I have a problem with TIME datatype and my ODBC drivers.
In ODBC driver I have DateTimeFormat=III and enabled DisableParsing.
When I try to run this query:
INSERT INTO  aidar.time_ansi 

teradata 14.
loading utf-8 messages via jdbc connectivity
when messages containing the � replacement char for untranslatable character
with our DBS Control param 104 (AcceptReplacementCharacters) set to false
jdbc returns error 1338, 1339.

We want to connect MicroStrategy and Teradata on a Red Hat (64-bit v6 Santiago) Linux machine but we are facing architecture version issue while doing so.

Hi, I currently have a connection from SQLServer 2008R2 integration services to Teradata v13. The version of Teradata is due to be upgraded to v14.10 soon, and I am trying to confirm if my connection from SQL Server will be affected or not.

Hi all,
I have to insert more than 70 milions register from a .csv to a Teradata Destination via SSIS. After insert 2 milions of data, an error appear:
[Teradata Destination [133]] Erro: TPT Import failed to insert row. No record of the last request was found after DBC restart
I use Fast Load feature...




I'm not sure what the "Generic Download License" really means. Is it possible to use the downloaded software for production if we have valid license for Teradata RDBMS?

e.g. use downloaded ODBC driver 14.x while we only have license for TTU 13.x.



Do teradata provide XA supported driver. I have using multiple DB in my Java Application and I want to govern all the Queries under one transaction. For that I need global transaction like JTA etc.. But all these global transaction needs XA supported Teradata driver. 
Kindly provide details if we support such driver.

UserName = "user1"
userpwd = "passw1"

Recently changed from 12 to 14, a macro we had to auto connect to Teradata that worked fine with 12 now gives the error [Teradata][ODBC Teradata Driver] Not enough information to log on.
Is there something that needs to be modified?  VBA code is below, with comment on where error is occuring...

I am getting an error message “A dynamic link library (DLL) initialization routine failed.” when I try to access Teradata database from within my ETL tool, SQL Server Integration Services (SSIS) 2008 package.
A bit more detail on the error description:

I new with Teradata and I will try to connect TD DB with JDBC. When I try a specific request I get an SQLException with the message :

I downloaded the .net Data Provider for Teradata 14.11 from this link: 
and installed it on my machine using the installation program.

Is this possible? I see in the FastLoadCSV docs that you can specify other field separators besides comma.

I am trying to use the Teradata .Net connector (v. to establish a connection between my c# Windows application and a Teradata DBMS. I am not using the ODBC connector so there is no DSN associated with the connection.

Hi Team,
I am getting following exception while calling setSavePoint of Connection interface. 
SavePoint currentSavepoint = connection.setSavepoint("BatchSavePoint");

I'm new to Hadoop. I'm trying to load tables from Teradata to Hive using Cloudera connector powered by Teradata.

Where is the download link for the latest Teradata ODBC Driver 14.10?   You'd think it would be here:

Is it possible to access Teradata from JavaScript/jQuery?
If it is possible, is there some example about how to connect to Teradata, send a Query, get a dataset back?
Peter Schwennesen

Extract Beginning for BigComp Extract
Begin date is: 2014/03/01 End date is: 2014/03/31
Exception on Teradata Open for: bigdw.bigcompany.com myuid LDAP Message
is: Teradata.Client.Provider.TdException (0x80004005): [.NET Data Provider for
Teradata] [100038] Command did not complete within the time specified (timeout).

Hi All,
I am new to Teradata. I have knowledge on Oracle. Recently I installed Teradata 13 version on my lap through VM. I completely installed Teradata tools and utilities. Now I am not able to connect to Teradata through SQL Assistant. While I tried to connect it's showing Error. Below the error log:

5/4/2014 2:51:46 PM

Hi All,
I'm a newbie so please forgive my silly questions. I really appreciate any assistance.
1. What is the TDPID and can it be changed for different interfaces such as one for the 1GB interface and another for the 10GB interface on a Teradata server?

Does anyone know how to connect to a DB View with OData service in Visual Studio?

I am using a Windows XP machine and eclipse Kepler. While trying to connect to teradata i am getting : 'Invalid LAN Message Header, read 0 bytes' error..Error Code : 1000, SQL State: 08S01. Please help me to resolve this

Hi All,
I am using teradata-connector-1.2.1 with the following versions:
->Teradata 14.0
->HDP 2.0(Hadoop
->Hive 0.11

I am trying to import data from teradata tables to Hive.
/*Created table and inserted a row in teradata*/

I have installed the .Net Data Provider (http://downloads.teradata.com/download/connectivity/net-data-provider-for-teradata) on 2 computers, as an Administrator. I tried 3 versions of VS - VS2013 Pro, VS2013 WD Express, VS2010 WD Express.
I found one tutorial, so I know that what Im trying to achieve should be possible :)

I'm hoping someone can help with this DBI error.  I have installed the perl DBD::ODBC driver into a custom directory and everything works fine when the scripts get kicked off via the command line.  At the top of each perl script I add the 'use lib pathto dbd::odbc'.  However when running in crontab the connect is having an issue.

Hello all,
When attempting to connect to Teradata 14.10, I am receiving the following error message:
Warning: RDBMS Crashed or Sessions reset. Recovery in Progress
After ctrl-c'ing a coupe of times, I get sent back to the BASH prompt.

As we know, we have facility to replace NULL values with anystring we want, in Teradata SQL Assistant.
The problem with me is I am fetching the data in a recordset in VBA from MS Excel. In this recordset I am not able to differentiate between NULL and Blank values.

have .net installed successfully. Can connect just fine , but when setting up a connection in SSIS is will not popluate the table/view list dropdown box.
I do have use x views set to false and no deafault database, so not sure why it would not pull data dictionary info

Hi, I am trying to execute a stored procedure from Visual Studio 2012 using the .Net drivers. I am connecting thru LDAP, the character set is UTF8, session mode is ANSI.
In Teradata studio, after running
help procedure xxx.xxxx attributes;