350 - 400 of 820 tags for Connectivity

I am trying to call Stored Procedure with parameters. Procedure have two TIMESTAMP parameters for example use below one:

Hello folks,

                I am new to Teradata , and was hoping to connect to the Teradata DB using the .net provider.

However I am unable to connect. I am getting a invalid connection string error.

 

I was wondering if you have to follow certain steps to connect using the .net provider ?

 

Hi all;

We're now adding OLAP support to our reporting system and I want to make sure we handle Sql Server, Oracle, & Teradata out of the box. Where can I get information on how to access Teradata from both .net and Java?
 
thanks - dave
 

Hi all,

 

i am trying to load data in my database using informatica but getting the error that is placed below:

 

 Execute Direct -- [Teradata][ODBC Teradata Driver][Teradata Database] An owner referenced by user does not have INSERT WITH GRANT OPTION access to BATABASE_NAME.TABLE_NAME.ID.Unable to get catalog string.

Hello everyone!

We are in the process of upgrading our warehouse from v12 to v13.10.  Our first task is to roll out the ODBC to various users to see if things are still happy. 

Would it be possible for the next release for JMSUC to NOT hardcode the Metadata Tables DDLs and names ? I found it quite inconvenient to integrate in an existing EDW infrastructure, which follows strict naming conventions and database objects structure...

Our users have been receiving the [8017] The UserID, Password or Account is invalid error more frequently lately.  Normally, I can reset the password and they are fine.

Im able to connect to teradata DB through SQL assistant with required credentials

But unable to connect to teradata through .Net ODBC

The connection string that i used is

driver={Teradata};DBCName=provided Server address; UID=*****;PWD=*****;

 

Pls let me know if anything is needed

Hi,

I am having issues installing Teradata SQL assistant on my work laptop. We have Teradata 13.10 installation package and my system has Windows XP 2002.

None of my colleagues are able to help on this issue. So, I am posting it here.

Hey Guys...

I am connecting excel to teradata through ADODB connection and getting the results in the recordset.

The thing is, I have a slew of SQL's to be run around (10-15) which need not be sequentially. Using the below method, I am able to run each SQL query one after the other,

How can a connection to a Teradata database be implemented as a PowerShell script using ODBC, .Net Data Provider, or other protocol.

I am trying to configure the Teradata sql assistant to view the SAS datasets. Whether it is possible to view SAS datasets in Teradata sql assistant. Please let me know.

Hi,

New sign-up, so apologies if this is not in the correct forum!!!

We have just upgraded to 13 from 12 and I have noticed a small anomaly which I was wondering if anyone else has encountered.

I have .Net framework 4.0 installed.

where do we get TD .Net data provider for 4.0 version? I don't want to downgrade my app to 3.5 or less from 4.0.

Hi,

I am new to using Teradata and am trying to use it with vb.net to build a user app.

Can anyone please tell me how to call a teradata sp from vb.net (Visual Studio 2005)

I have a simple sp with input and output parameters, something like:

Does CLIv2 allow you to abort a request (using function DBFABT) using a session that is different than the one used to submit the request? Although the two sessions will be running in a separate thread or process, I'm assuming the session performing the abort has access to the relevant session id and request id.

Have had success establishing and using SQL Server linked server (SQL Server 2008 R2) connected to Teradata using OLE DB Provider for Teradata (Version 13.10.0.1) using native Teradata (TD2) authentication.
 
Our Teradata data source will transition to use LDAP authentication, so we must adapt our linked server for this new authentication method. (To prepare for that transition and to conduct tests, we’re provided access to a Teradata database that requires LDAP authentication.)
 

Hi all,

I have a problem connecting to Suse VMware image for Teradata database. It works OK at work place. But at home, when I am on VPN, I can't access the database from the Windows 7 host. Does anybody have any ideas as to how to solve this?

Thanks

Sreenath

 

 

Hi,

We need to install teradata libraries on UNIX server (AIX-6.1).

The version of Teradata is TTU12.

Please let us know the steps for the same.

 

Thanks,

Jatin

hi

 

I am using Teradata jdbc driver 13.00.00.10, and trying to upload a flat file with 100 million rows to teradata.

I start off with a clean table.

First I tried to iterate through the entire file, do addBatch() for each of the rows, and only in the end do a single executeBatch():

I am unable to connect using the following snippet of code:

drv = JDBC("com.teradata.jdbc.TeraDriver","./TeraJDBC/terajdbc4.jar")

conn = dbConnect(drv,"jdbc:teradata://db1/TMODE=ANSI,CHARSET=UTF8",user="user1",password="pswrd1",dbname="test_db")

I get the following error messages:

 

As a part of our Teradata evaluation effort, I have created a java ETL process which attempts to batch load data from an Oracle instance into a Teradata 13.10 Express VM instance.

Has anyone else seen this? Currently if I run up a connection via the JDBC driver under a 64bit JVM of 32bit JVM under a 64bit Ubuntu I get an unexpected hang. Under a 32bit JVM on a 32bit Ubuntu install everything works fine. The really weird thing is if I run the connection thread through strace it appears to be spinning never really connecting.

I've contacted many people within my company who use SAS, but I can't figure out how to resolve my issue and am running out of places to turn.

Background:

   Datastage8.1 install SUSE 10 64-bit

   Teradata install vm on SUSE 10 64-bit

In the DS server i install the TD ODBC driver. also used the ./adhoc can connect to the TD  and can execute the SQL command. but i don't know two the configuration the ODBC and the env on the DS server?

 

Accroding to the explanation of this error in the Messages document,

Hi Guys,

I have installed the teradata 13 client in my machine (Win XP). Whenever i run a query in SQLA  it gives the error msg

'object reference not set to an instance of object'

If any of u people encountered this error kindly help me out the solution ASAP    thanks

Using Sql server and connecting to Teradata 13.0 using 64 bit .net bring data FROM Teradata - everything is fine
When I try to do an Update to my table on Teradata - I have nothing that lets me specify the Database or Table I want to update - but I get a response saying everything completed successfully.

Hi,

I am using .NET Data Provider to connect from Microsoft Analysis Services (BI Studio 2008) to Teradata. In general that works fine and I connect to Teradata database systems.

But there is a specific Teradata system (Teradata 13.10) that I am unable to connect using .NET Data Provider.
I always get the following error message:

[TeraGSS Security Library] [115022] Exception occurred in TeraGSS layer. See inner exception for details.

I am using the following connection String:

If this isn't a true connectivity query, please forgive.

I've mounted the Teradata Express for VMware image and can access the evaluation DB from within VMWare Workstation.

I'm now attempting to connect to the Teradata database on the VM over my local network to query the DB with the .NET provider. Can someone point me in the right direction on how to connect to the VM database?

I am getting the following error trying to use this with DBI 1.6.16 on an AIX app node, using the Presicient 12.001 GPL driver:
'DBD::Teradata::st execute failed: Failure 7968: FD622_Determine_Date_Range_SP:The recipient of the result set does not support dynamic result sets.'

I am new to Teradata. I am using Hadoop Java map-reduce to connect to Teradata via JDBC. I am using the Teradata JDBC Driver 13. I am using Hadoop 20.2.

I am gettign the following stack trace.

11/08/08 14:51:42 INFO mapred.JobClient: Task Id : attempt_201106221259_0073_m_000010_0, Status : FAILED
java.io.IOException: com.teradata.jdbc.TeraDriver
at org.apache.hadoop.mapred.lib.db.DBOutputFormat.getRecordWriter(DBOutputFormat.java:162)
at org.apache.hadoop.mapred.MapTask$DirectMapOutputCollector.(MapTask.java:662)

Hi!, I'm trying to integrate Teradata with our Identity Management Solution. I would like to know the way for adding users via command line, SQL/JDBC query, API, and so on.

Best regards

What does the SQL request mean? Is the maximum allowed length configurable? Why still need the limitation in 64bit ODBC driver? Is there any workaround ?

Thanks

Good afternoon

In Datastage as ETL tool i can connect to differeny RDBS and checkup its configuration by means of .odbc.ini file

But checking out this file i can see entries for relevant information to acces the DB like Database, LogonI, Password just for only SQLSEVER database servers (Windowws Servers)
But for ORACLE Databases i just can see Driver information but no Database, LogonI, Password

Is there anywhere else can i get these relevant information to access oracle Databases?

This is an example for .odbc.ini

[SQLS_DesaTrafico]

Hi all,
I'm getting an error around names not being in the HOSTS file or names database when trying to connect to a Teradata system using BTEQ or SAS from Linux. This happens when I try to use the hostname vs. the IP address. Is the fix as simple as adding the IP address and host names to the /etc/hosts file on the Linux servers or is there a special hosts/names database file that BTEQ, etc. use to resolve hostnames? Also, just curious why is this necessary if we are using DNS and can ping the hostnames with no issues from the Linux servers?

Thanks!

SAS Error:

Good evening

Im a dummy about Teradata and i have a question
in an Production system there are a lot of process that extracts information from heterogenous and operational database system.

In Director Program i can see graphically which tables are accessing i.e odbc stage icon but cant see which connection is used, a sid datanase, user y password because the info is encrypted.

i've heard about Medatada engine and Metadata Services. the question is by means of teradata engine can i find out what i was lookjong for? if yes how.

Ok the setup is RHEL 5 with unixODBC 2.2.11 python 2.4 using pyodbc 2.1.5

I have followed the instructions located here:

http://cjgoldsmith.blogspot.com/2011/03/teradata-odbc-python-pyodbc-on-fedora.html

To try and get this working but with no luck. I can get sql server and mysql working and everything like that but just can't get teradata to work. I've tried downloading and using the 13.0 bundle and the 13.10 bundle linking the files and everything like that. When i look at the trace it looks like this:

[code]
ENTER SQLSetEnvAttr
SQLHENV 0x13a13830

Am trying to deploy the JMS Universal Connector to WLS 10.3.4.

I have tried finding out the 'How-To' documents related to deploying JDBC driver mentioned in the JMSUC Install Guide, no success...

When creating the Data Source with JNDI name jdbc/com.teradata.terajmsa.MetaDS, the connection test succeeds, however when trying to deploy the DS to any server, I get the following:
[Teradata Database] [TeraJDBC 13.10.00.18] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.

I need help on how to connect from SQL Server 2008R2 which is on my Windows 7 64-bit PC.
I tried linked server but not sure which provider to pick. Nothing on the provider dropdown has references to Teradata.
From looking at Control Panel, I think I have all the drivers needed.

During the connect, when I use cnewp.xxx.com in the Server field I get following error

SQLA Version: 13.10.0.2
Teradata.Client.Provider.TdException
[.NET Data Provider for Teradata] [115006] Could not resolve DataSource=cnewp to an IpAddress.
at Teradata.Client.Provider.WpTcpTransport.WpResolver.FirstLookup()
at Teradata.Client.Provider.WpTcpTransport.WpResolver.UnknownCopLookup()
at Teradata.Client.Provider.WpTcpTransport.WpResolver.GetHost()
at Teradata.Client.Provider.WpTcpTransport.Connect(Int32 timeout)

I am new to Teradata and was trying to setup something similar to sql loader to load delimited files into tables.

Below is the script i ran from my unix prompt.
tdload -c ASCII -j tdloadjobvars.txt

Below are the contents of my "tdloadjobvars.txt" file.

TargetLogonMech='ldap',
TargetLogonMechData='authcid=xxxx password=xxxx',
TargetTdpId='idwprd',
TargetWorkingDatabase = 'xxxx',
TargetUserName='xxxx',
TargetUserPassword='xxxx',
SourceFileName = 'tdload.csv',
TargetTable = 'tdload_1',
SourceTextDelimiter = ',',
TargetMaxSessions = 5

We are getting this exception when running a query in a web application which coonects to Java API through a web service. The jar being used is terajdbc4.jar and the version of JDBC being used is TeraJDBC 13.00.00.22. I have run the query using bot ANSI mode and Teradata mode both using CLI,ODBC and Terardata.NET;no such error has been seen.

We are getting the following exception when connecting from AIX machines using JDBC 13 drivers to a Teradata 12 database.

The exception ceases to occur, when we switch to the JDBC 12 jar files of the drivers.

My customer is claiming that LCC and round-robin DNS will still cause potential balancing/availability issues. They state that although Windows XP will randomly choose a DNS entry, Vista and Windows 7 will always connect to the nearest host (by IP address) so you do not get a consistent load balance situation.

I have a C executable program that has embedded SQL in it connecting to Teradata. The program was coded, compiled, and linked on an AIX development server. To promote it to production, we will just copy the executable program to an AIX production server.

I have just complete some testing with a application I have made using the JDBC teradata driver. However, when I read from my resultset it appears that I lose non standard characters such as (± ¼ »). These are typically used within xml which is what I am also retrieving from the database, and they return as question marks, with an int value of 65533.
The values themselves are correctly shown in Teradata SQL assistant.
I have also tried creating a mysql database, which I could return the same characters from successfully.

I could connect the DBS via bteq when the program was retrying to connect to TD DBS(14f.00.00.00).
But who can tell me it is an issue of c3p0 module or TeraDriver?
DEBUG com.mchange.v2.resourcepool.BasicResourcePool - An exception occurred while acquiring a poolable resource. Will retry.
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.18] [Error 1276] [SQLState 08S01] Exceeded login timeout for 153.64.211.204
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)

Pages