VS 2003
DOT.NET Framework 1.1
Database: Sybase Adaptive AnyWhere 9.02
Using ODBC as database-interface

Sometimes I get LOCKS on a table, after I have made only a select on the
table.
100 times the code is working properly, but than it happens.
DIRECT behind the SELECT , the table has a SHARED-LOCK [S].
There is only this user to work with the Table.

Is this a known problem in VS.2003 ??

Thanks For any hint.
Peter Stojkovic

CODE:
f_check_for_locks()
li_count = 0
ls_sql1 = " SELECT count(*) FROM DBA.die_remarks WHERE rms_press =  123"
l_reader = f_ExecuteSQLSelect(ls_sql1, SQLCA_server_front)
Do While l_reader.Read()
   li_count = l_reader.GetInt32(0)
Loop
l_reader.Close()
f_check_for_locks()