Hi
I am using this code for getting data from database

mCN = New OleDb.OleDbConnection(sConnStr)
mCN.Open()
DtSet = New DataSet()
Cmd = New OleDb.OleDbDataAdapter(SQLStr, mCN)
Cmd.Fill(DtSet, TableName)

But I have a problem.
After a very few queries the data base gets locked
and no one can access the site. All the queries/functions raises errors.
On the machine that has the IIS I get a message:
this data base is opened exclusively by… (the user that logged on this computer (the IIS))
If I wait, then it's releases and I can continue working for another 2-4 queries.

Any suggestions?

Limor