550 - 600 of 920 tags for Connectivity

I am trying to use TPT to move a table from Oracle 10g to Teradata 12 using the ODBC operator with Oracle ODBC driver When I execute the script with tbuild, I get

EMAIL_SRC_CD_LK_ODBC: connecting sessions
**** 12:38:34 Fatal error received from ODBC driver:
MSG='[Oracle][ODBC]Driver not capable.'
= =
= ODBC Driver Information =

There is a standard X.12 interface in the healthcare industry. I am new to this industry. Does anyone know if Teradata has a standard X.12 interface for healthcare? Sorry, due to lack of understanding on my part, this question may seem vague.

I am converting my .Net application from visual studio 2005(.Net 3.0) to Visual Studio 2010(.Net 4.0).
I am using the Teradata .net provider version My development machine is on 32-bit Windows 7

After converting my .net application into Visual Studio 2010(.Net 4.0), the Teradata .net provider doesn't seem to work with .Net 4.0

Howdy, I'm having a problem installing the ODBC driver, Version 12 on my Windows XP laptop. I'm getting the following error. "Unable to Locate File C:\WINNT\Temp\pft11f~tmp\ODBC Driver for Teradata.msi". The file is there. I tried registering it by hand and still no luck. Anybody with any thoughts or suggestions? Thanks


I'm new to Teradata. I have installed the Teradata SQL Assistant 13 and I am connected to an Oracle-DB (Oracle ODBC-driver and Oracle Net-Manager).
With The SQL Assistand 12 I got the date values as timestamps (e.g. 08.08.2010 09:53:12).
Now with the verstion 13 I only get the date (e.g. 08.08.2010).

Greetings everyone. New to TeraData and am in need of a 64-bit, Windows compatible driver (ODBC and/or OLE DB) for Windows 2003 / 2008 OS using Xeon processors. I've seen references made to such a driver but am unable to locate on this site, TeraData's site or others.

Can anyone shed some light as to its availability?

Best Regards,

Windows ODBC driver downloads are not currently available from the usual location on your web-site.
Please update the site content.
Thank you

Hi All!

I'm use Teradata ODBC driver ver. I need to bind variables but I've got a problems with VARCHAR variables (the INTEGER or DOUBLE variables are OK)

The source:


v_col->data; //pointer to data
v_col->len; //pointer to data's length


Is there a way to tell the character set from a char/varchar column in a TdDataReader?

The DBC tables contain a field "CharType" which is 1 for "character set latin" and 2 for "character set unicode" columns. The "ColumnLength" is also doubled for unicode.


I have a problem with the Teradata Database when a user is disconnected e.g. by network error.

Let's assume the user is in manual commit, ANSI transaction mode, uses the SQL Assistant, and connects via ODBC to the server.

Now, while the user is connected to the server, the network connection is lost (e.g. cable removed).

On the server side, I can still see the session of this user! This causes problems - imagine that there was a transaction which locked some tables. These locks will now stay until the session is aborted by the server (we set the IDLE timeout to 60 minutes).

I tried to issue the query banding statement along with my SQL query in a single transaction, like:
SET QUERY_BAND='AppName=B;'FOR Session;SELECT ....

This ran successfully in the Teradata SQL Assistant but not in Teradata Administrator as well as not in my application which uses JDBC connection via Teradata's JDBC driver.

Hello All,

When running some reports against the below version of Teradata, I am getting the following error. It seems to happen when the system is under load. A report which fires this error may run fine an hr later. I am pretty sure it's a connection or env limitation being hit but I am relitavely new to Teradata and need advice on how to troubleshoot from the DB side. I am very experienced with RDBMS just not that familiar with Teradata.


[NCR][Unix system error] 131 Socket error - Connection reset by peer, BufferLength = 512, TextLengthPtr = 69


I am trying to install the Teradata 13.0 ODBC drivers on a RedHat Linux 5 server (fresh install, no migration) to access a Teradata 12.0 database.

I am receiving a "Segmentation Fault" whenever I connect. I am currently using the sample adhoc provided by Teradata. I get the same error regardless of what software I use to connect.


I have installed teradata ODBC client "TTU 12.0 SOLARIS-x8664 tdodbc." on Solaris Intel platform.
The driver got installed correctly. And with other configurations (like LD_LIBRARY_PATH setting and ~/.odbc.ini configuration), I am able to connect to a teradata database and execute queries using the sample c++ program provided with the teradata client package.

To join Business Technology Summit 2010 as a speaker is a great opportunity to build brand equity for both you as an individual and for your organization.


I need to install Teradata ODBC client on Solaris Intel platform.
Which one I should go for, from the list of clients mentioned in "Teradata Download Center"?


On Solaris I can't logon DB server via Teradata OBDC 13.0, even I input correct username and password.
It returns below error message:
Error: message = [Teradata][ODBC Teradata Driver][Teradata Database] The parcel stream is invalid. , sqlstate = HY000, native code = -8019

I couldn't findTeradata OLE DB Provider 13.0 64 bit for Windows 2008 on the download site.


We installed this teradata driver:
on a windows 2008 box. It's a 64 bit teradata driver. But when I go to add a System DSN in ODBC, none of the Teradata drivers show up as choices. Any ideas as to why the no show?


I have installed 64 bit Teradata ver on a 64 bit Windows Server 2003 R2 server in the following order (not an upgrade):
TDICU, TeraData GSS client, ODBC Driver, .Net Provider for Teradata
I then installed the Teradata SQL Assistant which appears to have installed in the Windows 32 bit path.
We created an ODBC connection via ODBC Administrator successfully with the Teradata driver recognized.
Opening Teradata SQL Assistant and making a connecting using .Net is successful. The ODBC connection does not show any data sources.

OK, so i want to pass parameters to the install when it runs to create a DSN entry etc.

Can this be done, as ive tried running with /V variable name=value but had no joy?

Please HELP

Hi Friends,

I want to do link exchange with instant payday loans website(s).... if anyone interested
please let me know

my site - [url=http://www.usainstantpayday.com/]USA Instant PayDay[/url]


hi ,

I am new to Teradata. I am trying to connect to Teradata DB using teradata driver. i am getting Error in DriverManager.getConnection() Method. I am not able to understand why this is comming. I have tried with the latest driver avaliable in net for teradata.

String url="jdbc:teradata:///AMRROCD"
Properties x = new Properties();
Connection con = DriverManager.getConnection (url, x);--> I am getting Null Pointer Exception at this line .

hi ,

I am new to Teradata. I am trying to connect to Teradata DB using teradata driver. i am getting Error in DriverManager.getConnection() Method. I am not able to understand why this is comming. I have tried with the latest driver avaliable in net for teradata.

String url="jdbc:teradata:///AMRROCD"
Properties x = new Properties();
Connection con = DriverManager.getConnection (url, x);--> I am getting Null Pointer Exception at this line .

We would like to create internal incidents in our Incident Management system when Teradata errors occur - Those reported on the AWS today.

This process is in place for errors tracked by MOM/SCOM.

Is it possible to use MOM/SCOM to report the errors generated by Teradata? (Restart, Node down...)



I'm from Teradata Japan.
I'd like to let you know about great library for Teradata-Ruby connection.

We have rocking programmer, he is one of the Ruby commiter, in our PS division and he made the library for Teradata-Ruby connection.

I have installed the icu libraries and GSS client succuessfully but i get the error:
Error 1720 There is a problem with the Windows installer package. A script required for this install could not be run.....Custom action uninstall_pre_version6432, script error 214682823

It works perfect with x86 odbc driver, but failed with x8664 odbc driver.

Does anyone has suggestion on this issue? I had installed tdicu, teragss and td odbc driver.

Error message is 'Specified driver could not be loaded due to system error 126 (Teradata)'


I am using TD .NET provider 12.x and have stored procedures. All my SPs have IN & OUT parameters. In my understanding, TD has a strange way to returning the OUT params as a dataset & it works fine. When I have SP that delete records from a table, and also returns OUT params.

When I execute this Sp from .NET, I get a empty dataset (tables = 0). On checking the data, it actually deletes the data correctly. But how can I know that records are deleted? I don't want to unnecessarily check the data for delete confirmation.

any help is appreciated. Thanks.

SP Code:

Are there any restrictions using MERGE via ODBC? I have MERGE statement which returns an error:

"[NCR][ODBC Teradata Driver][Teradata Database] The search condition must fully specify the Target table primary index and partition column(s) and expression must match INSERT specfication primary index and partition column(s)."

I connect to Teradata using ODBC and I would like to create very simple stored procedure. When I call SQLPrepare I receive error "[Teradata][ODBC Teradata Driver][Teradata Database] Syntax error: Invalid SQL Statement.", but when I call the same CREATE PROCEDURE... statement using SQLExecDirect then it works.


Can someone pls help with the following.

Teradata service control is not able to retrieve session info as part of the verification step mentioned in the getting started manual. I followed the below steps to install TDW 12.0 today first time on my laptop with WINDOWS XP.

1. Installed all softwares listed. Installation was successful except .NET Framework 2.0 SP1, which threw an error while installing it. Restarted the system.
2. started the Teradata DB initiator thru Services.msc.


When I tried to install the Teradata ODBC Driver Bit) in the Windows 2008 R2 and tried to run through the QlikView, Iam getting this error "Error: SQL Error:Specified driver could not be loaded due to system error 126: The specified module could not be found. (Teradata, C:\Program Files\Teradata\Client\13.0\ODBC Driver for Teradata\Lib\tdata32.dll)."

I found that the file is available in the specified location. Please clarify whether Teradata ODBC driver 64 bit is compatible with the windows 2008 R2.

The Release Note of "Teradata .NET Data Provider" says it support OSs below. Then it means this version will not support R2 editions?

Client Operating Systems:
Microsoft Windows 2000 SP4
Microsoft Windows XP Professional SP2 x86
Microsoft Windows Server 2003 x86
Microsoft Windows Server 2008 Standard x86 Edition
Microsoft Windows Server 2008 Enterprise x86 Edition
Microsoft Windows Vista Enterprise SP1 x86 Edition

Microsoft Windows XP Professional x64 Edition
Microsoft Windows Server 2003 x64 Edition
Microsoft Windows Server 2008 Standard x64 Edition


I have an application in linux which needs connect to teradata database via iodbc driver manager. I downloaded the teradata odbc driver and I did a connection test with the iodbctest utility but I couldn't connect and I received an error message with non-printable characters.

Does anyone know where I can find the following info related to the JMS Adapter:
- How many customers do we have using it?
- Best practices or lessons learned?


I am working in oracle Pl/Sql
I am new to teradata.
Two months back i did tera data V2R5 exams.
That means i have theoritical knowledge only.

In theory i read so many tools like BTEQ, CLI, etc

Can anyone guide me how i can start and on which tool?
I am in windows platform.

Thanks in advance.


I need to provide default database name in the connection string to connnect using Teradata OLEDB provider in ASP.Net.

Currently I am using following String:

in web.config.

But the problem is when I connect using this , I always get connected to Default Database mentioned example say if I have Databases X,Y,Z on same box and X database is set as default I am getting connected to X only while I want to connect to Y database.

Has anyone successfully integrated the TD12 or TD13 .NET provider into VS2010 Beta? I realize it is not going to be supported as VS2010 is still in beta. I can use it, but I was hoping for a little tighter integration on par with VS2008.


Hello everybody

Here it is the problem :

I install
- the odbc drivers 12 install on solaris 10 (sparc)
- teradata 12
- unixODBC (2.2.14).


I am trying to connect Teradata from Linux Red Hat ( LAMP-Installation ) via ODBC-Driver.
isql works fine, but i cant connect Teradata with PHP.

SQL error : SQl State in 00000 in SQLConnect ...

( Teradata ODBC Version 13.0 - Red Hat 4.0 )

Has anybody working a PHP/Teradata Connection and know a solution ?

When i try to call the stored procedure "ACEREWARDS_CUSTOMERPREF(?)", it throws error "something missing between "(" and "?" ", i dont know what it exactly looking for. If i removed the "(?)", it throws "stored procedure does not exists.
I am using Terdata.Client.Provider 13.0 in C#.NET3.5.
Any suggestions.

Hi,I'm trying to install ODBC driver 12.0 on my Windows server. I installed the GSS and the shared libraries. When installing the ODBC driver, it stalled at deleting backup files for over 2 hours. So, I stopped it using task manager. I rebooted and retried the installation. I get the error that "The installation wizard was interrupted. No changes were made to the system. If you want to install this at a later time, please start the wizard again". I tried uninstalling the GSS and shared libraries, rebooted and then reinstall. Same error however many times I try. Please help. This worked on other servers, just this one server. Do I need to clear out registry entries? If so, could you please let me know how to do that and what I need to do?Thanks,VP

Does anyone know where I might find help for ALL the Input paramameters in the ODCB setup for Windows? The User help file I found for ODBC on the Teradata Support site just says "make editing changes". But doesn't say anything in detail about the different parameters, and there's a lot of them!

Hi all,I have installed Teradata Demo version 12.0 in my PC. While i compiled a simple stored procedure the following error was prompted.Error: C/C++ compiler is not installed.Does C/C++ compiler is required for running Stored Procedure?Where can i get this compiler and in which folder should i install in my PC.Thanks,TmrModest.

Dear users,Per recent communication, we are pleased to announce the consolidation/merger of the Teradata Discussion Forums and the Teradata Developer Exchange Forums. The integration of the forums will create a single location - http://forums.teradata.com - for you to participate in Teradata Forums to exchange ideas with your peers and to get access to important Teradata information.We expect the migration to occur on the weekend of February 20th, 2010.We will be migrating across all legacy forum content, and will migrate your user account as well. For users that do not already have an account on Teradata Developer Exchange ( http://developer.teradata.com ), we will create an account using your existing Teradata Forums details, and will generate a new temporary password for you. These new account details will be emailed to you.Please watch for additional notices that will provide information on timing, accessing and using your forum account. To read more about the consolidation visit: http://developer.teradata.com/blog/neilotoole/2010/02/teradata-forums-migration-imminentThank you for your patience during this process, and we look forward to seeing you on the new Teradata Forums.- The Teradata Forums team

Hi,I tried to connect Teradata 12 Database from Red Hat Enterprise Linux v5.2 64 bit. I have installed drivers in this sequence:tdicu__linux_indep. have also installed but, when I try to connect to my DB i receive the error:Connect failed.Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [IM003:0: on HDBC] [DataDirect][ODBC lib] Specified driver could not be loadedMy odbc.ini is as follow:----------------------------[ODBC]InstallDir=/opt/teradata/client/ODBC_32/Trace=0TraceDll=/opt/teradata/client/ODBC_32/lib/odbctrac.soTraceFile=/MSTR/bin/odbctrace.outTraceAutoStop=0[ODBC Data Sources]default=tdata.sosvil=tdata.so[svil]Driver=/opt/teradata/client/ODBC_32/lib/tdata.soDescription=Teradata_12_ServerDBCName=10.XX.XX.XXX LastUser=Username=Password=Database=DefaultDatabase=[default]Driver=/opt/teradata/client/ODBC_32/lib/tdata.soDescription=Teradata_12_ServerDBCName=10.XX.XX.XXX LastUser=Username=Password=Database=DefaultDatabase=----------------------------My question is: is Teradata ODBC Driver ver.13 (I tried also with 12 and 8) supperted on a Red Hat Enterprise Linux 5.2 64 bit platform?Many thanks in advance.

Is their any free utility to compare tables/data of two different databases (sql server and teradata)?

i have windows server 2008 64 bit version and there i have installed teradata 13 driver. when I run select query the special characters is convert to some junk character but in other machine it works fine. do i have to do any settings on the server specific to language. please help.