local connection using pro-cobol

From: Baylis, John <JBaylis_at_mail.canfor.ca>
Date: Thu, 19 Jul 2001 11:24:32 -0700
Message-ID: <F001.0034EE98.20010719111626@fatcity.com>

I have a pro-cobol application running on my database server. I am trying to use a local connection in a pro-cobol program but I get an ora-12154 error if I do not have the listener running on a win2000 server using net8. It appears as if it it using a sqlnet connection instead of a local connection.

I am using:

connect user_name/password

I have the oracle_sid=sid and local=sid environment variables set in my batch file.

I can shutdown the listener and run 'sqlplus user/password' successfully from the cmd window.

Why will pro-cobol not work?

John Baylis
DBA / Systems Administrator
Canadian Forest Products Ltd.
Vancouver B.C. Canada Received on Thu Jul 19 2001 - 13:24:32 CDT