350 - 400 of 837 tags for Connectivity

Trying to create Entity Framework Model in Visual Studio 2010 but it seems to hang at the point where I select the tables and hit Go. I'm able to open the connection and see the objects in TerraData but never finishes this dialog. 

 

Any help is greatly appreciated. 

We are upgrading our database from V12 to V13.10.  In preparation for our upgrade, we have upgraded our TTU components to 13.10.  We have also installed Viewpoint to replace Teradata Manager, TDWM, ect.

I recently joined business objects team for report development activity. my database server is teradata server.How can i connect to teradata server from business objevts tool? what drivers i needed , & from where i can download them? what steps i should follow for connectivity?

Hi,I have used the Ibatis Teradata plugin in Rational Application Developer.I have written a simple sql select query which is mapped in a SQL Map.Then i have created a DAO from the SQL Maps.When i run the JUnit test using the build.xml i am getting the following exception.

Hi,

 I am trying to compile stored procedure and I am getting mt.exe not found error. COuld you please help me with it:

Database - 13.02 (Teradata 13 express edition)

VC++ Express 2010 - installed

PC is 32-bit operating system.

 

Thanks

 

 

Hi, I'm trying to connect to TD server via CLIv2 console application using LDAP logon mechanism, but I get the following error: CLI2: BADLOGMECH(507): Requested logon mechanism is not available.

I have set up LDAP option by passing "LDAP" string to DBCAREA logmech_name variable:

I am having problems with the install.

I am doing the complete install but messes up visual studio packages.

 

Has anyone had issues with installing the .NET data provider on Windows 7 and VS 2010?

Hi.

We have a Teradata 13.10 backend installation and a front-end installation on MS SQL 2008, using Microsoft SSAS. Due to our data model and a minor "design-glitch" in MS SSAS, we have been forced to make a MOLAP solution, generating materialized cubes on the SQL server.

Hi,

Is there any Excel connector availble to execute the query from Excel for teradata?

It should support to user to runs the query from excel & the result should populate in the same excel / other excel workbook from predefined column & row

 

Thanks in advance

Bajju

I was trying to do following with Teradata JDBC (14.00.00.09)

String sql = "SELECT DISTINCT CASE WHEN 'All' = ? THEN LOV.VAL  ELSE ? END  FROM  LOV"; 

ps = conn.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY );

 

And it gives me following error:

 

I am trying this tera data Sql this is for curent month date.
select cast(current_date as date) - (extract (day from cast(current_date as date)) - 1) + interval '1' month - 1

Can anyone provide information as to the encrytion strength of BTEQ/Fastload/Multiload etc when DATAENCRYPTION is ON?

Hello!

I have need to connect to a Teradata source to view (read-only) or import data into a single table of hosted FileMaker Pro database. Although Teradata provides ODBC drivers for most platforms, there is no such driver for the Mac. Actual technologies makes approved ODBC drivers for FileMaker, but nothing approved for Teradata. 

Hi,

I did install Teradata 13.0 drivers on 64 windows setup.

I got below DLL's in location

C:\Program Files\Teradata\Client\13.0\Teradata Parallel Transporter\bin64

loadop.dll

pxicu.dll

exportop.dll

opcommon.dll

streamop.dll

telapi.dll

telapi.lib

updateop.dll

Hi,

I did install Teradata 13.0 drivers on 64 windows setup.

I got below DLL's in location

C:\Program Files\Teradata\Client\13.0\Teradata Parallel Transporter\bin64

loadop.dll

pxicu.dll

exportop.dll

opcommon.dll

streamop.dll

telapi.dll

telapi.lib

updateop.dll

Hi - I'm new to posting to forums.  I'll do my best to describe my problem.

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

Hello folks,

                I am new to Teradata , and was hoping to connect to the Teradata DB using the .net provider.

However I am unable to connect. I am getting a invalid connection string error.

 

I was wondering if you have to follow certain steps to connect using the .net provider ?

 

Hi all;

We're now adding OLAP support to our reporting system and I want to make sure we handle Sql Server, Oracle, & Teradata out of the box. Where can I get information on how to access Teradata from both .net and Java?
 
thanks - dave
 

Hi all,

 

i am trying to load data in my database using informatica but getting the error that is placed below:

 

 Execute Direct -- [Teradata][ODBC Teradata Driver][Teradata Database] An owner referenced by user does not have INSERT WITH GRANT OPTION access to BATABASE_NAME.TABLE_NAME.ID.Unable to get catalog string.

Hello everyone!

We are in the process of upgrading our warehouse from v12 to v13.10.  Our first task is to roll out the ODBC to various users to see if things are still happy. 

Would it be possible for the next release for JMSUC to NOT hardcode the Metadata Tables DDLs and names ? I found it quite inconvenient to integrate in an existing EDW infrastructure, which follows strict naming conventions and database objects structure...

Our users have been receiving the [8017] The UserID, Password or Account is invalid error more frequently lately.  Normally, I can reset the password and they are fine.

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

Hi,

I am having issues installing Teradata SQL assistant on my work laptop. We have Teradata 13.10 installation package and my system has Windows XP 2002.

None of my colleagues are able to help on this issue. So, I am posting it here.

Hey Guys...

I am connecting excel to teradata through ADODB connection and getting the results in the recordset.

The thing is, I have a slew of SQL's to be run around (10-15) which need not be sequentially. Using the below method, I am able to run each SQL query one after the other,

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

I am trying to configure the Teradata sql assistant to view the SAS datasets. Whether it is possible to view SAS datasets in Teradata sql assistant. Please let me know.

Hi,

New sign-up, so apologies if this is not in the correct forum!!!

We have just upgraded to 13 from 12 and I have noticed a small anomaly which I was wondering if anyone else has encountered.

I have .Net framework 4.0 installed.

where do we get TD .Net data provider for 4.0 version? I don't want to downgrade my app to 3.5 or less from 4.0.

Hi,

I am new to using Teradata and am trying to use it with vb.net to build a user app.

Can anyone please tell me how to call a teradata sp from vb.net (Visual Studio 2005)

I have a simple sp with input and output parameters, something like:

Does CLIv2 allow you to abort a request (using function DBFABT) using a session that is different than the one used to submit the request? Although the two sessions will be running in a separate thread or process, I'm assuming the session performing the abort has access to the relevant session id and request id.

Have had success establishing and using SQL Server linked server (SQL Server 2008 R2) connected to Teradata using OLE DB Provider for Teradata (Version 13.10.0.1) using native Teradata (TD2) authentication.
 
Our Teradata data source will transition to use LDAP authentication, so we must adapt our linked server for this new authentication method. (To prepare for that transition and to conduct tests, we’re provided access to a Teradata database that requires LDAP authentication.)
 

Hi all,

I have a problem connecting to Suse VMware image for Teradata database. It works OK at work place. But at home, when I am on VPN, I can't access the database from the Windows 7 host. Does anybody have any ideas as to how to solve this?

Thanks

Sreenath

 

 

Hi,

We need to install teradata libraries on UNIX server (AIX-6.1).

The version of Teradata is TTU12.

Please let us know the steps for the same.

 

Thanks,

Jatin

hi

 

I am using Teradata jdbc driver 13.00.00.10, and trying to upload a flat file with 100 million rows to teradata.

I start off with a clean table.

First I tried to iterate through the entire file, do addBatch() for each of the rows, and only in the end do a single executeBatch():

I am unable to connect using the following snippet of code:

drv = JDBC("com.teradata.jdbc.TeraDriver","./TeraJDBC/terajdbc4.jar")

conn = dbConnect(drv,"jdbc:teradata://db1/TMODE=ANSI,CHARSET=UTF8",user="user1",password="pswrd1",dbname="test_db")

I get the following error messages:

 

As a part of our Teradata evaluation effort, I have created a java ETL process which attempts to batch load data from an Oracle instance into a Teradata 13.10 Express VM instance.

Has anyone else seen this? Currently if I run up a connection via the JDBC driver under a 64bit JVM of 32bit JVM under a 64bit Ubuntu I get an unexpected hang. Under a 32bit JVM on a 32bit Ubuntu install everything works fine. The really weird thing is if I run the connection thread through strace it appears to be spinning never really connecting.

I've contacted many people within my company who use SAS, but I can't figure out how to resolve my issue and am running out of places to turn.

Background:

   Datastage8.1 install SUSE 10 64-bit

   Teradata install vm on SUSE 10 64-bit

In the DS server i install the TD ODBC driver. also used the ./adhoc can connect to the TD  and can execute the SQL command. but i don't know two the configuration the ODBC and the env on the DS server?

 

Accroding to the explanation of this error in the Messages document,

Hi Guys,

I have installed the teradata 13 client in my machine (Win XP). Whenever i run a query in SQLA  it gives the error msg

'object reference not set to an instance of object'

If any of u people encountered this error kindly help me out the solution ASAP    thanks

Using Sql server and connecting to Teradata 13.0 using 64 bit .net bring data FROM Teradata - everything is fine
When I try to do an Update to my table on Teradata - I have nothing that lets me specify the Database or Table I want to update - but I get a response saying everything completed successfully.

Hi,

I am using .NET Data Provider to connect from Microsoft Analysis Services (BI Studio 2008) to Teradata. In general that works fine and I connect to Teradata database systems.

But there is a specific Teradata system (Teradata 13.10) that I am unable to connect using .NET Data Provider.
I always get the following error message:

[TeraGSS Security Library] [115022] Exception occurred in TeraGSS layer. See inner exception for details.

I am using the following connection String:

If this isn't a true connectivity query, please forgive.

I've mounted the Teradata Express for VMware image and can access the evaluation DB from within VMWare Workstation.

I'm now attempting to connect to the Teradata database on the VM over my local network to query the DB with the .NET provider. Can someone point me in the right direction on how to connect to the VM database?

I am getting the following error trying to use this with DBI 1.6.16 on an AIX app node, using the Presicient 12.001 GPL driver:
'DBD::Teradata::st execute failed: Failure 7968: FD622_Determine_Date_Range_SP:The recipient of the result set does not support dynamic result sets.'

Pages