Table locking problem
Posted on 2006-11-09
I have a VB.NET application that uses OLEDB to connect to DB2. the DB2 database is also used by another application that uses UNIFACE to establish connection and manage the locking state of the various tables.
When the application that uses uniface is open, I get deadlock errors.
Below is the connection string I am using:
connection.ConnectionString = "Location=""" & IPaddress_tbox.Text & """;Provider=""IBMDADB2.1"";Mode=readwrite;User ID=" & user_tbox.Text & ";Data" &
" Source=" & database_tbox.Text & ";Password=" & password_tbox.Text
It appears that I am locking exclusive on any table I open for output. How can I make it so that the sharing mode is such that other applications (not .NET) can be reading/writing at the same time?