Toad Data Studio 1.0

Chat now with support

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

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 Studio. 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 Studio.

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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Studio 1.0 - User Guide

Troubleshoot Oracle Issues

Connection Issues

Missing Functionality and Object Information