Toad Data Point - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
What's new in TDP 4.3
Making Effective Use of TDP
How to query Salesforce data
How to use Data Profiling
How to find the license number
Contact Us
Technical Support
View All

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2194
So it appears that Toad doesn't recognize that "rankichap" is being created by the first part (255815)

Toad Data Point doesn't recognize that "rankichap" is being created by the first part of the query, and this doesn't exist yet. This query runs fine from the Hive CLI, but not in Toad Data Point. If there's a way to override Toad's SQL ...

Product(s): Toad Data Point
Last Updated On: 5/18/2018
(0 Ratings) 4 views
Invalid data source definition: Invalid response. Ensure you are connecting to the correct OBIEE URL (255797)

Following documentation to connect to a OBIEE server one may see the error: Data Service Database Error. Invalid data source definition: Invalid response. Ensure you are connecting to the correct OBIEE URL. The issue happens ...

Product(s): Toad Data Point
Last Updated On: 5/18/2018
(0 Ratings) 7 views
Video: Toad Data Point Professional Overview (255654)

This video goes over the Toad Data Point Professional edition. Professional Overview.

Product(s): Toad Data Point
Last Updated On: 5/17/2018
(0 Ratings) 13 views
Video: Toad Data Point Base Overview (255652)

This video goes over some of the Toad Data Point base edition features. Base Overview.

Product(s): Toad Data Point
Last Updated On: 5/17/2018
(0 Ratings) 13 views
Can Toad Data Point connect to Presto? (255617)

Can Toad Data Point (TDP) connect to Presto? Yes, a native ODBC connection using a "Teradata Presto ODBC DSN v1.1.16.1026 (64-bit)" driver, has worked OK. Just make sure you've ran a successful test in your "ODBC Data ...

Product(s): Toad Data Point
Last Updated On: 5/16/2018
(0 Ratings) 5 views
[IBM][iSeries Access ODBC Driver]Communication link failure...User xXxX on server xXxX has been disabled - When accessing AS400 (255416)

Toad Data Point (TDP) 3.8 was working just fine, but after installing 4.3, the issue came up, and now even 3.8 has the issue. One can run a query, but, for the second one it says that the account has been disabled. Quest.Toad ...

Product(s): Toad Data Point
Last Updated On: 5/10/2018
(0 Ratings) 7 views
Toad installation error: The installer was not able to complete successfully. (189788)

Unable to install product suite. When trying to install Toad, getting the error below. The issue happens on the .EXE file, but can also happen on the .MSI file. ERROR: "The installer was not able to complete successfully. RegisterComplete returned error code [0x80070005]. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/7/2018
(1 Ratings) 12696 views
Can't login to Toad. What is the Toad password? Where do I get my login credentials? What is my user name and password? (80949)

Cannot or unable to login. What is the Toad password? Where do I get my login credentials? What is my username and password? The account is locked so it needs to be unlocked and the password reset. There is a prompt ...

Product(s): Toad Edge, Toad for SAP Solutions, Toad Data Point, Toad Data Modeler...
Last Updated On: 5/4/2018
(2 Ratings) 15493 views
MySQL Database Connection (254424)

Try to connect to the MySQL database, Toad Data Point appends my local machine name to the end of my username; Access denied for user 'user@hostname.com' (using password:YES). Possible the connection should be done using SSL not TCP. ...

Product(s): Toad Data Point
Last Updated On: 4/24/2018
(0 Ratings) 2 views
"custom 6" toolbar is causing issues in Toad Data Point (238605)

When using Toad Data Point (TDP) Configuration Wizard to apply what's in the nex image, the "custom 6" toolbar shows up: And because of that, one sees a duplicated customized bar, and get extra customized menus when using the Editor as a separate / detached window. ...

Product(s): Toad Data Point
Last Updated On: 4/24/2018
(0 Ratings) 1 views
Invalid data source definition: Could not resolve host for client socket (254418)

Trying to connect to Hive 1.2.1, Using Kerberos, One gets the error message: "Invalid data source definition: Could not resolve host for client socket" in Toad Data Point (TDP) 4.3 Incomplete User For user name, one cannot ...

Product(s): Toad Data Point
Last Updated On: 4/24/2018
(0 Ratings) 4 views
Displaying logs causes Toad Data Point to hang temporarily (254143)

Displaying logs of scripts executed on Toad Intelligence Central (TIC) causes Toad Data Point (TDP) to hang temporarily. When a script is published on TIC and is scheduled to run every few minutes, it generates considerate amounts of log files: ...

Product(s): Toad Data Point
Last Updated On: 4/24/2018
(0 Ratings) 4 views
Task / Script scheduling error Exception: (1,1306):WnfStateChangeTrigger: (232158)

When scheduling an automation task, the following error occurs. Operation completed with errors. Click the button for more details. Server: computer name. Exception: (1,1306):WnfStateChangeTrigger: When Toad Data Point ...

Product(s): Toad Data Point
Last Updated On: 4/23/2018
(2 Ratings) 415 views
How to add a nested Select statement using the Query Builder (254284)

In the Query Builder, how can a user add a subquery to the FROM clause to create a nested Select statement? Click the "Add a subquery to the FROM clause button". This will open a subqery window that will allow users to create ...

Product(s): Toad Data Point
Last Updated On: 4/20/2018
(0 Ratings) 3 views
Issue when opening TDP v3.2 automation script in v4.2.1 (233761)

Issue when opening and running Toad Data Point v3.2 automation scripts in v4.2.1 that contain "If Condition" actions: "Activity 'Execute_File_script' validation failed: Toad has detected some symbols within the SQL indicating you might be using bind variables. ...

Product(s): Toad Data Point
Last Updated On: 4/20/2018
(0 Ratings) 3 views
What should be done if antivirus software considers Toad.exe as a virus? (110097)

What do I have to do if my antivirus software (McAfee, Sophos,Trend Micro etc) considers Toad.exe as a virus? Please contact the company of the antivirus and let them know that Toad.exe is a benign tool. In case they need ...

Product(s): Toad Data Point, Toad for Oracle
Last Updated On: 4/18/2018
(0 Ratings) 1972 views
Texts, icons, buttons and dialog boxes have scaling issues using Windows 10. Some labels are truncated. Texts does not fit the window. (228013)

Texts, icons, buttons and dialog boxes have scaling issues using Windows 10. Some labels are truncated. Texts does not fit the window and gets cut-off. The text is too big and it is impossible to work with the window. In the support bundle one may see: Video Controller. ..... ...

Product(s): Toad Data Point
Last Updated On: 4/18/2018
(0 Ratings) 333 views
Apache Hive errors: "Invalid data source defenition: connect() failed: errno = 10061" and "Invalid data source definition: could not initialize security context: No authority could be contacted for authentication." (254121)

Apache Hive and Kerberos connection issues. Depending on the Port number used, the errors below are received. 1). Invalid data source defenition: connect() failed: errno = 10061. 2). Invalid data source definition: could not ...

Product(s): Toad Data Point
Last Updated On: 4/13/2018
(0 Ratings) 4 views
Errors: "An unhandled Microsoft .Net Framework exception occurred in toad.exe [14756]." and "Attempted to read or write protected memory. This is often an indication that other memory is corrupt." (52647)

Toad for Data Analysts (TDA) crashes when doing a right-click Refresh Items in Object Explorer | Views. Here is the Exception Information. or. Toad Data Point (TDP) error as soon as trying to connect to database (Access). ERRORS: 1). ...

Product(s): Toad Data Point
Last Updated On: 4/13/2018
(0 Ratings) 1919 views
Query Builder leaves a trail of boxes behind cursor when moving mouse around (254056)

When in the Query Builder screen, dotted boxes (like a trail) are consistently seen around and over the tables selected for that view. This happens even when the user is not selecting any objects or hitting any mouse buttons. ...

Product(s): Toad Data Point
Last Updated On: 4/13/2018
(0 Ratings) 8 views
Business Intelligence and NoSQL Data Sources are not showing in the New Connection drop down (205890)

Not able to connect to Business Intelligence or NoSQL Data Sources because they are not showing in the New Connection drop down. Business Intelligence and NoSQL Data Sources (see list below) are only available in the Toad Data Point Professional Edition. ...

Product(s): Toad Data Point
Last Updated On: 4/12/2018
(0 Ratings) 824 views
Cannot connect to MySQL when using SSL and turning off "Allow unsecure connections" in Google cloud platform. (253416)

Toad Data Point fails to connect and returns "Access denied for user 'root'@'localhost' (using password: YES)". WORKAROUND. Turn off "Allow unsecure connections" in Google cloud platform if possible STATUS. Waiting for fix in a future release of Toad Data Point.

Product(s): Toad Data Point
Last Updated On: 4/10/2018
(0 Ratings) 13 views
Can edit a Profiling Statistics Report? (252955)

It is possible to adjust what is shown in the Profiling Statistics reports that are auto-created when you click Report upon being within a Profiling tab already? The profiling tab in the Query Builder is just for a quick look at the data stats. ...

Product(s): Toad Data Point
Last Updated On: 4/5/2018
(0 Ratings) 5 views
Error "[Microsoft][ODBC Text Driver] Could not find installable ISAM" when connecting to .csv file, after upgrading MS Office version (252735)

After upgrading to Office 2016 (Office 365), the following error occurs when connecting to CSV files: [Microsoft][ODBC Text Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x30ac Thread 0x1ef0 DBC 0x6fa8008 Text'. ...

Product(s): Toad Data Point
Last Updated On: 4/4/2018
(0 Ratings) 3 views
How do I reuse the report generated by the Data Report Designer? (65149)

I created a query with the Query Builder and ran the query. From the Data Grid, I right-click and select 'Send to | Data Report Designer.' I ran through the wizard and save the report template. How can I use it again? In order to reuse the report, it must be saved as a .tdr file. ...

Product(s): Toad Data Point
Last Updated On: 4/2/2018
(0 Ratings) 1608 views