Chat now with support
Chat with Support

Toad Data Studio 1.0 - Release Notes

Third Party Known Issues

The following is a list of third party issues known to exist at the time of release of Toad Data Studio 1.0.

 

Feature      Platform Known Issue ID

Connect to Database

DB2 If you are using the DB2 Client version 9.5, 9.7, or 10.1 in a Windows 8 or Windows Server 2012 environment, follow the instructions in IBM DB2 Technote 1618434: http://www-01.ibm.com/support/docview.wss?uid=swg21618434. N/A

Connect to Database

Excel

The following error is encountered when attempting to create a connection to an extremely large Excel file (for example, 20 MB or larger): "Microsoft. ODBC Excel Driver. System resource exceeded."

For more information, see https://forums.toadworld.com/t/error-in-importing-large-excel-files/26457/9.

Workaround: Convert the Excel file to a CSV file.

N/A

Connect to Database

Oracle

 

(Oracle 10.2.0.1 client only) Attempting to connect to an Oracle database From Toad using the 10.2.0.1 Oracle client results in the following error: “ORA-24909: call in progress. Current operation canceled”. This is a known issue with this Oracle client.

Workaround: Upgrade your Oracle client to a later version and connect to the Oracle database.

N/A

 

Connect to Database

Oracle 11 only

When connecting to Oracle 11, you must enter the password in the proper case because passwords are case-sensitive. N/A

Data

ODBC- DB2 z/OS

In compatibility mode, the ODBC driver does not return enough information for the CommandBuilder to correctly generate update or insert statements.

N/A

Editor Teradata

If you experience performance issues using a Teradata connection, especially when using code completion in the Editor, use the Teradata Non-X views (instead of the X views).

To use Teradata Non-X views

  • Select Tools | Options | Database | Teradata and select the Use Non-X views in Object Explorer option.
N/A

Export Wizard/
One Click Export

All

To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed.  

N/A

Export Wizard/
One Click Export

Excel Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit. N/A
Import Wizard DB2 When importing data using the Add Query feature and selecting a Single new table, TIMESTAMP data types are mapped to DATETIME data types. N/A
Object Explorer Cloudera Impala

A view is represented as a table in Impala, so views display as tables in Toad. For more information, see https://issues.cloudera.org/browse/IMPALA-1697.

N/A
Object Explorer/ Database Explorer Teradata

You may experience issues if you attempt to view object details and your Teradata .Net Data Provider version does not correspond to the Teradata database version to which you are connecting. Issues include:

  • Object details for a View containing a DATE data type column do not display.
  • Object details for a Table containing a NUMBER data type column do not display.

Workaround: Install the Teradata .Net Data Provider version that corresponds with the Teradata database version to which you are connecting. For example, if connecting to Teradata database version 14, use Teradata .Net Data Provider 14.11.

N/A

Object Explorer/ Database Explorer DB2 iSeries The primary Key column of an iSeries table displays as Nullable in the Database Explorer even though the Not Null checkbox was not selected when creating the table. N/A

Query Builder

Sybase ASE

Cross-connection query: Sybase has difficulty dealing with numeric literals in queries. You may encounter the following error:

Implicit conversion from datatype 'CHAR' to 'INT' is not allowed. Use the CONVERT function to run this query.

when attempting to execute a cross-connection query such as:

Select * from table where numeric_column = 50

Work-around: Change the query to something similar to the following using the cast function:

Select * from table where numeric_column = CAST(50 AS SIGNED)

ST96868
Query Builder Cassandra and Excel/Access

Cross-connection query: A query between Cassandra and either Excel 2010 or Access 2010 might fail to execute and display a lost-connection error.

Workaround: Upgrade to Excel 2013 or Access 2013 (or later).

N/A

 

Getting Started

Contents of the Release Package

The Toad release package contains the following products:

  1. Toad Data Studio 1.0
  2. Product Documentation, including:
    • Installation Guide
    • Release Notes
    • User Guide

Installation Instructions

See the Toad Data Studio Installation Guide for more information.

 

Product Licensing

Product Licensing

 

Toad Data Studio with online licensing

 

To activate a trial license

 

Sign in with existing Quest.com account

  1. Select Sign In Online and enter your account email address and password

  2. If you already have a Toad Data Studio license, no further action is needed

  3. If you do not have a Toad Data Studio license, see “Activating a new license” below

 

Create a new Quest.com account

  1. Select Sign up for a new account

  2. Enter your account details and select Sign Up

  3. A confirmation email is sent containing a verification code

  4. Enter the code from the email and select Verify

NOTE:

  • It may take a few minutes for the verification email to arrive

  • Check your spam/junk folders for the email sent from supportadmin@quest.com if you do not receive it

  • For additional assistance, please contact Quest support

 

Activating a new license

  1. Toad Data Studio Subscription automatically provides a fully functioning, 30-day Trial license

  2. To purchase a new license, click Buy Now from Toad's title bar

  3. After completing your transaction, see “Offline license activation using license file” below to activate your commercial license

 

Toad Data Studio with offline licenses using license file

 

To activate a trial or purchased commercial license

 

  1. Check email sent from Quest licensing team for “license.dlv” file

  2. Ensure Toad is closed and copy the attached “license.dlv” file to the "%AppData%\Local\Quest\Toad Data Studio Licensing" folder. (C:\Users\%USER%\AppData\Local\Quest\Toad Data Studio Licensing)

  3. Start Toad Data Studio

NOTE:

  • You can download the trial file from the trial download web page, accessed through the product page

  • You can view your licenses from within Toad by selecting Help | About

 

Toad Data Studio Subscription with online licensing

 

Toad Data Studio Subscription requires you to sign in with your Quest.com account. Licenses are tied to your account giving you the flexibility to use Toad from multiple computers without having to move your license.

 

Sign in with existing Quest.com account

  1. Select Sign In Online and enter your account email address and password

  2. If you already have a Toad Data Studio Subscription license, no further action is needed

  3. If you do not have a Toad Data Studio Subscription license, see Activating a new license below

 

Create a new Quest.com account

  1. Select Sign up for a new account

  2. Enter your account details and select Sign Up

  3. A confirmation email is sent containing a verification code

  4. Enter the code from the email and select Verify

NOTE:

  • It may take a few minutes for the verification email to arrive

  • Check your spam/junk folders for the email sent from supportadmin@quest.com if you do not receive it

  • For additional assistance, please contact Quest support

 

Activating a new license

  1. Toad Data Studio Subscription automatically provides a fully functioning, 30-day Trial license

  2. To purchase a new license, click Buy Now from Toad's title bar

  3. After completing your transaction, restart Toad and your license is automatically detected. Alternatively, use Refresh License option from the top right Account menu or Help | About window to activate your commercial license.

  4. To manage licenses, select Manage licenses online beneath your account shown at the top-right of Toad

NOTE: You can view your licenses from within Toad by selecting Help | About

 

Globalization

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

This release has the following known capabilities or limitations: If the user overrides the default installation path during installation, the new path specification cannot contain Unicode characters.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating