Review the following solutions to help troubleshoot Oracle 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 |
---|---|
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:
|
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center