Cursor error when updating and sometimes when browsing through records...

I just finished my asp web sites. It works perfectly under PWS. When accessing it on IIS from my computer, and when I'm the only person browsing it, perfect, no problem.

BUT, as soon as two or more people are browsing it, I get server error regarding "bad cursor location" (Can't remember I'm home right now and the IIS server is at work).
When a user want to update a record he simply get the "Web Page not accessible" error. But this was working under PWS and when I'm the only user !?!

Anyway here's how I declared my DB connections and recordsets :

Code:

---

        '****************************************************
        '      DB Connection
        '****************************************************
        Dim objConn
        Set objConn = Server.CreateObject("ADODB.Connection")

        ' Ouvrir la Connexion
        objConn.ConnectionString = "DSN=" & Application("DBApp")
        objConn.Open

        '****************************************************

        '**************************************
        '    RecordSet
        '**************************************
        Dim rsLogiciels
       
        Set rsLogiciels = Server.CreateObject("ADODB.Recordset")
        rsLogiciels.ActiveConnection = objConn
        rsLogiciels.CursorType = adOpenKeySet
        rsLogiciels.CursorLocation = adUseClient
        rsLogiciels.LockType = adLockOptimistic
        rsLogiciels.Source = "Logiciels"
        rsLogiciels.Open
        rsLogiciels.MoveFirst

---

PLease help me !

Are you using a disconnected recordset?

If so you need to set the active connection to nothing after you open the recordset. I think you also have to have the locktype set to adLockBatchOptimistic.


Chris