SQL Server Stored Procedure error 1

[erika9star]

I'm attempting to use the sp_password stored procedure witin MS SQL Server in a PowerBuilder app.

DECLARE sp PROCEDURE FOR sp_password  
	@old 	= :s_old,
	@new 	= :s_new,	
	@loginame = :s_login
	using SQLCA;
	
	SQLCA.Autocommit = true	
	EXECUTE sp ;
	SQLCA.Autocommit = false

The SQLCA.sqlerrtext returns "SQLState=S1093 Invalid Parameter Number"

I've tried eliminating one parameter at a time, to try to get rid of the error, but I'm having no luck. Any ideas?

 

[BetterLateThanNever]

Hi,

Try altering the CallEscape and DisableBind parameters for the DBParm attribute of the transaction object. They take the following values:

CallEscape : 'Yes'/'No'
DisableBind : 0/1

itr_source.DBParm = "DisableBind=1,CallEscape='No',ConnectString='DSN=DBdsn;UID=DBA;PWD=SQL'"

Cheers

 

[erika9star]

Thank you! That worked perfectly.