50 - 100 of 123 tags for odbc


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

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.

This release of the Teradata ODBC driver for MP-RAS supports Teradata 12.0 features in both Teradata and (Entry Level) ANSI modes, and is backwards compatible with previous releases back to Teradata Database V2R6.0.

requesting help with implementing query band on ODBC for Crystal Reports.
We've done this with Business Objects  Universe data sources and now would like to implement query band on  ODBC  data sources for Crystal reports to Teradata using the Teradata ODBC driver.

Hi there,
I need to create a UDF in C to connect to a teradata server dynamically....can this be written using the ODBC API and then integrate this function into the teradata dictionary or will I have to use CLI to do this task?????

I am trying to reach a remote host that is running Teradata services via ODBC.
My machine is 64-bit RHEL 6.x with the following Teradata software installed:
Media: TTU Foundation
1. bteq      - - Teradata BTEQ Application  

I am having an issue where a Transform request from the SAP BO ETL tool Data Integrator is creating additional SQL to the DBC (examples below).  We are using the native bulk load option (insert/select) via ODBC connection.  I want to eliminate the additional SQL's that are being generated.  Is there an option/setting in ODBC or Data Integrator that anyone

Linux Environment Details:
Linux version 2.6.32-431.3.1.el6.x86_64 (mockbuild@x86-003.build.bos.redhat.com) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-4) (GCC) ) #1 SMP Fri Dec 13 06:58:20 EST 2013

I am adding another article about connecting to Teradata through R by using the teradataR package. The following comes from my experience working on a 64-bit Teradata Express Virtual Machine (TEVM), and complements the existing forum topic at:

I have installed both 32-bit and 64-bit ODBC drivers for Teradata. I have set up the DSN for both 32-bit and 64-bit using the below odbc administrators
for 64-bit - C:\Windows\System32\odbcad32.exe ; DSN Name : DW64
for 32-bit - C:\Windows\SysWoW64\odbcad32.exe ; DSN Name : DW32

SQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.10
I am unable to Define ODBC Data Source in Teradata Sql Assistant.
File Not Found
Unexpected Error . Refer to the following file for details :
c:\Users\MYUSERNAME\AppData\Roaming\Teradata\SQL Assistant\SQLAError.txt

We currently use Teradata version 13 and have no issues connecting to Unica version 6 via ODBC connection.

Being not an expert at upgrades, I have an old client GSS/ODBC install version 3.06 & would like to upgrade to the latest V14 drivers. The old drivers are located in an NCR folder, & from initial checks the V14 installs under Teradata folder.
How do I sucessfully update?

I have succesfully set up an Access front-end that links tables from a Teradata database.  Everything works fine when I have the tables linked through a DSN.  I am trying to set up a DSN-less connection, but I am encountering the following error:  "Reserved Error (-7778): there is no message for this error"

I'm generally more of a forum lurker, but every once in a while I get something working that doesn't readily work out of the box the way you'd expect and feel that its worth posting about to ease the path of others (and maybe leave a trail for Google to scan so I don't have to remember where I left my notes!)

Is the Teradata .NET Provider more efficient (faster) than connecting to the database via ODBC? This may be a silly question, but can Informatica use the Teradata .NET provider?
Todd Thompson
Habitat For Humanity

While trying to set-up Oracle Transparent Gateway on redhat Linux 6.4(64 bit system), we are getting the following error.
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [DataDirect][ODBC lib] Specified driver could not be loaded {IM003} ORA-02063: preceding 2 lines from TERADATA

I have some problems accessing Teradata from EXCEL with a ODBC driver.
The Teradata database BASE_A, has user access restriction set on the base itself.
Here I can setup the ODBC driver so that I get access to BASE_A from Excel.

Hi, I have had a search through the forums (and google) and have found plenty of discussions about teradata ODBC drivers, but none that seem to quite match the issue I am seeing....

I have an application that determines the schema for a table through a Windows ODBC connector. Not all attributes are accessible through GetSchema() calls so I have to augment with the querying of system tables.


I'm trying to transfer data from a MySQL table into a Teradata table. The export uses the ODBC operator and the inport uses the LOAD operator.
All records go into the ET table, usually with 2673 (source parcel length incorrect) errors, some of them fail with a 6760 (invalid timestamp field).

I need to connect , OBIEE RPD  with teradata database. My OBIEE server is in Linux.
I need to install ODBC driver for Teradata in Linux.
I have downloaded the odbc software from "http://downloads.teradata.com/download/connectivity/odbc-driver/linux"
But the read me files says , ODBC installation depends on

I have been looking for instructions on how to install the Teradata ODBC drive in a linux environement. I have Centos 6.4 installed with unixODBC 2.2.14 installed. I have downloaded the 64-bit ODBC drivers an attempted to install the TeraGSS, ICU and ODBC driver but I cannot connect using isql. I get the following error message: 

I have strange problem. Consider below Teradata Stored Procedure:

Hi there. My organisation is just beginning with Teradata development, and I'm wondering which connectivity option (.NET Provider, ODBC etc) we should use. We develop against version 4 of the .NET framework using Visual Studio 2010 and 2012. Could anyone recommend one connectivity option over the others, or perhaps list the pros and cons of each?

Is there a way to tweak ODBC/Stata to work with volatile tables in Linux?
Stata (a statistics package) allows SQL statements to be issued directly to ODBC data source. I believe SAS has similar pass-thorugh functionality. There's some description of this here: http://www.stata.com/help.cgi?odbc

Hi all,
I'm trying to create a simple ODBC connection using a couple of 3rd party tools called:  Aqua Data Studio and Razor SQL.   First, I followed the steps in the Aster nCluster user guide to create the DSN ODBC connection on a Windows 7 x64 SP1 desktop.  I was able to test the connection succesfully.

I am getting below error while trying to connect to Oracle DB using DataDirect 7.1 ODBC drivers from TPT script. I am able to test the connection using the example executable program in DataDirect and it works fine.
TeraData Version:  13.10
DataDirect Driver: 7.1 (64 bit trial for testing purpose)
Below is the Log.

My database is a Teradata version
I retrieve data with a MS Excel v2003 file (using MS Query)
Before to do that, I installed "the tdodbc__windows_i386." products on my desktop : Teradata Client 13.10, Teradata ODBC driver. I created a System DSN etc.

There's lots of posts relating to the 10065 error, but I don't see any solutions that apply to this case.
Teradata is up and running and usable for 100s of others in my organization - not a problem on the TD side.

We have an existing Cognos 8 environment (running on Windows 32bit) connecting to Teradata via ODBC driver using a Teradata account with 2GB/amp in spool setting, and the report is working fine.


I got to know that I can use TPT ODBC Operator to select data from another ODBC DB and then load that data into TD DB, using the LOAD Operator.


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:

I have added reference to Teradata.Client.Provider (.NET Data Provider for Teradata, 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. (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


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 installed the most recent ODBC driver earlier today (Windows XP 32-bit, ODBC version, 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)


CREATE VOLATILE TABLE temp(cola VARCHAR(20),colb VARCHAR(20),dat1 DATE FORMAT 'ddmmyyyy',

dat2 DATE FORMAT 'ddmmyyyy')



When i tried inserting using the ODBC connection like this


INSERT INTO temp VALUES('a','b','01012000','05012000');  


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


i am facing a problem in ssis, i want to get large data from teradata source using odbc but i am getting the following error:

TITLE: Microsoft Visual Studio

There was an error displaying the preview.


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

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

When I try to connect using a third party Teradata ODBC driver, I receive "The UserId, Password or Account is invalid." error. If I use the Teradata ODBC driver the connection is successful.

I am using the same credentials for both connections. Has anyone come across this issue with SQL Assistant 13.10?


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:


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:

SQLHENV 0x13a13830

ODBC Learning Examples - Tier 2 is a suite of applications designed to provide an informative guide to developing ODBC applications as well as providing simple building blocks for ODBC applications.  The samples are split into eleven distinct modules. Within each module there is a range of applications usually with a unifying lesson in mind. This document contains instructions for the use and the descriptions behind each module and the sample applications contained within that module.

ODBC Learning Examples are a suite of applications designed to provide an informative guide to developing ODBC applications as well as providing simple building blocks for ODBC applications. Please see the ODBC Learning Examples article for details on usage.

Is it possible to install 64-bit version of ODBC driver on Red Hat Linux? I can't find 64-bit version of TeraGSS for Red Hat in downloads, there is only 32-bit version.