The first step in working with any of the Developer tools is to establish a connection to an Oracle database. This is accomplished by pulling down the File menu and selecting the Connect menu item.
Fill in your Oracle "Username" and "Oracle Password" (press the tab key to move between the fields).
For the Database field, type in the service name for your Oracle database.
For example, if you are using Personal Oracle Lite, the Database: would be ODBC:POLITE. If you have a local database running on the same machine, you may be able to connect directly to it by leaving this field blank. If you are working in a client/server environment where the Oralce server resides on another machine, you will have to configure the Oracle Net8 middleware to establish a connection with that server. You would then supply the Net8 service name in the Database field. Alternatively, contact your system administrator to learn the service name for your Oracle database and provide that information in the Database: field.
Click on the Connect button to complete the connection (Under some versions of UNIX, the button is labeled OK). If the user name or password is mistyped or incorrect, the dialog box will be re-displayed. Be sure to provide your Oracle username and password (not your UNIX host or Local Area Network password).
Each time any of the Developer tools are executed, the first step will be to connect to an Oracle database in this fashion.
Previous Next
No comments:
Post a Comment