|
Home > Archive > SQL Anywhere Mobile > August 2005 > How to sync server & remote pwd to keep it same.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to sync server & remote pwd to keep it same.
|
|
|
| create proc sync_pwd @auth_status int out, @user_name varchar(128), @pwd
varchar(128), @new_pwd varchar(128)
as
begin
declare @rc int
exec @rc = sp_password @pwd, @new_pwd, @user_name
if @rc = 0
begin
select @auth_status = 1000
return 1000
end
select @auth_status = 4000
return 4000
end
script in authenticate_user event will not work. tried both format.
exec sync_pwd ?,?,?,?
OR
declare @rc int
exec @rc = sync_pwd ?,?,?,?
return @rc
also the same script in authenticate_user_ha
shed also will not work.
How to sync server & remote pwd to keep it same.
thanks
vsv
| |
| David Fishburn 2005-08-30, 9:30 am |
| "vsv" <nospam@nospam.com> wrote in news:430cadbf$1@foru
ms-1-dub
of sybase.public.sqlanywhere.mobilink:
Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng9 -v).
v> create proc sync_pwd @auth_status int out, @user_name varchar(128),
@pwd
v> varchar(128), @new_pwd varchar(128)
v> as
v> begin
v> declare @rc int
v> exec @rc = sp_password @pwd, @new_pwd, @user_name
v> if @rc = 0
v> begin
v> select @auth_status = 1000
v> return 1000
v> end
v> select @auth_status = 4000
v> return 4000
v> end
It would useful in this case to know what your consolidated is?
Microsoft SQL Server?
ASE?
ASA?
v> script in authenticate_user event will not work. tried both format.
v> exec sync_pwd ?,?,?,?
You could try:
{ ? = exec sync_pwd ?,?,? }
or
{ exec sync_pwd ?,?,?,? }
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
|
|
|
|
|