Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

Error 1252 connecting Oracle

« Go Back

Information

 
Article Number000011929
EnvironmentProgress 9.x
OpenEdge 10.x
WebSpeed 3.x
Oracle
Windows 32 Intel
Question/Problem Description
Error 1252 connecting Oracle
ORACLE error see "ORACLE Error Messages and Codes Manual". (1252)
Oracle error ora-01012 : not logged on
AdminServer running as a service on Windows.
WebSpeed/AppServer can not connect to Oracle
Prowin32 might be able to connect to oracle in the same machine
SqlNet used to connect Oracle
SqlNet configured to use NTS to validate logon information
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
As AdminServer is running as service under Windows, this services has its own login/password, that might be different from the one logged for desktop activities, and if this user used to login AdminServer is not authorized to connect Oracle using NTS, either WebSpeed/AppServer may fail to connect Oracle.
Resolution

To fix it:

1 - Add this user to the ones authorized to connect Oracle.

2 - Modify SqlNet to use an standard model user/password provided the application, doing the following steps:

a) Open your sqlnet.ora file located in your oracle installation

b)  add comment or remove the line: SQLNET.AUTHENTICATION_SERVICES= (NTS).

Workaround
Notes
Attachment 
Last Modified Date9/13/2015 11:04 AM