100 - 150 of 904 tags for Connectivity

Hi all,
I installed Teradata express 13.0 (not vmware) on Win7.
I run TD Service Control - it ends up as: "PDE state is RUN/READY".
I executed sysinit and after restart my configuration is 2 AMPs and 1 PE, all are Online:
(under vprocmanager: STATUS NOTONLINE

All DBS vprocs are fully online.

I am trying to run my query after my linked table in Access 2007 is done and all is fine. I get an ODBC call failed periodically. It normally happens during business hours. On the weekends, early morning, it is fine. Others on my team sometimes get it and sometimes they don't.

Hello,
I am trying to query some Teradata data in SQL Server. When doing so, I get an error, "Cannot find either column "XDate" or the user-defined function or aggregate "XDate.ToString", or the name is ambiguous.

Hi,
We are evaluating options to Extract/insert large volume of data (Millions of rows) from Teradata and process within a Java application.

Hi Experts ,
Is it possible to send multiple rows ( a table ) from .net environment to teradata environment .
I think it should be possible but as I am completely at DB side I have no idea of connections and .NET to teradata bridge .
Kindly help . Thanks in advance .

I got the TD 15 installed using '

Teradata Tools and Utilities - Windows Installation Package'
But i am getting the below error while connecting to SQL Assistant
'Unknown Error Occured in Terasso Libarary'
Kindly Advice.
Regards
Sreehari

Hi Guys,
 
I am strugling to connnect teradata usning python. I have a user ID and password in text file and i need to read the test file to connect to teradata.. could you please help me with theb syntax if anyone has already done this

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 13.00.00.07 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 14.00.05.03 server using Teradata ODBC Driver 15.00.00.01

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?

Hello,
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

Hi,
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.
 
Regards,
Manoj 
 
 

I am creating SSIS Package with Teradata OLEDB provider for teradata 14.00.0.1.
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.

Hi,
 
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:

Hi,
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
.logon 127.0.0.1/DBC,DBC;
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 
(
"ID_1","COL_1","COL_2"
)
SELECT 
    last_key_1,
    (
    CASE

Context:
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.

Hello,
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...

 

Hi,

 

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...
 

Hi,
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:

Hi,
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 :

Hi,
I downloaded the .net Data Provider for Teradata 14.11 from this link: 
http://downloads.teradata.com/download/connectivity/net-data-provider-for-teradata
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. 14.11.0.1) 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");
 

Hi,
 
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:
https://downloads.teradata.com/download/connectivity/odbc-driver/windows
 
 
 
 
 

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?

Hi,
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