#DateForumTypeThreadPost
6921 Nov 2014 @ 08:52 PSTToolsReplyTTU 15 Installed, SQL Assistant ErrorAnother option, if the above did not help, is to connect using Teradata.Net rather than ODBC. You will need to install the .Net Data Provider for Teradata, which can be downloaded from this site. ...
6831 Oct 2014 @ 12:46 PDTToolsReplySQL Assistant problemStarting with SQL Assistant 15.0 the option "Submit only the selected query text, when highlighted" now applies to Import also.
6731 Oct 2014 @ 12:44 PDTToolsReplySQL Assistant v.15.00 Keyboard Shortcut problems - CommentIn 15.0 Ctrl+D is used to remove Bookmarks while Ctrl+/ is used to toggle comments. The latest efix also allows you to use Toggle Comment to comment the current line when no text is selected. (I...
6631 Oct 2014 @ 12:40 PDTToolsReplyBug in SQL Assistant 15.00In 15.0 we changed the shortcut for Toggle Comment to be Ctrl+/. This is more consistant with other apps and allows us to use Ctrl+D to remove (Delete) all bookmarks. Although almost anything can...
6531 Oct 2014 @ 12:28 PDTToolsReplyIssues in querying Informix Database using Teradata SQL assistant via ODBCThis was first reported a year or so back. When I traced the application I found that the Microsoft .Net Data Provider for ODBC was specifying a length of 2 for the data buffer when retreieving ch...
6431 Oct 2014 @ 12:03 PDTToolsReplyError Starting SQL Assistant v14.10.0.4If this still isn't fixed email me at mike.dempsey@Teradata.com. It is actually a problem with your Windows setup rather than with SQL Assistant, but it is simply a matter of updating your reg...
6331 Oct 2014 @ 11:56 PDTToolsReplySQL Assistant FavoritesThey are stored in files called *.syn [for the built in lists] and *.qbs [for lists you create] in the directory: <username>\AppData\Roaming\Teradata\SQL Assistant
6231 Oct 2014 @ 11:52 PDTToolsReplySQL Assistant key not found errorI vaguely remember fixing this a long time ago but without the detail from SQLError.txt I can't remember which efix it was in.  The latest version should contain the fix however, so downl...
6110 Oct 2014 @ 04:23 PDTToolsReplyTTU 15 Installed, SQL Assistant ErrorThat dll is the Visual C runtime for C applications compiled with VS 2012. SQL Assistant is a .Net app rather than a C app so it doesn't use that dll. The problem must be originati...
6007 Oct 2014 @ 01:19 PDTToolsReplyTDSQLA 14.10 - Cut & Paste IssueThat bug was fixed a while back - in 14.10.0.4 I think. You will need to upgrade to a newer efix version. The latest version is 14.10.0.8 in the TTU 14.10.15 suite (9/9/14)
5918 Aug 2014 @ 11:55 PDTConnectivityReplySQL Assistant and ORA-12154 on 64-bit Windows platforms (but not on 32-bit)BTW Teradata does not install any Oracle components. It is up to you to install the appropriate Oracle client tools (.Net Data Provider [prefered] or ODBC driver [as a last resort]) SQL assistan...
5818 Aug 2014 @ 11:45 PDTConnectivityReplySQL Assistant and ORA-12154 on 64-bit Windows platforms (but not on 32-bit)On my system I use the following file: C:\OracleXE11g\app\oracle\product\11.2.0\server\network\ADMIN\tnsnames.ora but the name will depend where you installed Oracle (or the Oracle client) and wh...
5705 May 2014 @ 12:16 PDTConnectivityReplyUnable to connect to teradataThe version of SQL Assistant that you are running is almost 5 years old. The latest version for TTU 13.0 [still old] is 13.0.0.16. You can however use newer versions of SQL assistant with older ve...
5614 Apr 2014 @ 10:21 PDTToolsReplyShow View Definition - Teradata SQL Assistant 14.01.0.04Are you connected to the data source? I'm not aware of any problems in that area, but it will only display some of the Tree menus when you are connected to that data source.
5514 Apr 2014 @ 07:52 PDTToolsReplySQL Assistant Copy Errors 14.10This problem has been reported in the past. It seems that Microsoft changed something related to the clipboard such that attempts to access it through COM are failing. In order to work around the ...
5425 Mar 2014 @ 12:28 PDTConnectivityReplyTeradata SQL Assistant with .net data provider error on start upVersions 13.10.x.x of SQL assistant was built with version 13.1.0.0 of .Net Data Provider for Teradata. You must either install that EXACT version of the .Net provider, or install a later version ...
5327 Jan 2014 @ 06:41 PSTToolsReplyTeradata SQL Assistant 14.10 functionality changed This issue is caused by the way the parser sees the the text. In 13.11 we used to replace the Query with only the part of the Query that you were executing. This was a proble...
5216 Dec 2013 @ 05:43 PSTConnectivityReplyConnecting to Teradata.netTo connect via Teradata.net you would need:     sqla -p Td -c "dbs\user\pwd"
5115 Oct 2013 @ 05:36 PDTConnectivityReplyProblem with teradata SQLA 13 'object reference not set'Please send the SQLAError.txt file to mike.dempsey@teradata.com. Even though it appears to be working now I would like to look into the cause. Also please let me know whether you were connected u...
5011 Oct 2013 @ 02:17 PDTToolsReplyTeradata SQL Assistant - Database Explorer WindowWhen you deleted the config file did you make sure that no copies of SQL Assistant were running at that time? (When it closes it will re-create the file)
4904 Sep 2013 @ 10:36 PDTToolsReplyTeradata SQL Assistant - Database Explorer WindowIt sounds like the config file for the tool window(s) has been corrupted. Try deleting DBTree.config or DockMgr.config (depending on which version you are using now). These will be in: c:\Docume...
4803 Jun 2013 @ 01:56 PDTConnectivityReplyWindows system, when use Teradata SQL Assistant and TSET connect to a Teradata Database, it alerts "no default driver specified"I think something is missing from this question. I assume these are 2 completely unrelated statements:   SQL Assistant gives an error message   TSET gives an error message ...
4709 Apr 2013 @ 03:30 PDTToolsReplySQL Asst and Windows 7If it applies to other tools as well this may not be it, but you might want to check what it says in UserOptions.config. One possibility is that the window location is not within the visible ...
4607 Mar 2013 @ 06:07 PSTToolsReplySQL assistant v13 Query builder emptyI have heard of this before but never figured out how it occurs. It seems to be a problem with installing or copying the files on your system. (Most likely a permissions problem) There should be...
4504 Mar 2013 @ 06:29 PSTToolsReplySQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.11.0.04I know there is a problem with Windows 8 and the VB6 Shell command (Teradata Administrator uses VB6) but I wasn't aware that there was any problem with Windows 7, or .Net. I could maybe undestan...

Pages