| 
		
 | 
	
		
		
			| 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.
		
		
		
 |  
	| 
		
	 | 
 
 
 |