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
|
N/A |
|
Export Wizard/ |
All |
To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. |
N/A |
|
Export Wizard/ |
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:
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 |
The Toad release package contains the following products:
See the Toad Data Studio Installation Guide for more information.
Select Sign In Online and enter your account email address and password
If you already have a Toad Data Studio license, no further action is needed
If you do not have a Toad Data Studio license, see “Activating a new license” below
Select Sign up for a new account
Enter your account details and select Sign Up
A confirmation email is sent containing a verification code
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
Toad Data Studio Subscription automatically provides a fully functioning, 30-day Trial license
To purchase a new license, click Buy Now from Toad's title bar
After completing your transaction, see “Offline license activation using license file” below to activate your commercial license
Check email sent from Quest licensing team for “license.dlv” file
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)
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 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.
Select Sign In Online and enter your account email address and password
If you already have a Toad Data Studio Subscription license, no further action is needed
If you do not have a Toad Data Studio Subscription license, see Activating a new license below
Select Sign up for a new account
Enter your account details and select Sign Up
A confirmation email is sent containing a verification code
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
Toad Data Studio Subscription automatically provides a fully functioning, 30-day Trial license
To purchase a new license, click Buy Now from Toad's title bar
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.
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
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
