If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > Determining server details from library

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-15-10, 14:59
jarchies jarchies is offline
Registered User
 
Join Date: Jun 2010
Posts: 9
Question Determining server details from library

How would i know whether sybase ase server is accepting encrypted password or not? (i mean whether user has set "net password encryption reqd",1)
My code fails while logging in ASE server when encryption is enabled/disabled. I have to change my code according to sybase ase server setting.
Reply With Quote
  #2 (permalink)  
Old 06-23-10, 10:03
sudarao sudarao is offline
Registered User
 
Join Date: Mar 2007
Posts: 72
Hi,
Why dont you check if you can establish connectivity using either encrypted or otherwise, like this;

isql -U<user> -S<server> -P<password> << EOF >> temp.log
select @@servername
go
exit
EOF

grep -c 'Msg' temp.log > /dev/null
if [ $? = 0 ]
then
< not able to log on using password type >
fi

suda
Reply With Quote
  #3 (permalink)  
Old 06-27-10, 11:16
jarchies jarchies is offline
Registered User
 
Join Date: Jun 2010
Posts: 9
Red face

no?
i am interested to get information from programming point of view.
i mean using Native C/C++ API libraries.
-X option in isql allows u to login through encrypted password
Reply With Quote
  #4 (permalink)  
Old 06-28-10, 07:36
Martijnvs Martijnvs is offline
Registered User
 
Join Date: Jan 2004
Location: The Hague/Utrecht, NL
Posts: 396
The easiest is to just ask your DBA/sysadmin.
__________________
I'm not crazy, I'm an aeroplane!
Reply With Quote
  #5 (permalink)  
Old 06-28-10, 14:00
jarchies jarchies is offline
Registered User
 
Join Date: Jun 2010
Posts: 9
well point is if at dba side it changes, code should be dynamic to take decision on it;s own.
so asking administrator , definitely now, tomorrow he would say configuration changed.
well let me point out here there are option ..ENCRYPTION on sp_con_props where u can set password encryption and still logon with both encrypted and plain password.
ditch is later sybase gave other option in which he said to logon with only with encrypted password and plain would be rejected
Reply With Quote
Reply

Tags
sybase, sybase ase

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On