立即与支持人员聊天
与支持团队交流

Toad Data Studio 2.0 - Release Notes

Known Issues

The following is a list of issues known to exist at the time of this release.

Feature Known Issue Defect ID
Schema Compare

Loading of objects in the Schema Compare wizard takes too long for Oracle data source

IMTDS-1194
Source Control The loading of objects, refreshing Action Center, and committing changes to the repository for an Oracle database takes too long.

IMTDS-1189

Source Control Unable to link database to Source Control when using an RSA key with a GitHub repository.

IMTDS-1196

Object Explorer Toad Data Studio closes unexpectedly when navigating between tables with XML data in Object Explorer on an Oracle connection.

IMTDS-1698

Results (Object Explorer) Toad Data Studio closes unexpectedly after editing and saving XML data in Oracle.

IMTDS-1625

Results "System.Runtime.InteropServices.COMException" error is encountered when the Explain Plan tab is selected from the Results section on a PostgreSQL connection.

IMTDS-1478

 

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 2.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 2.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 and download “license.dlv” file.

  2. Start Toad Data Studio

  3. Use the Import File option to navigate to the license file. Select “license.dlv”.

    Toad will automatically import the file to appropriate path %AppData%\Local\Quest\Toad Data Studio Licensing.

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

 

相关文档
Toad Data Studio - 2.0
Installation Guide
Release Notes
User Guide
Showing 1 to 3 of 3 rows

The document was helpful.

选择评级

I easily found the information I needed.

选择评级