350 - 400 of 884 tags for Connectivity

How can I map Boolean type using Entity Framework, Fluent Api?

I found this in Teradata type mapping documentation

"

Teradata does not natively support a Boolean type.

Hello,

I have gone through JDBC documentation, but I have not found a property or any other way, how to tell jdbc to retry a query that was aborted due to a deadlock.

We are running a lot of concurrent jobs and we get sometimes a deadlock - not because of actual deadlock, but because of lock table being full on an AMP.

When I change my operating system to win7 64bit , I connot connect my ETL Service by ETLAdmin because of  that I cannot create a 32bit obdc connection to my orace ETL repository an more.
So I modified the ETLAdmin.jar file ,and it connects etl repository through jdbc connections instead of odbc connections.

Hello!

A problem that I have been coming across is that when I connect to Teradata via a third-party programming language (whether that be Python or C), the Teradata session does not terminate until the system times out even though I explicitly close the ODBC connection.  The following is an excerpt from my code:

Byte Field value is returning like Box Symbol with "?" Symbol , it is not in readable format in VB 6.0 after that i checked in Teradata SQL Assistant, in that byte field is returning value in readable format like 00-00-00. And i am very sure this problem is not happened due to my code problem and it is not a problem of ADO Object Library also.

I have added reference to Teradata.Client.Provider (.NET Data Provider for Teradata 14.0.0.0, Runtime v2.0.50727) to my Visual Studio C# 2010 project
Now, i want to get list of all ODBC names for Teradata

I included the namespace for Teradata.Client.Provider

 

Windows setup: tdodbc__windows_i386.14.00.00.04.zip (tdicu, TeraGSS, tdodbc), Python-2.7.3, pyodbc-3.0.3

 

I am able to extract data from using tdxodbc.  The following piece of python code also works fine -- 

 

========

>>> import pyodbc

 

 

   Hi,

 

    I installed Teradata 13.0 express edition after completion of installation for few days it is working good.

 

 

   Hi,

 

    I installed Teradata 13.0 express edition after completion of installation for few days it is working good.

 

 

   Hi,

 

    I installed Teradata 13.0 express edition after completion of installation for few days it is working good.

Been attempting to execute an SP from SAS using: 

 Libname td teradata server="nn.nnn.nnn.nnn"

user=xxxxxxx password="xxxxxxxx" schema=xxxxx

connection=global cast=yes dbcommit=0;

 

PROC SQL;

   execute (call td.SP_01('Test_ID2', '77', 0);) by teradata;

QUIT;

 

Does anyone know what would cause, or how to correct a Socket Error?  Below are the details of the error message:

I'm trying to establish a connection from my linux box to a Teradata server

 

My odbcinst.ini looks as the example does

 

     [ODBC DRIVERS]

     Teradata=Installed

 

     [Teradata]

     Driver=/opt/teradata/client/ODBC_32/lib/tdata.so

     APILevel=CORE

I execute the sql by TeraJDBC13.1, but throw the exception:

 

 

16:55:31  [SELECT - 0 row(s), 0.000 secs]  [Error Code: 1005, SQL State: HY000]  [Teradata JDBC Driver] [TeraJDBC 13.10.00.31] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 33

Trying to connect through C# using an LDAP login:

 Teradata.Client.Provider.TdConnection con =
                    new Teradata.Client.Provider.TdConnection("Data Source=192.168.1.54;User ID=mw;Password=pwd;");

            con.Open();
 

Hi,

As you know TD 13 is not supported on 64-bit. Is there a way of installing TD 13 Express edition on a 64-bit machine that does not support Virtualization? What are the options available?

Thanks for your time in advance!!!

Regards.

Hi,

I once created a DB which I filled with 5000 images (50MB each). Unfortunately I dropped the table lately so I am trying to recreate the table. But

after a few hundred entries the following message appears:

As per subject, really.  Got a simple query:

SELECT * FROM dbc.databases WHERE databasename != 'foo'

When I try and run it through the JDBC connection I get the error:

Hello

 

Can you kindly post a code snippet on how can one load data with fastload from csv in java application ?

I'm able to connect to TD via JDBC but I cannot find any useful docs with examples how to use fastload in an application.

 

Thank you in advance
 

I have a SQL such as this:

Hi

The environment my Windows app runs in has recently changed and uses LDAP as the authentication method for connection to the Teradata warehouse.

But I'm really stuck, I am unable to connect using my app now.  I can connect ok using the Queryman application, using the same User ID and Password values, so I know the connection is possible and queries will run and return results from the Queryman application.

My ConnectionString looks like this:

I have several SAS tables that require to be copied over to Teradata platform V13.

I usually use the Fastload option and works very well, however I need to create and

Hi

I created a very basic JUDF as described in the official tutorials:

http://developer.teradata.com/tools/articles/getting-started-with-teradata-plug-in-for-eclipse

http://developer.teradata.com/tools/articles/creating-a-simple-java-user-defined-function-using-the-teradata-plug-in-for-eclipse

I am using Eclipse and Servoy (www.servoy.com) to create a CRUD application.  Using other JDBC drivers works well in Servoy but the Teradata (v14) JDBC driver does not work as well for CRUD operations.  However, the things I can do using the Teradata drivers are single SELECT statements and INSERT, DELETE

I am using Teradata ODBC 13.0 with php and session is set to UTF16 but not able to display them properly on php page. Is there an issue with Teradata ODBC while converting Unicode characters.

The problem was persisted even I used jdbcodbc. It worked fine with Type 4 jdbc driver. 

Please Suggest 

Hello,

I have a C++ application using the TPT API in "TD_STREAM" Mode (TeraData Client 13.10 + Linux VMWARE TeraData 4GB 13.10) in order to write data to some tables.

I have created a user with limited storage (something like 1MB).

We are testing one of our applications and some of tests fail with the following error 

 

Teradata.Twm.Data.DataAccessException:  Unicode Conversion Error ---> System.Data.Odbc.OdbcException: ERROR [HY000] [Teradata][ODBC Teradata Driver][Teradata Database] Unicode Conversion Error

I Installaed TD-13 for Win-32. First surprise was this package does not contain SQL Assistant. 

Anyways I downlaoded TD studio and installed it. 

In the eobject explorer how do I connect to the server ? I never came accross an option to configure the server or set up a default database etc. Please help. 

I am importing data from Excel (CSV) file to teradata using Insert into table_name values (?,?,?),but now what i want is to use the same statement in the stored procedure .

 

I have installed Teradata Express 13 on Windows 7, 32 Bit. After the installation I start Teradata Service Control and click on "Start Teradata!". After a few seconds it is started.

As stated in the Getting started guide I know click on File/Session Info. After 2 seconds a popup appears which states the following error:

hello there

Do people actually have the .NET Data Provider for Teradata integrated in Visual Studio 2010? I know you can add a reference to the driver and write code against it, that works fine. I'm talking about integration, where Teradata shows up in the Data Source list when creating things like Entity Framework Data Models.

We are upgrading our scheduler to a new version.  When testing a multiload we get the following error message:

UTY1006 CLI error: 527, DBCHINI failed

Running the same script manually works with no issues.

Any insight into this would be greatly appreciated.

Thanks in advance.

 

Hi,

I am using JDBC Driver 13.10 in my application, my connection is working fine, but as soon as I turn on the proxy server under internet explorer, application is not connecting and giving error server not found. While i have checked option "by pass proxy server for local addresses"

Any thoughts?

Regards
Mohsin Ali

I have a frustrating issue with ODBC in linux redhat.

I can run SQL and get accurate error messgaes from Teradata sample testing program using ODBC.

But when I use python or isql, odbc driver manager complain and returned a generic error message.

Below is a python example:

I installed the most recent ODBC driver earlier today (Windows XP 32-bit, ODBC version 14.00.00.04), and immediately lost the ability to connect via ODBC, in Teradata SQL Assistant. The error I receive is:

160: Specified driver could not be loaded due to system error 126 (Teradata)

I have been deploying Java XSP for a couple of months.  No problems and very useful for the right scenario.  All of a sudden, a working program starts throwing this error:

"Failure 7832 XSP Application FACTSII.JXSP_BUILD_SF133 caused protocol error : authentication fields don't match (igtw-009)"

Has anyone encountered this issue?

I have a test case where I bind current time (milliseconds) and it fails with [Error 6760] [SQLState HY000] Invalid timestamp. 

My question is do I have to take care of some timestamp formatting before I bind it with setTimestamp method of PreparedStatment ? Or is this a knwon issue and I can expect a solution for it?

Hi,

a somewhat odd question about a simple method to restrict (inhibit) connection using a "production" User that is over-used among developpers (everybody knows User and Pwd).

In a basic context (no LDAP, no active Mechanism ...) of SQLA requests.

I have a Teradata user called FREDBLOGGS. 

He has an account on Teradata (UserID FREDBLOGGS / password TERADATA). 

He also has an entry in LDAP (UserID FREDBLOGGS / password LDAP).

If I set up my Teradata server to authenticate via LDAP, can this be overridden by the authentication mechanism chosen by Fred when he logs in?

Hello. I have an inward facing ASP web app that I am changing to connect to Teradata instead of an AIX box.  I am able to connect to the Teradata Server and execute queries using an ODBC connection using VB 6 (so I'm told.

When I call

ResultSet rs = dbmd.getColumns(null, "CUSTDATA", "TRANS", null);

it takes 16 seconds to get an answer back on a fairly unloaded system.  This table has 27 columns.

 

This seems to be excesvily slow.  Is there anything that can be done to speed this up?

 

I have a couple application are are using ENCRYPTION=ON in their connection strings.  Is there any way to tell on the database side (DBQL, etc) so that I may verify that the encryption parameters are being accepted?

Trying to create Entity Framework Model in Visual Studio 2010 but it seems to hang at the point where I select the tables and hit Go. I'm able to open the connection and see the objects in TerraData but never finishes this dialog. 

 

Any help is greatly appreciated. 

We are upgrading our database from V12 to V13.10.  In preparation for our upgrade, we have upgraded our TTU components to 13.10.  We have also installed Viewpoint to replace Teradata Manager, TDWM, ect.

I recently joined business objects team for report development activity. my database server is teradata server.How can i connect to teradata server from business objevts tool? what drivers i needed , & from where i can download them? what steps i should follow for connectivity?