> CREATE PROCEDURE SP_WEB_UPDATEACCOUNT (
> AID INTEGER,
> FNAME VARCHAR (30) CHARACTER SET WIN1251,
> LNAME VARCHAR (30) CHARACTER SET WIN1251,
> ADDR1 VARCHAR (100) CHARACTER SET WIN1251,
> ADDR2 VARCHAR (100) CHARACTER SET WIN1251,
> CITY VARCHAR (30) CHARACTER SET WIN1251,
> STATE VARCHAR (2) CHARACTER SET WIN1251,
> ZIP VARCHAR (10) CHARACTER SET WIN1251)
> AS
> declare variable PrimaryID integer;
>
> This error is generated when doing an execute statement from ASP.
> However I do not believe it is an ASP error. Below is the statement
> that I execute that works in EMS but not in ASP.
>
> EXECUTE Procedure SP_WEB_UPDATEACCOUNT
> (1,'Smith','John','Blah','Rear','Blah','US','99999')
>

so no return values?
please show us the snippet of asp code
Alan