Re: Error running sp in sybase

1. Please try this first:

cmd.Execute affected, 128 'returning no records

I think this should be

cmd.Execute affected,, 128 'returning no records

Note the extra comma.
The "options" for command Execute should be the 3rd parameter as the 2nd
parameter is any supplied parameters collection.

2. But as an explanation:

I do not do ASP nor Sybase but as an educated guess:

I think a Recordset is attempted to be returned and it will be ForwardOnly.
With this cursor type, mnay providers are such that you can only have 1
active per connection.
So if your ASP is called for the 2nd+ time while the 1st time is still being
serviced, this message will occur.

Stephen Howe



.