Home » Developer & Programmer » Forms » configuring tnsnames.ora file
configuring tnsnames.ora file [message #417993] Wed, 12 August 2009 07:26 Go to next message
babar82
Messages: 108
Registered: March 2009
Location: Karachi
Senior Member
Hi,

I have developed an application using forms 6i which is used by multiple clients. To run application at the client end I have to install oracle forms developer at the each client.
I want to know a few things.

1) Can I run my application without installing the whole forms developer on each client?

2) Can I add entry of my database in tnsnames.ora file through my application, by writing appropriate code with in my application?

Kindly guide me..

Re: configuring tnsnames.ora file [message #417997 is a reply to message #417993] Wed, 12 August 2009 07:42 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's no need to install Developer - install only Forms runtime components.

As of modifying the TNSNAMES.ORA file via your form, well, I guess that it is possible (although I don't know to do that). Perhaps you'd rather just copy already prepared TNSNAMES.ORA to every computer you need.
Re: configuring tnsnames.ora file [message #418079 is a reply to message #417993] Wed, 12 August 2009 21:01 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Are you running C/S or 3-tier?

David
Re: configuring tnsnames.ora file [message #418093 is a reply to message #418079] Wed, 12 August 2009 22:41 Go to previous messageGo to next message
babar82
Messages: 108
Registered: March 2009
Location: Karachi
Senior Member
I have simply placed my application folder on server and shared that folder for every client.

Re: configuring tnsnames.ora file [message #418114 is a reply to message #418093] Thu, 13 August 2009 01:16 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You might be able to update the 'tnsnames.ora' file by using 'utl_file' or 'text_io' but it would be more typical to have a windows batch script that did the installation of the Forms Runtime and then replaced the newly create 'tnsnames.ora' file with a 'common' version.

Are you implying that some of your users already have a 'tnsnames.ora' file on their PC and you need to add the reference to a new database to it?

David
Previous Topic: select multiple items from a list
Next Topic: Guidance for Beginners?
Goto Forum:
  


Current Time: Fri Sep 20 09:26:01 CDT 2024