Statistica is now part of TIBCO. Beginning June 5th, Statistica customers will need to use TIBCO Support's customer portal, to receive assistance with Statistica.

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 2060
Connection to an Azure SQL Server does not work with Windows authentication and active directory. (227191)

When creating a connection to an Azure SQL Server, the protocol automatically restricts the authentication to SQL Server Authentication. Windows authentication with Active Directory management on the Azure SQL Server is supported? Enhacenment WORKAROUND: None. ...

Product(s): Toad Data Point
Last Updated On: 6/25/2017
(0 Ratings) 5 views
When using a cross connection import template in automation, a validation error appears (229275)

A cross connection query can be used in an import template. If the import template with cross connection query was created before and then it's being selected in automation, Toad gives a validation error that states the connection is wrong. ...

Product(s): Toad Data Point
Last Updated On: 6/25/2017
(0 Ratings) 33 views
When doing the migration of the settings from a previous version of Toad Data Point, the customized toolbars are not being migrated (229447)

When a new version of Toad Data Point is installed, a windows appear asking if you want to migrate the settings of your previous version of Toad. When the migration finishes, the customized toolbar are not being migrated by the process. Defect WORKAROUND: None. ...

Product(s): Toad Data Point
Last Updated On: 6/25/2017
(0 Ratings) 42 views
Is there a way to copy or export the Describe information of an object using Salesforce connection? (230481)

The Describe information of an object (for example: a table) can be copied or exported using an Oracle connection. But, when using a Salesforce connection, there is no possibility to copy this data. Ctrl + C or select all does not work either. ...

Product(s): Toad Data Point
Last Updated On: 6/24/2017
(0 Ratings) 66 views
When Toad is connected to a Mongo database, table names are available but the description and content of each table its empty (213656)

When Toad Data Point connects to Mongo database, the documents (rows) or description of the collection (table) its empty. When the same test its being done from Robomongo (external tool), this behavior doesn't occur. Defect WORKAROUND: none. STATUS: ...

Product(s): Toad Data Point
Last Updated On: 6/23/2017
(0 Ratings) 533 views
"The requested address is not valid..." connecting to Local Storage. "Unable to connect to any..." connecting to Salesforce or running Cross Connection Query (208684)

Issue 1: When trying to connect to Local Storage the following error is displayed: "There was a connect error. Check that the username and password are correct, that you have registered this user using the registration tab, and that the registered user has not been disabled. ...

Product(s): Toad Data Point
Last Updated On: 6/23/2017
(1 Ratings) 1127 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: 6/22/2017
(0 Ratings) 1316 views
New installation of Toad for Oracle and Toad Data Point shows a trial key embedded inside (59493)

A new installation of Toad for Oracle and Toad Data Point (formerly known as Toad for Data Analysts) was done on a clean machine. Opening Toad Data Point for the first time will show a trial key (License Tab). After registering ...

Product(s): Toad Data Point, Toad for Oracle
Last Updated On: 6/22/2017
(0 Ratings) 5480 views
There is a long delay when dragging and dropping objects in Query Builder (210640)

Oracle Connection. When dragging and dropping objects in Query Builder, there is a lag time. It takes about 20-30 seconds for the table to appear and to get control back. Sometimes it appears that the drag and drop worked ...

Product(s): Toad Data Point
Last Updated On: 6/22/2017
(1 Ratings) 405 views
Toad Automation Script is not able to send an email to office365.com (230323)

It is not possible to use mailbox using office 365 SMTP settings and credentials. WORKAROUND: None. SOLUTION: 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: 6/21/2017
(0 Ratings) 2 views
Is there a way to connect Toad for Oracle with DB2 database? (228098)

Is there a way to connect Toad for Oracle with DB2 database? WORKAROUND: Toad for Oracle only works with Oracle databases. If you want to connect to a DB2 database, Toad Data Point / Toad Intelligence Central or Toad for DB2 are the appropriate programs. ...

Product(s): Toad Data Point, Toad for DB2, Toad for Oracle
Last Updated On: 6/20/2017
(0 Ratings) 25 views
Does Toad have a version that is supported on Mac? (26230)

Does Toad support the Apple Mac platform? Commercial versions of Toad do not formally support use on Mac. There is a new option for Mac users. Please check out Toad-Mac in the Toad World community. http://www. toadworld.com/products/toad-mac-edition/default.aspx. ...

Product(s): Toad Data Point, Toad for DB2, Toad for Oracle
Last Updated On: 6/15/2017
(0 Ratings) 2423 views
System.FormatException Error "Input string was not in a correct format" on launching Toad (138051)

The following error occurs on launching Toad: System.TypeInitializationE xception. The type initializer for 'Quest.Toad.DB2.DB2ConnectionControl' threw an exception. Stack Trace: at Quest.Toad.DB2.DB2ConnectionControl ...

Product(s): Toad Data Point, Toad for DB2
Last Updated On: 6/14/2017
(0 Ratings) 4081 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: 6/14/2017
(0 Ratings) 21112 views
Error when connecting to an Excel Macro document "The 32-bit version of Microsoft Excel is required for compatibility with this feature" (230387)

On trying to connect to an Excel macro document, the following error occurs: "Toad Data Pint 4.0 is a 32-bit application. The 32-bit version of Microsoft Excel is required for compatibility with this feature. Please install MS Office 32 bit.". ...

Product(s): Toad Data Point
Last Updated On: 6/13/2017
(0 Ratings) 2 views
Connects to Composite database. Some columns shows incorrect data values in TDP. (230383)

TDP connects to 'Composite' using ODBC, then Composite reads, joins, etc. data from Oracle DB. Some columns shows different or wrong data values in TDP like 1, 0, 50, 232, but it should be just 1's and 0's. DB Visualizer shows the correct values. DB Visualizer uses JDBC. ...

Product(s): Toad Data Point
Last Updated On: 6/13/2017
(0 Ratings) 3 views
It is possible to migrate scheduling tasks manually if they were not migrated upon initial launch? (230367)

It is possible to migrate scheduling tasks manually if they were not migrated upon initial launch? RESOLUTION. Yes, they can be migrated using the Job Manager: 1.Select Tools | Administer | Job Manager. 2.Click on the Job Manager toolbar. ...

Product(s): Toad Data Point
Last Updated On: 6/13/2017
(0 Ratings) 4 views
Error when running two data compare tasks at the same time (230364)

When executing two data compare tasks at the same time, the following error appears: The process can not access the 'C:\Users\user\AppData\Local\Quest Software\Toad Data Point 3.8\Quest_DC_Temp\automation_script_pos ...

Product(s): Toad Data Point
Last Updated On: 6/13/2017
(0 Ratings) 3 views
Toad Data Point couldn't load or compile the script to TIC (230348)

When publishing to Toad Intelligence, and error occurs and Toad could not load or compile the script This issue was fixed in Toad Data Point 4.2

Product(s): Toad Data Point
Last Updated On: 6/12/2017
(0 Ratings) 4 views
Getting error when trying to run Job "Automation Script failed test run on Intelligence Central Server' (230340)

Getting the following error when trying to run Job in Toad Data Point from Intelligence Central. "Automation Script failed test run on Intelligence Central Server". This happens once he has linked the SQL files. This defect has been fixed in Toad Data Point 4.2

Product(s): Toad Data Point
Last Updated On: 6/12/2017
(0 Ratings) 4 views
Export_1 The process cannot access the file "XXXXXXX" because it is being used by another process (227124)

When running an Automation Script that exports to excel and run a Macro there(maybe the excel is in a network drive), one may see the error: Export_1 The process cannot access the file "XXXXXXX" because it is being used by another process. WORKAROUND. None. STATUS. ...

Product(s): Toad Data Point
Last Updated On: 6/12/2017
(0 Ratings) 119 views
Using F5 to run a simple SQL statement (i.e. select count * from table_name) does not log it in SQL Recall window. Using F9 logs it fine. (230276)

Using F5 to run a simple SQL statement (ie select count * from table_name) does not log or enter it in SQL Recall window. Using F9 logs it fine. Issue happens on Oracle connections only. With SQL Server connection, the issue does not happen. ...

Product(s): Toad Data Point
Last Updated On: 6/9/2017
(0 Ratings) 4 views
In TDP 4.0 and 4.1, Set Variable Activity, Datetime shows as '01/01/2017 00:00:00' when it should be '01/01/2017 12:00:00 AM'. (230277)

In the Set Variable Activity, when user sets a Datetime, such as '01/01/2017', normally in versions of TDP prior to 4.0, the date time would be set as '01/01/2017 12:00:00 AM' in the log. In 4.0, the datetime started being set as ...

Product(s): Toad Data Point
Last Updated On: 6/9/2017
(0 Ratings) 7 views
Error "Incorrect parameter count in the call to native function 'DECODE'" when executing a cross-connection query (224903)

When running a Cross Connection Query and using the function DECODE() the following error occurs: "Incorrect parameter count in the call to native function 'DECODE'". Sample cross query: SELECT ADDRESS.COUNTRY. ...

Product(s): Toad Data Point
Last Updated On: 6/9/2017
(0 Ratings) 312 views
Unable to attach TDP to MongoDB database. Error: “The user must be created in the target database.” (210269)

Unable to attach or connect Toad Data Point to MongoDB database. Error: “The user must be created in the target database.” WORKAROUND: None. STATUS: Issue fixed in version TDP 4.2 and TIC 3.3. The latest versions can ...

Product(s): Toad Intelligence Central, Toad Data Point
Last Updated On: 6/9/2017
(0 Ratings) 705 views