100 - 150 of 1036 tags for Connectivity

Pages

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:

Hello.
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.

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. 

 

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:

Hello.
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.

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

Hi,
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" />

Hi,
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".

Hello,
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?
 
thanks

Hi All,
one of my customer sent me a query generate by JDBC driver 15.00.00.20 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):

Hi,
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?
Thanks!

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:

Hi,

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?
 
Thanks

 

Hi!
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:

Hi,
we have a jdbc data source configured in sap netweaver java server,which connects to Teradata(13.10.07.28). the jdbc driver version is 15.00.00.20.
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.

Hi,
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?
Regards,
Lakesh

Hi all,
I am currently trying to configure Teradata 15.0 client on a RHEL7 machine.  First I installed tdicu, TeraGSS, then tdodbc.  Then I edited the .odbc* to my Teradata credential and DBC etc. The .odbc.ini and .odbcinst.ini are at my $HOME dir.
When I test the connection using tdxodbc, the following error return:

Hi, guys!
I have been breaking my mind the whole day trying to do the following thing.
My native language is Spanish and I need to import some words which have accents. I got to upload those words properly in Teradata setting the upload to UTF8.

I have tried connecting to the AMC many times but I am unable to connect to AMC. I typed the IP address  and tried and still did not work . I tried connecting from different locations, using different browsers and still the same result..  I do not use VPN at all. I even downloaded the Aster software one more time and tried but no change then either.

Hi All,
Good Day...
Can some one help me to set up ODBC Driver for Teradata options (Especially, Password & Data Encryption and Authentication Mechanisms) globally and these optios should not be overwritten by user at ODBC Data Source Administrator dialog box.

When connecting TD14 with Oracle 11 or 12, I've read that USL 15 allows connecting them with a portal server in between. When creating the foreign server, hosttype would normally be 'portal' as that's what's in the middle between TD and Oracle. In what scenario would we use hosttype 'oracle'? 
Thanks
Peter