Home » Developer & Programmer » Forms » Not able to connect with database from forms 6i but from forms 11g its connecting
Not able to connect with database from forms 6i but from forms 11g its connecting [message #676851] Tue, 23 July 2019 08:15 Go to next message
vraghul86@gmail.com
Messages: 11
Registered: December 2017
Junior Member
Hi,

After Installing forms 11g on my system i tried to connect database form forms 11g its working, but when i tried to connect form forms 6i i am not able connect to db.
i got "Tns could not Resolve records".

Note: before installing i am working from forms 6i, moreover i used the same TNS to connect the database form forms 11g.


Thanks & Regards.
Raghul V
Re: Not able to connect with database from forms 6i but from forms 11g its connecting [message #676853 is a reply to message #676851] Tue, 23 July 2019 09:06 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
What's the DB version?
Re: Not able to connect with database from forms 6i but from forms 11g its connecting [message #676854 is a reply to message #676853] Tue, 23 July 2019 09:12 Go to previous messageGo to next message
vraghul86@gmail.com
Messages: 11
Registered: December 2017
Junior Member
Dear Cookiemonster,

Oracle Database 10g. It's installed on different server. I just tried in my local system. till date our client is using forms 6i base application.
so, i just installed Weblogic and Forms 11g on my local System, then i am using same TNS which is on forms6i location. then i connected from forms11g to database its working.
when i tried to connecting from 6i to database i am getting "the TNS could not be resolved".

Note : i need to use both application, because i want to convert the some forms from 6i to Forms11g.


Thanks & Regards,
Raghul V
Re: Not able to connect with database from forms 6i but from forms 11g its connecting [message #676861 is a reply to message #676854] Wed, 24 July 2019 01:42 Go to previous messageGo to next message
John Watson
Messages: 8541
Registered: January 2010
Location: Global Village
Senior Member
Are you saying that:
(a) forms 6 could connect to the database, and
(b) forms 11 can connect to the database, but
(c) forms 6 can no longer connect to the database?
Re: Not able to connect with database from forms 6i but from forms 11g its connecting [message #676862 is a reply to message #676861] Wed, 24 July 2019 01:47 Go to previous messageGo to next message
vraghul86@gmail.com
Messages: 11
Registered: December 2017
Junior Member
Dear John Watson,

Yes, correct. but, i found the solution. i want to create environment variable. TNS_ADMIN specify the path to access the tnsnames.ora


Thanks & regards,
Raghul V
Re: Not able to connect with database from forms 6i but from forms 11g its connecting [message #676864 is a reply to message #676862] Wed, 24 July 2019 02:59 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
TNS_ADMIN would have been my first suggestion.
Re: Not able to connect with database from forms 6i but from forms 11g its connecting [message #676865 is a reply to message #676864] Wed, 24 July 2019 03:04 Go to previous message
vraghul86@gmail.com
Messages: 11
Registered: December 2017
Junior Member
Dear Cookimonster,


Thanks.

Previous Topic: export to excel
Next Topic: Search field in LOV issue
Goto Forum:
  


Current Time: Thu May 06 13:02:20 CDT 2021