Posted by: Jeremy Kenny
I am having problems executing MS SqlServer 2000 Stored Procedures from
within my Gupta TD 3.1 PTF 2 application. I connect via OLE.
I would like to add , delete , and amend a users password from my
application but can't seem to manage it. An example bit of code that I have
written to amend a users password is below.
Any help would be appreciated.
Set sCall = "EXEC sp_password 'AAA', 'BBB', 'Cupidev' "
If SqlPrepareSP (hSqlA, sCall, STRING_Null)
Call SalStatusSetText( hWndForm, 'Password changed' )
Posted by: Anton Lwow
SqlPrepareAndExecute( _hSqlDDL, _"SP_PASSWORD NULL, " || strPassword || ", "
|| strName )
and it works, but i dont use OLE.
May be need also
Call SqlSetParameter( _hSqlDDL, DBP_AUTOCOMMIT, TRUE, '' )
"Jeremy Kenny" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
Posted by: Martin Duty
Is this what you are looking for? You will need to change some data on the
App_Startup to work.
Underground Vaults & Storage, Inc.
TD 3.0 PFT2
Client Win 2K/XP
Database MS Sql Server 2000
Who is online
Users browsing this forum: [Ccbot] and 0 guests