Meeting TOAD’s Database Connectivity Needs

TOAD must be able to communicate with your Oracle database. That means TOAD must be able to both connect and then work with your database whether it’s local (on PC) or remote (on server). This requires that the Oracle network client libraries exist on your PC for TOAD to call. Of course, Oracle in its infinite wisdom has renamed the client software and libraries as shown in Table 1.1.

Table 1.1. Oracle Connectivity
Version Terminology Client Library
Oracle 7 SQL*Net ORA7x.DLL
Oracle 8 Net8 ORACLIENT8.DLL
Oracle 8i Net8 ORACLIENT8.DLL
Oracle 9i Oracle Net ORACLIENT9.DLL
Oracle 9iR2 Oracle Net ORACLIENT9.DLL

Furthermore, you must also verify that your PC’s environment variable for PATH includes the directory ...

Get TOAD® Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.