Clearly, Figure 1.1 does not show or imply how to address any of that information. For example, the database might be named ORCL and might reside at network address 192.168.1.5. An Oracle database usually has an address and a name by which you reference it. This type of network information tends to be very detailed and site specific, such that any database applications using this framework know how to properly navigate the network pathway. Once the pieces shown in Figure 1.1 are in place on your Windows PC (i.e., the software is installed), you still need to provide network configuration information. TOAD will not work with ODBC connections.īut you're not done just yet-not by a long shot. However, if you plan to run a 64-bit database locally, then you would need to run the Oracle installer a second time to force an installation of the 32-bit client that TOAD requires.Ī very common question is, Can TOAD use Microsoft's Open Database Connect (ODBC)? The answer is an emphatic 'no.' The data access layer component within TOAD has been designed to communicate with the database solely via the OCI API provided by Oracle. As a consequence, you would not need to run the Oracle software installer twice. Of course, you can also download the software from the Oracle Technology Network (OTN), but you must abide by the license agreement, which states that you have a 'limited license to use the programs only for the purpose of developing a single prototype of your application, and not for any other purpose.' If your target database is also running on your Windows PC, then the installation process for the Oracle database software on your PC would have already created those items for you. That leaves the 'Oracle Call Interface (OCI)' and 'Oracle SQL*Net Network Layer' parts of Figure 1.1: Where do they come from? To implement them, you must install the Oracle 32-bit network client from the Oracle installation CD or DVD.

When you install TOAD, the 'TOAD Application' part of Figure 1.1 is accomplished automatically. So that part's very easy-you have nothing to do. Figure 1.1 Network Pathway between TOAD and the Target Oracle Databaseįor your Windows PC, where do the four key parts (i.e., the four boxes on the left side of Figure 1.1) of that network pathway between TOAD and the database come from? The TCP/IP layer will already be there from your Windows installation and network card configuration.

Toad db