Table-level locks instead of Row-level locks

G

Galloy

New Member
Hi,
We are working with Progress V9.1E and SQL Server 7 Ent. DS 9.E1, and our database is on a SQL2005 server. When the application do an update of the SQL database, the table(s) concerned by this update is (are) locked (and not only the record(s) concerned) .
Thus my application exhibits frequently records (tables) lock contention.
I have place the database instance in MS SQL Server 2000 compatibility mode, but this table-level locks problem stay.
Could you please help me to solve this very penalizing problem.
Thank you.
Olivier
 
I'm no specialist on this at all, but, AFAIK, you need to set the isolation level on the ODBC data source.

HTH, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top