0 - 50 of 71 tags for sql assistant


1. You need to change the dbc password by running tdc-start to enable port 1025 which is used by ODBC and CLI connections
2. Also check your inbound ports to make sure you have opened port 1025 for your IP address

I am using SQL Assistant, and i want to change settings for multiple answerset. Currently its opening in multiple tiles, making 4 tiles - 1 for Query,1 for History and 2 for Answerset(more depend on queries). How can we merge Answer set in one tile with multiple Tabs, the way multiple Query window works. Please guide.

Hello all -
 I just now got Studio Express VM up and running on my Win7 laptop.  This article (http://developer.teradata.com/database/articles/introduction-to-teradata-express-for-vmware-player) indicates I should be able to run SQL Assistant in the VM but I do not know how to start it.  Can anyone help with this?

Good Afternoon All,
Hoping someone can help me out with an issue that's causing me a great deal of frustration...

I'm geting "Not enough information to log on" error message when trying to connect using the Teradata Python module, pypyodbc or SQL Assistant ODBC.
Using Teradata Python:
session = udaExec.connect(method="odbc", system=***,username=***, password=***);
*** - hide the real values.
Using pypyodbc:

You know how SQL Assistant will display a hyperlink in the answerset grid for BLOBs and CLOBs?  Is there any way to do that yourself?  I have file locations stored in a table in a VARCHAR column like "\\servername\foldername\MyFileName.txt".  Any way to get SQL Assistant to display it a

I've upgraded to Teradata SQL Assistanct to 14.01.  I'm getting a "system failed to initialize" error. I can run sql but can't view the db tree. Found this in an old post but the solution of deleted the dbtree.config did not work.  Any help would be greatly appreciated.

This article is intended to help users as they transition from Teradata SQL Assistant to Teradata Studio Express. Included are some of the more frequently used SQL Assistant features along with a detailed 'How To' guide for the same features in Studio Express. Note: this article is relevant for Studio Express 15.10 or later.

If I wanted to suggest some new features for SQL Assistant, where would one go?

Some times I get the error "unable to load the saved database tree information" when I open teradata sql assistant and I loose my saved database tree. My sql assistant version
How to solve this problem?

I am able to query, but under DBC in the Database Explorer window, I do not see the list of tables.
Many thanks.

Hi there,
When running queries in a Query Tab, I remember that in previous versions, the colour of the tab would change to indicate that a query was running, and it would change again to indicate when the query had completed.

I have Windows7 Operating System and IE verison 9. When I try to install TD SQL Asssistant, it give me this error:
MDAC 2.6 requires Microsoft IE 4.01 Service Pack 2 or later.
I have IE version 9 on my machine. Can you help?
Thanks Devi

Can anyone tell me where the favorites are stored? I am using two instances of SQL Assistant (one on laptop, one on VM) and would like to merge both.

I cannot start SQL Assistant, and the error message is:

System.IO.DirectoryNotFoundException: Could not find special directory 'My Documents'.


Since it appears SQL Assistant is still available only in 32-bit version (TD 14/15 clients), it attempts to connect to Oracle's 32-bit ODBC.
On 32-bit Windows platforms everything is peachy.

Would like to know if it is possible to show tablenames in mixed case (i.e., MixedCase instead of MIXEDCASE) in the Database Explorer window. If so, where and how is this option set?
Thank you!

(version 14.10 of SQL Assistant)
Is there a bug with this option?
Tools, Options, Query: "Submit only the selected query text, when highlighted" 

Teradata Studio Express 15.00 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems.


This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 15.0.
With the exception of a few minor enhancements to support new Teradata Database 15.0 features these changes all relate to the Query window or Query execution.

It has become very slow fetching an answer set (serval seconds per row) during last several days using Teradata SQL Assistant. I never experienced this problem before. Rebooting the computer does not help. People use Teradata SQL Assistant in our office pritty intensively, but no one has ever experienced this problem. Please help.

SQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.10
I am unable to Define ODBC Data Source in Teradata Sql Assistant.
File Not Found
Unexpected Error . Refer to the following file for details :
c:\Users\MYUSERNAME\AppData\Roaming\Teradata\SQL Assistant\SQLAError.txt

I've recently begun working with Teradata Studio Express after about a year of working with SQL Assistant. My primary use of Teradata is for BI applications such as ad-hoc reporting.

This may seem like a trivial matter, and it certainly doeesn't prevent me from doing my job, but I thought I'd ask anyway.  I was recently upgraded from my super old and comfy version of SQL Assistant to V 13.11.  Since the upgrade, when I paste my code into the query window, the scoll button on my mouse no longer functions.

Teradata Studio Express 14.10.01 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems.

I installed Teradata V14 for VMWARE on my Windows 7 (64 bit) Machine. Then I installed .Net provider, ODBC driver (Both 64bit and 32bit) on my Windows to Connect Teradata using Teradata SQL Assistant.
But when I try to connect Teradata from SQL Assistant I get the error Teradata Server is not accepting connections.

We've installed the "SQL Assistant", but when we want to view the history window this is disabled.
Some web sites told us we need to run the AccessDataBaseEngine.exe and we did it, but It didn't work.
Could you help us with this?

Hi All,


I am using SQL Assistant as my workbench for TERADATA.

Recently, my system crashed and i had to setup the SQL assistant again.

SQL history was available in a MS Access DB file and i was able to save a lot of time as i had backed it up earlier.


However, i had a tough time with the following :

Hello All,
I have created a dummy table and inserted one record in that table. When i simply select that record it gives me unwanted leading space in the answer set. 




SELECT '(' || TO_CHAR(a+1) || ')' FROM dummy;


Why do views/tables that are no longer found continue to display on my Database Explorer? How can I remove them?

Is there any particular reason that a user's 'Change Password' option would be grayed out in SQL Assistant -> Tools ?

Teradata Studio Express 14.10 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems.


This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 14.10, and highlight some existing but lesser known features.

This article assumes that you are already familiar with the features in SQL Assistant 14.01. If not, you may wish to read the following articles first:

Hi Guys,
I'm trying to install SQL, but I can not.
it installs Libraries, .Net Data Provider, CLIv2, GSS and ODBC Driver, but not SQL Assistant.
Whats going on?

I currently use SQL Assistant to write Teradata tables to existing MS Access tables by using the SQL Assistant "Export Results" File option. The problem is that I must manually direct the output to the specific table in SQL Assistant and there are 30 tables that I need to reload each month.


This article will describe a few simple features of Teradata SQL Assistant that can help you to create an eye-catching report or email.

I am trying to import some data and it keeps giving me a format error. Is this because I am not including the column headers? Thanks for the help!

I use SQL Assistant to connect to DB2 databases on the z/OS platform (in addition to using it for Teradata, SQL Server, and Oracle). In some of our DB2 databases, user access to tables is provided via alias instead of views. Trouble is, SQL Assistant does not show aliases when expanding a DB2 database.

Does Teradata capture the response time that it takes when a user opens the metadata within Teradata's SQL Assistant's Database Explore? 

Secondly, can Teradata be tuned to get better responses to these Database Explorer queries?



This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 14.01. The focus of this release is on usability and the introduction of Charting and the direct editing of Table data.

Upgraded SQL Assistant JE to Studio Express and everything is great until I try and copy text from the Scrapbook.  At which point I find out that "Copy" is bound to "Ctrl+Insert". I scramble to the preferences to change the binding and find out that "Copy" is bound to both "Ctrl+Insert" and "Ctrl+C" but unfortunately the latter doesn't work.

Is there going to be a release of SQL Assistant that can be installed on Windows 7 64bit?  The Java version doesn't work very quickly and is cumbersome to use.



When using BTEQ or SQL Assitant to upload data into tables, I'm only getting about 2 records per second speed. Unfortunately, I don't have access to Fastload. I know its not the network as my down speed is blazing and Oracle is uploading normally.

I have installed Teradata 13.0 express edition under OS Window7, but unable locate SQL Assistant program. Try to search at C:\Program Files\Teradata\Client\13.0\, not file/folder name by SQL Assistant.



Teradata Studio Express is an information discovery tool that retrieves data from Teradata and Aster Database systems and allows the data to be manipulated and stored on the desktop. It is built on top of the Eclipse Rich Client Platform (RCP).

There is 2 options that i really misses in the Setup under "Tools -> Options - > History".

1) Save only successfull queries.

2) Do not save Explain.

Any possibilities for getting these one's?



Anyone know why I would be getting the below error during query execution? I'm assuming it has something to do with the grid that it is trying to populate with the results from the query.

SQLA Version:
Driver Version: Teradata.Net
System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: value
at FarPoint.Win.Spread.Model.DefaultSheetAxisModel.SetSize(Int32 index, Int32 value)
at FarPoint.Win.Spread.SheetView.SetColumnWidth(Int32 column, Int32 value)

I am using Teradata 12 SQL Assistant, In status bar most of the time I am getting some numbers which are not relevant to the command which I have executed successfully. Like

I have a table with single column and 2 records. When I drop the table, The status will be like " Completed, 15 Rows Processed"

SQLA JE 13.11 on Vista does not want to run as a normal user account. It will run under a local admin account, but when run as a normal user it just hangs on the splash screen. Any ideas?