Home » Developer & Programmer » Forms » Connectivity of Developer 6 with Oracle 9i Personal Edition
Connectivity of Developer 6 with Oracle 9i Personal Edition [message #80729] Sat, 09 November 2002 16:31 Go to next message
Kashif Khan
Messages: 10
Registered: December 2001
Junior Member
Is it possible to have a connectivity between
Developer 6 and Oracle 9i Personal Edition?

If yes then please let me know.

Thanks

Kashif Khan.
Re: Connectivity of Developer 6 with Oracle 9i Personal Edition [message #80787 is a reply to message #80729] Thu, 21 November 2002 22:38 Go to previous message
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.
Previous Topic: LOV and Text item--funny thing...any help??????
Next Topic: FRM-40509
Goto Forum:
  


Current Time: Wed Apr 24 10:01:35 CDT 2024