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
