Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server Stored Procedure error 1

Status
Not open for further replies.

erika9star

Programmer
Apr 30, 2003
2
US
I'm attempting to use the sp_password stored procedure witin MS SQL Server in a PowerBuilder app.

Code:
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?
 
Hi,

Try altering the CallEscape and DisableBind parameters for the DBParm attribute of the transaction object. They take the following values:
Code:
CallEscape : 'Yes'/'No'
DisableBind : 0/1

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

Cheers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top