100 - 150 of 1042 tags for Connectivity


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 am using Teradata JDBC Driver (
I have created a column for a table with data type TIMESTAMP WITH TIME ZONE ( It has the time with HH:MM:SS(upto 6 digits) + Timezone
When I fetch the resulset through JDBC I am missing the precision of seconds and also the timezone.

I am getting a around 200/500 lines of query results that is DDLs etc returned from my dot net query.  It works on SQL assistant okay. When I send it using the below query I only get the first DDL and not other DDLs.
Any idea, if this is a limitation or any setting that I need to take a look?
Here is my code:

Hi All,
I have a requirement to compare sample Teardata records from one table with another table in netezza. The process which I am following currently is :
- using SQL assistant export around 500 records from Teardata table in an excel

Hi All,
I tried connecting through SQL developer for TERADATA db ..I am having following error message when making a new connection
"Status :Failure-Test Failed :[Teradata JDBC Driver][TeraJDBC 15:00:00:28][Error 1000] [SQL State 08S01] Login failure to connection to servername timestamp socket.org"

Using VS 2010 with Teradata 14.x client.   Issuing teradata queries from c# and capturing the results.   I am noticing that I can't issue a drop table from dot.net.   It doesn't give an error for a drop table it just doesn't execute the command.   I am "cmd.ExecuteNonQuery" . Anything else to try?

My company is running an R-Studio Server Pro on a Red Hat Linix 6 platform (64bit) and a Teradata 14 RDBMS. When trying to connect via RJDBC, I get an error that seems to be well known in the forums, but the standard recipes for resolving the issues don't help. Here is how I connect to the Teradata DB:

I have a linked table in my Access database to a table on our Teradata server that works fine, but I want to limit the rows coming across the wire so I created a pass-through query using the same ODBC connection.
For some reason, it returns different results without the most recent data.  The row count of the table is lower.


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. 


As the title says, the driver fails connecting on a RHEL 5-64bit system in a custom directory, running tdxodbc64, and gives the above error, like so:

I'm trying to get my SSIS environment connecting to Teradata after installing some Oracle tools, and it's not going well.  I've reinstalled Attunity's drivers, the Teradata tools, and the Teradata ODBC and .NET drivers, and my BIDS environment still says No connectivity to Teradata is available.

Often it is necessary to create a connection to the Teradata database and want to automate this process.
Use teradata ODBC Driver

I'm new to TeraData and need to call a Macro from C# using the .Net Provider.
I wasn't able to find any sample code, and not sure what the correct way to do this.
I don't want toe send "exec macroName(param1)" from my code, I would like to have something similar to the way i call procedures.

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:

Hi Experts
I am pretty new in Teradata, I have just installed Teradata Express for VMware
Can I configure this Teradata environment to connect from my Laptop? And not from inside of the VM?
Please can you share the procedure to configure this environment?
Thank you

I am facing this issue on Red Hat Linux Server while connecting using R onto Teradata 14.10.
I am using R-3.2.1 and Teradata 14.10 client. Also installed RODBC package.
Below is the error I am noticing:
$ R
> library(RODBC)
> db <- odbcConnect("testdsn", uid = "userid", pwd = "password")
Warning message:

Using com.teradata.jdbc.TeraConnectionPoolDataSource for pool based datasource in a application. Below are the configurations..
       <property name="minPoolSize" value="2" />
        <property name="maxPoolSize" value="60" />
        <property name="maxStatements" value="100" />

Getting "305 NOREQUEST Specified request does not exist." Error while creating Volatile table through SAS connection string.
What could be the issue ?
Thanks in Advance.

Hello All,
We are trying to setup Kerberos client on a Teradata VM. We have followed all the steps mentioned in info.Teradata

Hello Teradata experts,

I'm now working on optimization of loading of data into Teradata.

Hi All,
My name is Srinath I have installed TTU 13.10 in linux Server . For the first time of installation it was successful but we had few issues so had to uninstall or remove the TTU and TPT and install in different path. 

Just wondering why the string function LEFT() doesn't work with the Teradata .NET provider in both versions of SQL Assistant V13.x and v14.x.  It works perfectly well when use ODBC with SQL Assistant the same function.  I had to convert to substr() to make it work for both ODBC and Teradata .NET.  Unfortunately I'm forced to use ODBC at the client side. 

Hi Everyone,

It is a strange issue, I am loading few records from SAP source to Target TD table through Informatica after ABAP generation. Now the issue is that every time I load with any range of Data reading from param file, its always the first 2 records gets rejected.

Hi All ,
I m trying to connect to TERADATA server from SSIS using .Net Providers\.Net data provider for TERADATA. After giving the server name and credentials i m getting the below error.    

unable to connect to Teradata server from ssis

Please help.  Vhari, you helped me on this in the past and I'm hoping you can help here as well.

Hello all,
I have an intersting dilema. We need to create some UDFs which call a C program. This C program will perform some processing on the incoming data and then perform a lookup into a Teradata table. The data will come back and the UDF will in turn go back to the SQL and then perform the same function for the next row.

Hello,  I am using a Data Virtualization tool, Teiid Designer, to create a teradata "source model" which is fetching metadata for each table I select for the model.  This connectivity is supported using JDBC connection URL  "jdbc:teradata://database/tmode=ANSI".

I'm new to the forum.
I am trying to connect to Teradata Database via Teradata ODBC in Excel 2013 (32 bit).
When I click on the Teradata DSN I keep on getting the following message : [Teradata][ODBC Teradata Driver] Not enough information to log on

For Teradata Aster, we can use SQL-H to pull data from Hadoop to Aster.
After some searching, I am still not able to find any documentation (syntax details, etc.).
Does anyone have a link to official TD doc?

Hi All,
one of my customer sent me a query generate by JDBC driver to get some metadata. the execution of the query is not performant. I analyse the query and find that the where condition on databasename and tablename are write with LIKE (below I report only the where condition part of the query):

I'm on a windows 7 in 32 bits and I use Eclipse IDE for Java EE developper and I install Birt framework manually.
I want to use a datasource connected with a teradata database.

[nQSError: 16001] ODBC error state: 08S01 code: 4 message: [Teradata] [Unix system error] 4 Unable to get catalog string
can someone please let us know what that message means?

We have OBIEE Linux platform and recently one of our applications have hogging thread alerts with below error message:
[nQSError: 16001] ODBC error state: S1000 code: -3156 message: [Teradata][ODBC Teradata Driver][Teradata Database] Request aborted by TDWM. Exception criteria exceeded

When do I want to use each of these? If I have a source OLEDB system and am continually moving data from there to Teradata via scheduled SQL jobs on the Teradata side, I like that OLEDB Access supports FASTLOAD functionality. Are there limitations to OLEDB access module that would prevent me from using it?

Where is the README file for the ODBC Driver Suite 15.00.04 for Windows?
I looked in the zip file but there is no README file. Should there be one?

Hi All,
I am trying to connect my Teradata server through JDBC Driver in java to my Web Application. I am using the following Connection String:
String connectionString ="jdbc:teradata://DatabaseServerName/DATABASE=xxx,DBS_PORT=1025,USER=xxxx,PASSWORD=xxxxx";
I am getting the following error:


I was able to connect to aster DB via java application using the jdbc:ncluster connection string. Is there a way to use connection pool in my Java code for this aster database connection?


I have on SQL2008 server linked server Teradada. I select from this linked server and for many tables is ok, but
when I select some tables I see error:

we have a jdbc data source configured in sap netweaver java server,which connects to Teradata( the jdbc driver version is
we have an ejb consuming that data source.
the java server is running on windows.

Hi I'm new to using Studio Express. I'm wondering what I would need to download and how to configure a basic sample data conneciton within Studio Express.
Any help is greatly appreciated! Thank you.

Hi All,
Can someone help me to find the solution for below issue? Thanks!
When ever new business users are created, they are provided with initial password which they need to reset the first time they login to Teradata.

I want to connect to Terdata from my .net application using .net ODBC provider. I have installed the TeraData ODBC adapter. But I am not able to connect. Please help is thata anything I am missing here?