Quest has been named as an ASP "Ten Best Web Support Sites" award winner. Learn more.

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.2
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 Contacts

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2141
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 (233867)

THE ERROR: Quest.Toad.Exceptions.ProcessedExecutionException: 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: 10/19/2017
(0 Ratings) 8 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: 10/18/2017
(1 Ratings) 7717 views
Error connecting to database:"ORA-12545:Connect failed because target host or object does not exist" (55934)

The following error occurs when connecting to a remote database: "ORA-12545: Connect failed because target host or object does not exist". Firewall 'Blocked' setting for Toad.exe. RESOLUTION #1: Change existing firewall ...

Product(s): Toad Data Point, Toad for Oracle
Last Updated On: 10/18/2017
(0 Ratings) 4345 views
Cannot view package body source (Oracle) from the 'Body' tab of View Details window (215407)

When selecting a package for an Oracle DB, the source of the package specification can be veiwed, but when clicking the "Body" tab, the screen displays "No package body" Toad queries SYS.ALL_SOURCE to gather this information but user may not have permissions to query ...

Product(s): Toad Data Point
Last Updated On: 10/17/2017
(0 Ratings) 1 views
Is it possible to enter multiple values in an Automation script field prompting for a varaible value? (233676)

An automation script runs fine when users enter a single value for the variable when prompted. However, if the user enters two or more numbers (separated by a comma), the query fails with an "Invalid Number" error. Is there a way to enter multiple values in the variable field? ...

Product(s): Toad Data Point
Last Updated On: 10/13/2017
(0 Ratings) 6 views
Cannot update INGRESDATE in data grid (233528)

Cannot update INGRESDATE in data grid. Either Toad Data Point returns an error or it does not update the row. WORKAROUND Use UPDATE statements to update date fields in the editor STATUS Waiting for fix in a future release of Toad Data Point

Product(s): Toad Data Point
Last Updated On: 10/11/2017
(0 Ratings) 6 views
Exporting a pivot table with column data repeated on each row (233494)

When customer attempting to export a pivot table, they have a user that requires the data to repeat on each line. Attach the spreadsheet test example. They are using version 4.0 and he stated prior to 3.6 being uninstalled from ...

Product(s): Toad Data Point
Last Updated On: 10/9/2017
(0 Ratings) 18 views
Trying connect to sql database & getting error "connection refused" when unchecked Use Data Source Name (233259)

The Postgrep database connection is fine, but when unchecked Use Data Source Name TDP is trying to connect to localhost (127.0.0.1). Workaround. User has to insert ODBC CONNECTION string like the following one. Server ...

Product(s): Toad Data Point
Last Updated On: 10/9/2017
(0 Ratings) 25 views
How to send a link to a file / folder in a automation's email body? (233410)

If one doesn't want to send the file as attachment, but, instead one's trying to send the location of the file in a network drive so that users can open it remotely, can that location be sent as a link, so that clicking on it is enough to open the file or the folder where the file is? ...

Product(s): Toad Data Point
Last Updated On: 10/5/2017
(0 Ratings) 5 views
Snapshot refresh cannot be scheduled to run every x hour, for set daily hours (228265)

A snapshot published onto Toad Intelligence Central cannot be scheduled to be refreshed every x hour, for set daily hours - the only option is full day. For example, is it possible to set a snapshot to refresh every 15 minutes between 5am and 8pm during weekdays only? ...

Product(s): Toad Data Point
Last Updated On: 10/5/2017
(0 Ratings) 3 views
TDP locks up every so often while running query in Vertica. (93192)

An intermittent issue occurs when running queries while connected to Vertica databases. Sometimes Toad seems to hang up, freeze, or lock up. Toad shows as not responding. Using an ODBC Vertica driver that is not supported by TDP. RESOLUTION 1: ...

Product(s): Toad Data Point
Last Updated On: 9/29/2017
(0 Ratings) 2041 views
Not able to see all the schema listed in the Object Explorer for iSeries (231830)

When connected to an iSeries server, unable to see other schema in the Object Explorer, besides the one being connected to and maybe one or two other schema, and all their associated objects. However, tables in the schema ...

Product(s): Toad Data Point
Last Updated On: 9/29/2017
(0 Ratings) 67 views
Is there a way to encrypt the license key, so end users cannot view the key? (233243)

Is there a way to encrypt the license key from being seen in the Help | Licensing window or in the file where the license key is stored? The license key is encrypted in the Help | Licensing window. Only the last few digits of the key can be seen. ...

Product(s): Toad Data Point
Last Updated On: 9/28/2017
(0 Ratings) 2 views
Cant copy Kanji / Japanese characters from result set - data-grid empty (233240)

When copying Japanese characters from the datagrid with the results, and trying to use them in the WHERE clause of the query to filter the results, the query returns no rows, even when the value is returned without using the WHERE clause. ...

Product(s): Toad Data Point
Last Updated On: 9/28/2017
(0 Ratings) 1 views
Are multibyte character sets, like Kanji, supported? (232122)

Are multibyte character sets, like Kanji, supported? In general, we support unicode. However, each provider type has different requirements on setting this up for server and client. The one area where we do not support unicode, yet, is Cross-Platform execution. ...

Product(s): Toad Data Point
Last Updated On: 9/28/2017
(0 Ratings) 48 views
Netezza - Can't use query builder (233157)

When connected to Netezza, and trying to drag a Table into the Query Builder, Toad hangs, the table is never shown in the query builder, Toad becomes unusable and one has to kill it from the Task Manager. The "Database ...

Product(s): Toad Data Point
Last Updated On: 9/27/2017
(0 Ratings) 5 views
64 bit machine-odbc driver is 32 bit-accidentally installed 64bit 4.2 and doesn't work (231809)

We Installed Toad 64 bit with a 32bit ODBC driver but couldn't connect. Then we installed Toad 32 bit still didn't work. On the other hand, can't see the scheduled jobs in Job manager. Those jobs run, but can't be seen or edited. WORKAROUND - Use TDP Beta 4.3. ...

Product(s): Toad Data Point
Last Updated On: 9/27/2017
(0 Ratings) 77 views
ANSI CAST does not work in cross connection query (228168)

When adding a CAST in a cross connection query it results in the following error message: "Cross Query Database Error: You have an error in your SQL syntax; check the manual that corresponds to your Cross Query server version for the right syntax to use near 'INT)' at line 24 ...

Product(s): Toad Data Point
Last Updated On: 9/27/2017
(0 Ratings) 2 views
Data Compare fails or hangs on Extracting Foreign Keys when comparing two Firebird databases (233166)

Data Compare ( Tools | Compare | Data Compare) does not work with Firebird databases. Toad Data Point returns the error "Object reference not set to an instance of an object" / "De objectverwijzing is niet op een exemplaar ...

Product(s): Toad Data Point
Last Updated On: 9/26/2017
(0 Ratings) 6 views
When using mapped drives, scheduled automation says it ran, but it did not (227528)

When using a mapped drive in a task for a scheduled automation, the automation says it finished running, but it does not appear it did run. If it is run manually (clicking the Run button in the automation window) it runs fine. Only when scheduled does it have a problem. ...

Product(s): Toad Data Point
Last Updated On: 9/21/2017
(0 Ratings) 185 views
Cannot Connect to Toad Intelligence Central Server from Toad Data Point. (127535)

Unable to connect to Toad Intelligence Central (TIC) Server from Toad Data Point (TDP). The error below is received. If using TDP and TIC on the same machine, it works fine. If using TDP that resides on a different PC to connect to a TIC Server, it does not work. ERROR: ...

Product(s): Toad Decision Point, Toad Intelligence Central, Toad Data Point, Toad...
Last Updated On: 9/21/2017
(0 Ratings) 4841 views
Toad Data Point. New Connection | Oracle | the window or screen is empty or blank. There are no fields, drop-down boxes, etc. (226275)

Toad Data Point 64-bit. New Connection | choose Oracle under Group | the window or screen is empty or blank. The usual fields, drop-down boxes, etc. are not there. * TDP reads the oracle home first instead of the System Environment variables. ...

Product(s): Toad Data Point
Last Updated On: 9/20/2017
(0 Ratings) 3 views
'Document ... cannot be saved for Document Recovery' when saving a Database Diagram (232828)

When working on a diagram .ter file, and saving any change (for example, adding a note in it), there is an error when you save the file. 'Document ... cannot be saved for Document Recovery. Object Reference not set to an instance of an Object. ...

Product(s): Toad Data Point
Last Updated On: 9/12/2017
(0 Ratings) 6 views
Trial Key activation error: Unable to validate license. Either this license has expired or the maximum number of Trial keys have been used. (63356)

When I enter a trial license key that was sent to me, I get the following message. "Unable to validate license. Either this license has expired or the maximum number of Trial keys have been used. Please contact a Quest sales ...

Product(s): Toad Data Point, Toad for Oracle
Last Updated On: 9/5/2017
(0 Ratings) 4332 views
Automation script published to a Toad Intelligence Central (TIC) server is not running the macros in the exported Excel file (232095)

Automation scripts which export to macro enabled Excel files can be published and run on TIC server, but the macros are not running. Although Excel does not need to be installed on the TIC Server, it does need to be installed if macros are included in the export file. ...

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