OraFAQ Forum: Forms » Not able to connect with database from forms 6i but from forms 11g its connecting

Home » Developer & Programmer » Forms » Not able to connect with database from forms 6i but from forms 11g its connecting

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not able to connect with database from forms 6i but from forms 11g its connecting [message #676851]

Tue, 23 July 2019 08:15

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

Report message to a moderator

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

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

What's the DB version?

Report message to a moderator

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

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

Report message to a moderator

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

John Watson
Messages: 8974
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?

Report message to a moderator

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

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

Report message to a moderator