Home » SQL & PL/SQL » SQL & PL/SQL » Coonecting to DB on Forms 6i
Coonecting to DB on Forms 6i [message #195045] Tue, 26 September 2006 13:52 Go to next message
wannabbest
Messages: 4
Registered: September 2006
Location: Hyderabad
Junior Member

Hey Guys, I am new to the RDBMS platform and I have installed Forms 6i on my PC and I am not able set the connection because I am not able to configured the tns.ora file...can any body help me on this..Please..Also I wanted to know the significance of this for setting the sql server...

Thanks !! Razz
Re: Coonecting to DB on Forms 6i [message #195053 is a reply to message #195045] Tue, 26 September 2006 14:57 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What prevents you to configure it? Do you get an error message or ...? Which database are you trying to connect to? Local one or over the network? Is it Oracle or SQL Server (as you mentioned it too)?
Re: Coonecting to DB on Forms 6i [message #195079 is a reply to message #195045] Tue, 26 September 2006 21:48 Go to previous messageGo to next message
wannabbest
Messages: 4
Registered: September 2006
Location: Hyderabad
Junior Member

Yes I was trying to logon to the SQL* PLUS 8 server and Its a local server actually and I have loaded Forms 6i on my personal computer...And I get a error saying TNBS:no listener.....And Thanks for helping me out..Smile
Re: Coonecting to DB on Forms 6i [message #195091 is a reply to message #195079] Wed, 27 September 2006 01:04 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I understood you correctly, both database and developer are on your PC. Right? If so, and regarding the fact that SQL*Plus works fine, you could - as a first aid copy TNSNAMES.ORA, SQLNET.ORA and LISTENER.ORA from "database\network\admin" directory to "developer\network\admin" one. Perhaps this shortcut could help.
Previous Topic: Oracle 10g Data Pump API using DBLINK
Next Topic: Function in shell
Goto Forum:
  


Current Time: Sun Dec 11 04:15:51 CST 2016

Total time taken to generate the page: 0.17621 seconds