-
I am trying to connect to the database with developer form 6.0.
when I try, it give me an error:
TNS:could not resolve service name.
I have check tnsname.ora and it look ok.
I was able to do tnsping (database)
what am I missing?
I don't have to install the form server to get it to work do I?
sorry, new at this stuff.
thanks.
-
Hi
Check your tnsnames.ora available in your forms folder ( folder in which you have installed forms ) , if you have checked only the tnsnames.ora of your oracle client.
Rgds
San
-
Hi
Just copy the TNSNAMES.ora file from your Oracle Home directory to your forms directory it will work fine No problem.
Regards
Santosh
-
thanks
hey thanks,
that work fine.
-
one more thing
Does it work the same for Reports too?
because I tried copying the tnsnames.ora over to Reports60 dir, but I was unable to connect.
or do I need to do anything special for Reports.
thanks in advanced,
beginner..
-
Hi James,
You dont need to make any changes for reports it should connect.Follow the steps below
1) Make sure you have the same copy of TNSNAMES.ora file in the following direcotry in the corrsponding home
ORACLE_HOME,FORMS_HOME,REPORTS_HOME
The folders in the above Home folders will be
network/admin
net80/admin
so replace all the tnsnames.ora file with your original tnsnames.ora file from ORACLE_HOME directory to all the folders above
Generally what I do is I have the same TNSNAMES.ora file in all places.
If you want you can check connectivity to the database using the following commands
1) tnsping databasename
2) tnsping80 databasename
The first command checks from network/admin/tnsnames.ora
The second command checks from net80/admin/tnsnames.ora
Forms,Reports and designer I think use net80 folder
Hope this solves your problem for Reports as well.
Regards
Santosh
-
thanks
santos,
thanks, that really clear it up.
its working now..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|