|
Re: Connectivity of Developer 6 with Oracle 9i Personal Edition [message #80787 is a reply to message #80729] |
Thu, 21 November 2002 22:38 |
kashif masood hashmi
Messages: 10 Registered: June 2002
|
Junior Member |
|
|
do the following steps
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl
now move to the home directory of oracle
suppose
C:oracleora90networkADMIN
and double click the tnsnames.ora
you can see the service name of your instance name copy the service name like
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
now move to the developer folder
C:oracledev6iNET80ADMIN
double click the tnsnames.ora file
and paste the above service.
now connect in form builder like scott/tiger@orcl
remember you must start your database before using the form builder.
Thanks.
|
|
|