Toad Data Point Subscription - Knowledge Base

Toad Data Point will not open or load on start up. (4361295)

When executing TDP, the application will not start t all. ... <p><strong>Cause #1:</strong></p> ... <p>-Start TDP once more.</p> ... <p> </p> ... For the Windows version to be used. ... Some users have confirmed that using the windows xp service pack 3 works for them.

How to assign someone the Admin or Owner role for a license? (4299816)

How to assign someone the Admin or Owner role for a License in the Database Tools License Portal ? ... The license portal provides Roles Based Access Control feature to make the management of licenses and people using those licenses easier.

How to transfer and assign subscription licenses from one user account to another? (4369136)

How to transfer and assign subscription licenses from one user account to another? ... The account (seat) of a license can be transferred via the Database Tools License Portal from one account to another.

Does Toad support encrypted connections to Oracle? (4283933)

Toad will use this configuration.

Does Toad Data Point 6.2 support Windows 11? (4371228)

Toad Data Point 6.2 offers support for the following operating systems: ... Windows Server® 2012 ... Windows Server® 2012 R2

What is the difference between Toad Data Point Base and Professional editions? (4232372)

The license defines the flavor. ... Both include the usual features and tools of previous versions of Toad for Data Analysts/Toad Data Point, but there are a few changes. ... Please review the link below for differences between the Base and Professional editions.

Error in License Portal: "License exists and you have no access." received when adding a license (4371041)

Error in License Portal: &quot;License exists and you have no access.&quot; received when adding a license This error occurs:<br>1. ... When adding a commercial license to an organization and the license has been already entered in the license portal by another user.

Error 'Set_Variable_1 - Error while getting SQL results' when using the Set_Variable activity in Automation (4374991)

The error &#39;Set_Variable_1 - Error while getting SQL results&#39; appears, when running a query such as the one below in an Automation .TAS file in Toad Data Point. <br><br>USE TEST<br>SELECT DISTINCT test.TABLE_NAME<br>FROM test1.TMP_TABLE_NAME<br><br>When you run the same query in the editor, it runs normally, but via automation, this error is seen. It happens on MySQL or Local Storage databases. WORKAROUND:<br>None<br><br>STATUS:<br>Waiting for fix in a future release of Toad Data Point QAT-19444

Get "Incoming request with IP/Token XXX.XXX.XXX.XXX is not alllowed to access Snowflake" error received when trying to get connected to the database. (4375045)

Contact your account administrator. ... For more information about this error, go to https://community.snowlake.com/s/ip-xxxxxxxxxxxx-is-not-allowed-to-access error is received when trying to connect to Snowflake databases.

Toad Applications randomly shut down, even in the middle of a query. (4374989)

Toad Applications randomly shut down, even in the middle of a query. ... No prompt to save changes or exit gracefully. ... It shuts down when minimized, idle, or in the middle of a query.<br><br>Here are the Windows error details.<br><br>Event ID 1000<br>Task Category: Application Crashing Events<br><br>Faulting application name: toad.exe, version: 8.0.0.65, time stamp: 0xfb689bbb<br>Faulting module name: ucrtbase.dll, version: 10.0.19041.3636, time stamp: 0x81cf5d89<br>Exception code: 0xc0000409<br>Fault offset: 0x000000000007286e<br>Faulting process id: 0x5d78<br>Faulting application start time: 0x01da6414a09f2eba<br>Faulting

Connecting from Toad Data Point gave error: "Toad could not find .Net Provider for Teradata" (4289345)

To create a Teradata connection, please download and install the provider.&quot; <p>Toad requires a Teradata client to be installed as a pre-requisite.

Database Explorer and Editor do not open automatically on a new connection (4374717)

The Database Explorer and Editor do not open automatically on a new connection.<br><br>When you select: Options | Database | General | Open on New Connection<br><br>and choose:<br>Database Explorer<br>Editor<br><br>they do not open automatically when a new connection is made. WORKAROUND:<br>None<br><br>STATUS:<br>Waiting for fix in a future release of Toad Data Point TDB-4008

How to transfer roles of licenses in the license portal between personal and organization accounts? (4307600)

Follow the below steps using the License Portal to transfer ownership (role) of a license to an organization or personal account. ... Note: The license portal provides Roles Based Access Control feature to make the management of licenses and people using those licenses easier.

How to add licenses and register them to a specific product? (4307635)

How to add licenses and register the license to my product? ... Follow the below steps using the License Portal to assign seats for a license: ... A license can be added to an individual Quest account e.g. jane@mail.com or to an organization account e.g. Quest Software Corp.

Get the message "Internet connection is required to continue" (4375439)

Clicking with the right button on the mouse on the Software Shortcut and select the &quot;Run as Administrator&quot; option in the menu. ... <br><br>2. ... Check that IPv6 is disabled in the Network card which is being used.<br><br>The Toad Subscription software should bring back the login screen.

How to remove a trial license once Toad Subscription has been purchased? (4368741)

User has been evaluating Toad and now has purchased, however, Toad is still using the trial license and displays the trial expiration term date on top banner of the application. ... How does one remove a trial license from Toad Subscription?

How to revoke/remove license seats from users? (4369674)

How to revoke/remove license seats from users? ... Use the Database Tools License Portal to locate the product license from Personal Licenses or an Organization Licenses overview page, and follow the below steps to remove/revoke seats from a license:

User Guide > Set Bind Variables

Toad supports the use of bind variables (bind parameters) in SQL statements. ... When you execute a statement containing a bind variable, Toad prompts you to enter a value. ... Toad also allows you to specify a default value for the variable before the query is executed by using the Variables option.

User Guide > Project Manager

Use the Project Manager to conveniently group and organize files and other resources into projects. ... You can save nearly any Toad document or exported file and add it to a project as you work.

User Guide > Introduction

Release Notes > Troubleshoot Sybase ASE Issues

Review the following solutions to help troubleshoot SAP issues pertaining to the following in Toad: ... Unable to connect to the database. ... The following message displays: "The ODBCMDA procedures have not been installed on this database..."

Release Notes > Troubleshoot Publishing to Toad Intelligence Central

Use this section to troubleshoot publishing errors. ... To troubleshoot issues when publishing an Automation script, see Troubleshoot Scripts on Intelligence Central. ... This error may occur if the connection's authentication token is expired.

User Guide > Optimize Cross-Connection Queries

To help you improve cross-connection query performance, Toad Data Point uses the Explain Plan to suggest improvements to your SQL statements and to reveal optimization techniques used in the estimated plan.

Installation Guide > Add OR Conditions

From the Criteria tab in the Query Builder, you can add an Or condition as part of a Where condition. ... Select the Or field below the column and click . ... Review the following for additional information:

Release Notes > Add or Remove Application Code

You can easily add syntax for another development tool such as C# to the SQL statement in the Editor to paste it into the development tool's code. ... You can also remove any syntax specific to the code development tool from the SQL statement so you can execute it in Toad.