LOCKS on database-Table with ODBC and Sybase 9.0

  • Thread starter Thread starter Peter Stojkovic
  • Start date Start date
P

Peter Stojkovic

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 .
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()
 
a) dont use Sybase
b) don't use ODBC
c) don't use 1.1; it's not as powerful as vb6 or 2.0
 
Back
Top