I am using ADO and VB6 to run adhoc SQL queries. It seems that if you=20
run the following, ADO complains that there are two cursors running whi
ch is not allowed. Apparently Sybase does not like the set rowcount sta
tement. By the way, this query works fine using SQL Server 2000. So wha
t gives?
  
set rowcount 1
select * from mytable