Toad Data Point - Knowledge Base

Filter Your Results
Search All Products

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

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2041
How to run a silent installer as administrator (226994)

How to run a silent installer as administrator. Running as administrator can help if getting the following error message running install: 1. - Toad_xXxX has stopped working, when installing, the installer stops and does not install. 2. - The LOG says: ...

Product(s): Toad Data Point, Toad for SQL Server, Toad for Oracle
Last Updated On: 5/18/2017
(0 Ratings) 274 views
Get ORA-01005 error trying to generate Venn diagram using External authentication for Oracle (229508)

Trying to do a join analysis and generate the Venn diagram, using external authentication connecting to an Oracle database. When clicking on the join to do the analysis, and generate the Venn diagram, an ORA-01005: null ...

Product(s): Toad Data Point
Last Updated On: 5/17/2017
(0 Ratings) 5 views
Issue with the Toad Application Server service (Toad Intelligence Central) (210896)

When starting the "Toad Application Server (Toad Intelligence Central)" service on the TIC server with a user different from "Local System Account", an error appears in the Event Viewer. This occurs even if that user is part of ...

Product(s): Toad Intelligence Central, Toad Data Point
Last Updated On: 5/15/2017
(0 Ratings) 2 views
Can a table saved in Local Storage be joined with a table in another database platform to query data? (229398)

If data is saved to Local Storage, can it then be used to query against other data in another database platform (like Oracle, Teradata, or SQL database) to get other information? Data in Local Storage can be used to query against data from another database platform. ...

Product(s): Toad Data Point
Last Updated On: 5/12/2017
(0 Ratings) 3 views
How to disable the code snippets in TDP (229389)

how To remove the table details / structure when putting the cursor somewhere in the SQL editor of Toad Data Point ( TDP ). Go to Toad's top menu: Tools | Options... | Editor | Code completion | General. And uncheck the "Auto pop after" check-box.

Product(s): Toad Data Point
Last Updated On: 5/12/2017
(0 Ratings) 3 views
Error message "This installation package could not be opened." when launching the installation. (121787)

Getting the error message below when trying to install Toad: "The installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package.". ...

Product(s): Toad Data Point
Last Updated On: 5/11/2017
(0 Ratings) 1225 views
How to download a commercial software installer? Need installer by FTP or mail. (17322)

How to download a Commercial version installer from the Quest Support Portal? In some situations, it errors out during the download and won't let the download to complete even though a current support maintenance contract exists. Steps to download a commercial product: ...

Product(s): Toad Intelligence Central, Toad for SAP Solutions, Backup Reporter for...
Last Updated On: 5/11/2017
(0 Ratings) 20202 views
Toad.exe Instances stay opened even if scheduled tasks have ended (225838)

Several tasks are scheduled in Task Scheduler. In the Task Manager, some Toad.exe processes are left open while theoretically they should have finished as the tasks are completed. This consumes resources and forces to kill the processes manually. ...

Product(s): Toad Data Point
Last Updated On: 5/11/2017
(0 Ratings) 5 views
How to customize the toolbar and menu options. Missing features or tools on the menu. (105698)

How can the toolbar and menu options be customized? Some tools aren't used so don't need to be in the toolbar or menu. Or a feature used often is not on the toolbar or menu, can this be added? RESOLUTION: Right click over the menu bar and choose "Customize". ...

Product(s): Toad Data Point, Toad Data Modeler, Toad for DB2, Toad for SQL Server
Last Updated On: 5/11/2017
(1 Ratings) 1994 views
Error "[Microsoft][ODBC Microsoft Access Driver] Undefined function 'log10' in expression" when connected to a text file (.csv) (229188)

The following error occurs when the numerical function LOG10(x) is included in query: "[Microsoft][ODBC Microsoft Access Driver] Undefined function 'log10' in expression". LOG(x) works as expected. Toad uses Microsoft ODBC Text driver. LOG10 is not supported by this driver. ...

Product(s): Toad Data Point
Last Updated On: 5/8/2017
(0 Ratings) 4 views
MongoDB - The service is currently not responding. Please check your credentials and connectivity. (229249)

When connecting to Mongo DB one may see the error: The service is currently not responding. Please check your credentials and connectivity. --. Toad Data Point (TDP) can't connect MongoDB 'Admin' database Resolution 1: Try connecting to another database.

Product(s): Toad Data Point
Last Updated On: 5/8/2017
(0 Ratings) 5 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/8/2017
(0 Ratings) 4848 views
Installation, Unable to install product, "Unknown Error: this installation package failed due to an unknown error, returned error code [0xXXXXXXXX]. (229237)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the Unknown error. The issue happens on there is an unknown error happened during the installation. ERROR: "Unknown Error ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 23 views
Installer, Unable to install, getting the [8007051B] or [0x80070002] or [0x80070005] error. (229234)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the [8007051B] or [0x80070002] or [0x80070005] error. The issue happens on the bundle installer does not have the administrative privileges to perform the installation. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 27 views
Installation, Unable to install product, "HTTPs Error: This package download process are interrupted, error code [0x80072EFE] or [0x80072EFF] or [0x80070642] or [0x80070EFD] (229235)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the Https error. The issue happens on the web installer then your internet connection is unreachable. ERROR: "HTTPs Error: This package download processes are interrupted. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 30 views
Installation, "Insufficient Disk Space Error: this installation package failed due to insufficient disk space, returned error code [0x80070643] (229236)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the insufficient disk error. The issue happens on then there is no sufficient disk space to perform the installation. ERROR: "Insufficient ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 22 views
Is it possible to download data from spreadsheet located on Google Drive from the Toad data Point? (229184)

Is it possible to download data from spreadsheet located on Google Drive from the Toad data Point? Does exist any free of charge solution? There is not a native solution for this task, but it is possible to arrange simple workaround. ...

Product(s): Toad Data Point
Last Updated On: 5/8/2017
(0 Ratings) 3 views
Is it possible to cancel an Automation tas in Toad Data Point while it is running? (225478)

Is it possible to cancel an Automation tas in Toad Data Point while it is running? If that is not possible to do it for all the tas, would it be possible to have this at least when the tas is in a Pause activity? Cancellation of all automation ...

Product(s): Toad Data Point
Last Updated On: 5/5/2017
(0 Ratings) 125 views
Problem with decimal point in German in automation (225477)

Log Comment task in Automation does not support German number settings. 1,45 shows as 1450000 for example. WORKAROUND. Use English windows regional settings STATUS. Issue fixed in version 4.2. The latest version of Toad Data Point can be downloaded here.

Product(s): Toad Data Point
Last Updated On: 5/5/2017
(0 Ratings) 157 views
What's new in Toad Data Point 4.2? (229165)

This article outline some new features released with version 4.2. New Features. Publish View with Variable in SQL. -You can now publish a view that contains a variable. This new feature allows data providers to include variables ...

Product(s): Toad Data Point
Last Updated On: 5/4/2017
(0 Ratings) 33 views
File no longer exists on the server TIC - (223712)

After publishing a SQL file using toad for oracle (v12) to our tic serve rand then using TDP we see theSQL file in the object explorer however, when we try to 'get' the file says ' "this file no longer exists on the server TIC" WORKAROUND: None. STATUS: ...

Product(s): Toad Data Point
Last Updated On: 5/4/2017
(0 Ratings) 162 views
Does Toad Data Point use recreation of indexes or tables during synchronization task? (229010)

How Toad Data Point manage referential constraint in databases when doing compare and synchronization tasks. Toad Data Point uses the mapping between tables (which is customizable) to compare rows in tables. Multiple ...

Product(s): Toad Data Point
Last Updated On: 5/4/2017
(0 Ratings) 9 views
How to purchase or buy Toad? How to acquire a Commercial license key for Toad? (134489)

How to purchase or buy Toad, SQL Optimizer, or SQL Navigator products? How to acquire a Commercial license key? How to get a price quote? To purchase a Commercial license key for the aforementioned products and/or ...

Product(s): Toad for SAP Solutions, SQL Optimizer for SQL Server, SQL Optimizer for...
Last Updated On: 5/3/2017
(1 Ratings) 8547 views
Unable to see schemas other than 'default' for Hive connection in Toad Data Point (228926)

Unable to see schemas other than 'default' for Hive connection. Toad Data Point doesn't show others schemas or more tables under Hive connections. More in detail : 1. Cannot see other Schemas. 2. End user can see tables under Object Explorer, but unable to query them. ...

Product(s): Toad Data Point
Last Updated On: 5/3/2017
(0 Ratings) 22 views
Select to File published script does not keep correct date format (225837)

When publishing a script onto Toad Intelligence Central with a Select to File (to Excel) in a cross-query, the published script does not keep the same date format chosen within Toad Data Point. The Select to File function in a ...

Product(s): Toad Intelligence Central, Toad Data Point
Last Updated On: 5/2/2017
(0 Ratings) 19 views