Pages
![]() |
I'm using VBA and the Microsoft ActiveX Data Objects 2.6 Library to access our Teradata 14.00.05.03 server using Teradata ODBC Driver 15.00.00.01
18 Jul 2014
| 1 comment
,
|
![]() |
Hi All,
13 Jul 2014
| 2 comments
,
|
![]() |
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.
04 Jul 2014
,
|
![]() |
requesting help with implementing query band on ODBC for Crystal Reports.
29 Apr 2014
,
|
![]() |
Hi there,
24 Apr 2014
| 3 comments
,
|
![]() |
I am trying to reach a remote host that is running Teradata services via ODBC.
31 Mar 2014
,
|
![]() |
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
17 Mar 2014
| 3 comments
,
|
![]() |
Linux Environment Details:
17 Mar 2014
| 1 comment
,
|
![]() |
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:
28 Feb 2014
| 1 comment
,
|
![]() |
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
10 Feb 2014
| 3 comments
,
|
![]() |
SQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.10
28 Jan 2014
| 2 comments
,
|
![]() |
Hi
24 Jan 2014
| 1 comment
,
|
![]() |
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.
20 Jan 2014
| 3 comments
,
|
![]() |
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"
07 Nov 2013
| 1 comment
,
|
![]() |
Greetings,
06 Nov 2013
| 4 comments
,
|
![]() |
Hello,
24 Sep 2013
,
|
![]() |
While trying to set-up Oracle Transparent Gateway on redhat Linux 6.4(64 bit system), we are getting the following error.
19 Sep 2013
| 1 comment
,
|
![]() |
I have some problems accessing Teradata from EXCEL with a ODBC driver.
13 Sep 2013
,
|
![]() |
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....
20 Aug 2013
| 1 comment
,
|
![]() |
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.
15 Jul 2013
| 4 comments
,
|
![]() |
Hi,
15 Jul 2013
| 13 comments
,
|
![]() |
Hi,
30 Apr 2013
| 6 comments
,
|
![]() |
Hi,
28 Apr 2013
| 3 comments
,
|
![]() |
I have strange problem. Consider below Teradata Stored Procedure:
27 Feb 2013
| 1 comment
,
|
![]() |
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?
24 Feb 2013
| 2 comments
,
|
![]() |
Is there a way to tweak ODBC/Stata to work with volatile tables in Linux?
22 Feb 2013
,
|
![]() |
Hi all,
23 Jan 2013
| 1 comment
,
|
![]() |
|
![]() |
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.
10 Dec 2012
| 9 comments
,
|
![]() |
My database is a Teradata version 13.00.01.19
04 Oct 2012
| 8 comments
,
|
![]() |
There's lots of posts relating to the 10065 error, but I don't see any solutions that apply to this case.
28 Sep 2012
,
|
![]() |
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.
04 Sep 2012
| 1 comment
,
|
![]() |
Hi, 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.
31 Jul 2012
| 4 comments
,
|
![]() |
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:
03 Jul 2012
| 2 comments
,
|
![]() |
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 I included the namespace for Teradata.Client.Provider
24 Jun 2012
| 1 comment
,
|
![]() |
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
21 Jun 2012
| 2 comments
,
|
![]() |
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:
22 May 2012
| 2 comments
,
|
![]() |
|
![]() |
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:
03 Apr 2012
| 13 comments
,
|
![]() |
16 Mar 2012
| 4 comments
,
|
![]() |
CREATE VOLATILE TABLE temp(cola VARCHAR(20),colb VARCHAR(20),dat1 DATE FORMAT 'ddmmyyyy', dat2 DATE FORMAT 'ddmmyyyy') ON COMMIT PRESERVE ROWS;
When i tried inserting using the ODBC connection like this
INSERT INTO temp VALUES('a','b','01012000','05012000');
22 Feb 2012
| 5 comments
,
|
![]() |
I am trying to call Stored Procedure with parameters. Procedure have two TIMESTAMP parameters for example use below one:
12 Jan 2012
| 2 comments
,
|
![]() |
hello 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. ------------------------------
16 Dec 2011
,
|
![]() |
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
06 Dec 2011
| 2 comments
,
|
![]() |
How can a connection to a Teradata database be implemented as a PowerShell script using ODBC, .Net Data Provider, or other protocol.
16 Nov 2011
| 8 comments
,
|
![]() |
Hi, I am using the same credentials for both connections. Has anyone come across this issue with SQL Assistant 13.10? Regards,
02 Aug 2011
| 1 comment
,
|
![]() |
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]
20 Jul 2011
| 6 comments
,
|
![]() |
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.
13 Jul 2011
,
|
![]() |
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.
13 Jul 2011
,
|
![]() |
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.
19 May 2011
| 1 comment
,
|