Re: forms and reports 6 not connecting to oracle

harish wrote:
> this is the solution from your side
> Have you defined the TNS_ADMIN environment variable? If not do that, then
> ftp the server's tnsnames.ora and sqlnet.ora files to the TNS_ADMIN
> directory. If you do not want to do this, then ftp the server's
> tnsnames.ora and sqlnet.ora files under <forms_directory>/network/admin
> subdirectory. It looks at this directory by default (at the end).
> hope this helps.
>
> sir,
> thanks for your response
> but please give me details about
> 1)how to define TNS_ADMIN environment variable?
> 2)how to ftp the server's tnsnames.ora and sqlnet.ora files to the TNS_ADMIN
> directory.
> 3)ftp the server's
> tnsnames.ora and sqlnet.ora files under <forms_directory>/network/admin
> subdirectory.
> thanks in advance.

He was replying as though you were on a Unix box. In Windows, you don't have an ftp server installed by default, so open an Explorer window and copy your working tnsnames.ora and sqlnet.ora files (probably in c:\oracle\ora81\network\admin) to the equivalent directories for forms/reports (depends on what you answered when you installed). If you do a 'search' of your hard disk when you're done, every tnsnames.ora and sqlnet.ora, in any directory, should have the same date. You can also set a system environment variable, TNS_ADMIN to point to the good directory, in Control Panel -> System -> Advanced tab -> Environment Variables button. Received on Wed Oct 23 2002 - 18:30:03 CEST