Re: pro C db connect using TWO_TASK?

In article <2m39oi$t1p_at_pandora.sdsu.edu>, gtupper_at_monkfish.nosc.mil (Greg Tupper) writes:
|> 1. I have a pro-c application that connects to the database using a
|> username/passwd string generated by the program.
|>
|> 2. The program connects successfully to the database if the
|> TWO_TASK environment variable is not set.
|>
|> 3. If I do set the TWO_TASK I get an oracle error 6401 when I run
|> the program. (Error message follows):
|> SQL ERROR: sqlcode :-6401 ORA-06401: (Cnct err, can't get err txt.
|> See Servr Msgs & Codes ManuaNOT SET
|> %code64sun[thorson]26 > oerr ora 6401
|> 06401, 00000, "NETCMN: invalid driver designator"
|> // *Cause: The login (connect) string contains an invalid driver
|> designator.
|> // *Action: Correct the string and re-submit.
|>
|>
|> 4. I am able to connect to the database using sqlplus
|> <username>/<password>
|>
|> What am I forgetting here?
|>
|>
|> Greg TUpper
|> SAIC ComSystems
|> gtupper_at_nosc.mil
|>

When you do not have TWO_TASK set, you are connecting directly to the database. With TWO_TASK, you are (trying to) go through SQLNET. Apparently, your SQLNET is not configured as you expect. Either your TWO_TASK variable is set incorrectly or you have a problem in your SQLNET configuration.

Check to make sure that you have both /etc/tnsnames.ora and /etc/sqlnet.ora or their equivalent if you are running on a non-UNIX system.

-- 
Derek Fields
(derek_at_gamekeeper.bellcore.com)