by Matt Janofsk » Wed, 30 Jul 1997 04:00:00
How does one update the TNSNames.ora file programmatically? I know there
is already a TNSNames file in use on the PC. I'd like to add mine to it
during the installation and setup. Is there a DDE command or other tool
for doing this or do I have to actually open the file and write directly to
it?
Matt
by Roy Klasse » Fri, 01 Aug 1997 04:00:00
The Oracle Network Manger tool is the best for creating all SQL*Net files
(LISTENER.ORA, SQLNET.ORA and TNSNAMES.ORA).
I would trust this tool more than editing the TNSNAMES.ORA file manually,
because I think there are some hidden tabs and spaces in these files. If
you don't have them, it does not work.
Quote:> How does one update the TNSNames.ora file programmatically? I know there
> is already a TNSNames file in use on the PC. I'd like to add mine to it
> during the installation and setup. Is there a DDE command or other tool
> for doing this or do I have to actually open the file and write directly
to
> it?
> Matt
by Matt Janofsk » Sat, 02 Aug 1997 04:00:00
But does it expose an API so I can do it from a VB program or Setup
routine?
> I would trust this tool more than editing the TNSNAMES.ORA file manually,
> because I think there are some hidden tabs and spaces in these files. If
> you don't have them, it does not work.
> > How does one update the TNSNames.ora file programmatically? I know
there
> > is already a TNSNames file in use on the PC. I'd like to add mine to
it
> > during the installation and setup. Is there a DDE command or other
tool
> > for doing this or do I have to actually open the file and write
directly
> to
> > it?
> > Matt
by Jian M » Thu, 07 Aug 1997 04:00:00
I'm trying to create these .ora files for my Unix environment. Where can IQuote:> > I would trust this tool more than editing the TNSNAMES.ORA file
manually,
> > because I think there are some hidden tabs and spaces in these files.
If
> > you don't have them, it does not work.
Thanks
by terryg » Thu, 07 Aug 1997 04:00:00
> > > I would trust this tool more than editing the TNSNAMES.ORA file
> manually,
> > > because I think there are some hidden tabs and spaces in these files.
> If
> > > you don't have them, it does not work.
> I'm trying to create these .ora files for my Unix environment. Where can I
> find this Network Manager in Unix? Or I can use Network Manager for Windows
> to create a set of files for my Unix box?
> Thanks
1. Updating the TNSNames.ora file
SQLNET can be used or the old Windows 3.1 Network Manager. They are both very
simple to use.
Editing the file will not work as there are some hidden characters.
Thomas Ladew
3. sample file of tnsnames.ora,listener.ora,sqln
4. DTS Import/Export Wizard Error: CoCreateInstance
5. Updating TNSNAMES.ORA file from the command line?
7. updating tnsnames.ora and host file
8. backup
9. tnsnames.ora, sqlnet.ora, listner.ora
11. Enable new settings in the TNSNAMES.ORA file
12. multiple tnsnames.ora files