0 - 50 of 123 tags for odbc

Pages

The ODBC Driver for Mac OS X allows you to connect to the Teradata database from Mac OS Xapplications.

The ODBC Driver for Windows allows you to connect to the Teradata database from Windows applications.

The ODBC Driver for Solaris allows you to connect to the Teradata database from Solaris applications.

The ODBC Driver for Linux allows you to connect to the Teradata database from Linux applications.

The ODBC Driver for HP-UX allows you to connect to the Teradata database from HP-UX applications.

The ODBC Driver for AIX allows you to connect to the Teradata database from AIX applications.

This package contains the Aster client tools for MacOS.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for AIX.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for Solaris.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for Linux.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

This package contains the Aster client tools for Windows.

 

Release numbering for all of the above will follow this convention:

XX.YY.ZZ.nn

where:

Hello, we are attempting to connect to a Teradata database using ruby-odbc. Our code works properly on our Windows machines but it has a segfault on a Mac. I have reproduced the error message and crash log below. Prior to the crash, it appears to be able to connect and execute the query.

Hi all,
We are experiencing a relative slow ODBC throughput from TD to Microstrategy and I am wondering if this is "as good as it gets" or if the throughput is below standard.

Hello, I have installed TD 14.00 on a RHEL server and trying to connect to a TD server using TDXODBC.  I just ran a strace and am getting the following error.  It appears that this is happening during logon and then aborts.  Can anyone enlighten me as to what this library is, related error and suggestion to how to fix?  Any assistance is greatly appreciat


/* teradata odbc sample */

#include <stdio.h>
#include <iostream>
#include "connection.h"
#include "schema.h"
#include "DMLGroup.h"
#include "sqlunx.h"
#include <sql.h>
#include <sqlext.h>
#include <stdlib.h>

#define TRUE  1
#define FALSE  0

#define MAX_STR  256
#define MAXLINE  1000000

Hi All;
I have installed the drivers for php on a RHEL 7 system. I've configured the odbc.ini with the same settings I had on an older system but I am getting this error when trying to load a page that queries the database. Installed driver is 15.10

[:home/cl2515/perl] perl -MDBI -e 'DBI->installed_versions;'
  Perl            : 5.016003    (x86_64-linux)
  OS              : linux       (2.6.32-220.4.2.el6.x86_64)
  DBI             : 1.631
  DBD::Teradata   : 1.52
    DBD::ODBC       : 1.52
 
My code
use DBI;
use DBD::ODBC;

I am new to python, and am finding that my first attempt to connect via ODBC always fails with the error you see below, however the 2nd attempt, immediately afterwards, always succeeds, and does so pretty quickly.  Any thoughts on why this might be?

 

HI ,

I am getting this  "unknown error occurred in terasso library"

-when I try to setup in the ODBC in 64bit... an also try the 32bit version  (After installed it ..to test )

 

both are register under

 

c:\>c:\windows\system32\regsvr32.exe c:\windows\system32\scrrun.dll

 

One Analyst here can't see Unicode character using a statistics package called Stata that can only connect to TD using unixODBC.

 

HI, 

I am having issue to install ODBC Driver (64x)

The CLIv2 - Suite 15.10.04.00 for Windows (X64) after been installed is not been recognized when I installed  the X64 from the ODBC Driver Suite 15.10.04 for Windows.

 

Any advise is helpfull 

Error Using teradata client for centos 6/7 php/python/unixODBC

When issueing the following statement

select case when (1 = 0) then 1 else 0 end;

in Teradata Studio 15.00.02 using ODBC Driver Version 15.10 I receive the following weird message:

I've been playing with Teradata ODBC Driver for Linux x64 version 15.10. I have installed it and successfully able to connect via tdxodbc64 tool. But unfortunatelly, I wasn't able to connect via a very simple Mono application (Mono runtime 3.12.1).

Hi,
 
I'm geting "Not enough information to log on" error message when trying to connect using the Teradata Python module, pypyodbc or SQL Assistant ODBC.
Using Teradata Python:
session = udaExec.connect(method="odbc", system=***,username=***, password=***);
*** - hide the real values.
Using pypyodbc:

I can connect to a Teradata db instance using a DSN entry.  When I reference that same DSN entry in an adodb connection string the .Open command generates the error "Not enough information to log on"  
 

    Dim conn As New ADODB.Connection

    

    conn.ConnectionString = "DSN=TDFADS_SYS" 

    conn.Open

I am having problems using the SET QUERY_BAND via ODBC. I need to use it followed by a SELECT statement in a production context. I am not at liberty to change the SQL code nor post the actual code, but I have created a very basic equivalent to illustrate the problem.
If I use the following code

After installing ODBC driver 15.10 (tried 15.00 too) on a MAC, I tried to connect to a Teradata server and got the following error.
u'[28000] [Teradata][ODBC Teradata Driver][Teradata Database] The UserId, Password or Account is invalid. '

I'm trying to import my SQL Assistant (.mdb) history and am receiving an error immediately after choosing the file:
[Microsoft].[ODBC Driver Manager] Data source name not found and no default driver specified

Hi,

Can anyone share instructions to install teradata ODBC driver in cygwin enviroment.

I am trying to install and tryout Teradata for Python Module  and getting the following error.

I believe this is because of missing ODBC. 

 

I've been trying to use the TTU 15 tools iwth Windows 10, and while SQL Assistant ("Queryman") in native Teradata mode works fine, I can't get it to work in ODBC; nor will Teradata Admin work.

One nice feature of the JDBC driver is the ability to specify how much logging output goes to stdout. For those who aren't familiar, you can pass LOG=DEBUG to get extremely detailed info from Teradata about how your queries are performing.

 

 

I can successfully connect to DB2 using my odbc files. But when I try it with Teradata I get the following error:

Use the following links to obtain the Aster Client tools for your platform :

( Windows | Linux | Solaris | AIX | Mac )

Hi all, hoping someone can help. I've got a clean CentOS 6.4 box and I'm trying to connect it to Teradata. My first step is to install ksh then I install the tdodbc 15 packages: tdicu, tdodbc, TeraGSS.

Hi,
I am trying to load a delimited flat file with " as qualifier. We use SSIS 2008 and using  attinuity connector for teradata destination.
The load seems to be running but in the end it fails with the below error and it doesn't commit any records :
 

Hello. Unfortunatelly the net is really empty with that information. I didn't find anything right about that. Please, help me with that common problem. I can't connect my Teradata SQL Assistant to ODBC Teradata Source. I'm working alone at my home pc (local host). I've got mysql client and database where i was studying sql first.

The Teradata ODBC driver v14 does not seem to conform to the specs. When running SQLStatistics with SQL_QUICK, the call does lots of locking and count(*) operations. The manual says that SQL_QUICK should prevent this behavior.

Where can I get theAster ncluster odbc driver for mac os. I need the driver for RODBC connectivity. 
 
Thanks,
Amit

Where can I get theAster ncluster odbc driver for mac os. I need the driver for RODBC connectivity. 

When I try to use TPT wizard to connect to SQL Server using odbc DSN I am getting: There was an error initializing the driver for usage.

 

My configuration is the following:

 

Teradata RDBMS version 14.10.03.06

 

64bit Windows Server

 

TTU is patched to 14.10.15.00

 

We are trying our first job with TPT and are having problems connecting to our source database.  We are receiving this error...
TPT17101: Fatal error received from ODBC driver:
STATE=IM002, CODE=0,
MSG='[DataDirect][ODBC lib] Data source name not found and no default driver specified'

Hi,
 
I am trying to package the ODBC driver for installation at our company and am encountering some issues with setup.exe. The GUI claims it is installshield but all the usual command line arguements are not working. I jsut get an error "The setup command line is invalid. The setup cannot proceed".
I have tried ...
 

I have written a C# ASP.NET application that uses the Windows TD ODBC driver (v 13.10.00.10).  In my code, I create an open a connection, perform my query, then close the connection.  However, what we are seeing is that the connection (session) persists in Teradata for some arbitrary amount of time after the application has finished with the connection an

Hi,
 
We installed the Teradata ODBC drivers (v15.00) on an Exalytics T5-8 clustered environment (2 nodes) - with all prerequisites in place.
We tested on both nodes with nqcmd and we can select metadata and data from both Solaris nodes.

Hello,

Since it appears SQL Assistant is still available only in 32-bit version (TD 14/15 clients), it attempts to connect to Oracle's 32-bit ODBC.
On 32-bit Windows platforms everything is peachy.

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;