Toad Data Point 6.2.3 - Release Notes

Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

New Features System Requirements Resolved Issues and Enhancements Known Issues Third Party Known Issues Getting Started Product Licensing Globalization About Us Copyright

Troubleshoot Oracle Issues

Review the following solutions to help troubleshoot Oracle connection issues pertaining to database connections and missing functionality and object information in Toad.

Connection Issues

Issue	Cause/Solution
Attempting to connect when Oracle Instant Client is installed results in a System.NullReferenceException error	Solution: In order to connect using the Oracle Instant Client, the directory for the Instant Client must be included in the environmental path, or you must copy the client files for the instance to the root install directory of Toad Data Point. You can also connect to the database without using an Oracle client or TNSNames file by selecting the Direct tab in the Create New Connection window.
An error occurs when attempting to connect to Oracle Rdb using an ODBC driver	Toad does not support Oracle Rdb at this time.
Attempting to connect to Oracle 18c results in the error ORA-28040: No matching authentication protocol	SQLNET.ALLOWED_LOGON_VERSION has been deprecated. Upgrade your Oracle client or set the parameter value to 12c.

Issue

Cause/Solution

Attempting to connect when Oracle Instant Client is installed results in a System.NullReferenceException error

Solution:

In order to connect using the Oracle Instant Client, the directory for the Instant Client must be included in the environmental path, or you must copy the client files for the instance to the root install directory of Toad Data Point.

You can also connect to the database without using an Oracle client or TNSNames file by selecting the Direct tab in the Create New Connection window.

An error occurs when attempting to connect to Oracle Rdb using an ODBC driver

Toad does not support Oracle Rdb at this time.

Attempting to connect to Oracle 18c results in the error ORA-28040: No matching authentication protocol

SQLNET.ALLOWED_LOGON_VERSION has been deprecated. Upgrade your Oracle client or set the parameter value to 12c.

Missing Functionality and Object Information

Issue	Cause/Solution
Some schemas are not available from the Schema drop-down list in the Object Explorer.	The Oracle ODBC driver cannot display schemas that do not have any tables.
Unable to view table data on the Data tab; SQLFetch generates an access violation.	The Oracle ODBC driver is accessing unallocated memory. Solution: Update the Oracle ODBC driver: For 9i drivers, update to 9.2.0.7.0 or later. For 10g drivers, update to 10.1.0.3.0 or later.

Issue

Cause/Solution

Some schemas are not available from the Schema drop-down list in the Object Explorer.

The Oracle ODBC driver cannot display schemas that do not have any tables.

Unable to view table data on the Data tab; SQLFetch generates an access violation.

The Oracle ODBC driver is accessing unallocated memory.

Solution:

Update the Oracle ODBC driver:

For 9i drivers, update to 9.2.0.7.0 or later.
For 10g drivers, update to 10.1.0.3.0 or later.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Toad Data Point 6.2.3 - Release Notes

Troubleshoot Oracle Issues

Connection Issues

Missing Functionality and Object Information