Re: tnsnames.ora, OCI and ORA-12514

[Quoted] Is this on NT ? If so is the path to the home directory set in the user [Quoted] path or in the system path, in your case it has to be in system path...

MarcM
<vpdev_at_my-deja.com> wrote in message news:8ofpk0$fk8$1_at_nnrp1.deja.com...
> My apologies if this has been covered before - I searched the archives
> and couldn't find anything.
>
> I have been writing a daemon program that uses the Oracle 8.1.5 OCI
> functions to process some queries against a database on a different
> machine, connected via TCP/IP.
>
> From the command line, I can connect to that database with no problem
> using sql*plus, and a tnsping works as well. If I start up the program
> from the command line in the directory with the tnsnames.ora file, it
> will work great.
>
> When I start it up as a daemon, however, or in any directory that is
> not where the tnsnames.ora file is, I get the dreaded ORA-12514 error
> message.
>
> I have checked all the appropriate environment variables, but for
> security reasons this daemon must wipe it's environment and start
> clean. I thought this might be the problem, so I specifically imported
> TNS_ADMIN and ORACLE_HOME (among other variables) on program init, but
> still no joy.
>
> Has anyone run into this before? What am I missing here? I know I'll
> probably kick myself once I finally do find the answer, but any help at
> all would be greatly appreciated.
>
> Thanks in advance,
>
> Bob Vastine-Parker
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Aug 30 2000 - 04:16:27 CEST