Oracle-10g Database is not connected by Oracle developer 6i

[hannan]

When I try to connect oracle database-10g by using oracle developer 6i "form builder" tools, I can not connect to database. It shows:

ORA-12154: TNS:could not resolve service name

Note: Please see the attach picture. Database & Developer tool are installed into same machine.

How I can connect the Database ? please specify with image.

B/Rgds
Hannan

[rski]

Is orcl present in tns which developer use?

[hannan]

Is orcl present in tns which developer use?

yes orcl is present in : C:\oracle\produ ct\10.1.0\admin
AND Tnsnames file is present in : C:\oracle\produ ct\10.1.0\db_1\ NETWORK\ADMIN

I don't know why this is not connecting ? I am using oracle developer 6i

[rski]

But none of these are developers directory (the directory where developer is installed), are they?
I think there should be a tns in developer directory.

[hannan]

Yes this is now at developer directory under:

C:\orant\NET80\ ADMIN

Here two files are found a)tnsnames.ora b)sqlnet.ora

[rski]

Yes this is now at developer directory under:

C:\orant\NET80\ ADMIN

Here two files are found a)tnsnames.ora b)sqlnet.ora

So you mus edit it. Add orcl to tnsnames.ora.