Multiuser Problems

[Guest_imported]

I have a visualBasic application with ADO control, the data base is SQL server.
The conecction:
Dim cn As ADODB.Connection
With conect
.ConnectionString ="myconectionstring"
.CursorLocation = adUseClient
.Attributes = adXactCommitRetaining
.Open
.BeginTrans
End With

The redorsets:
Dim rs As ADODB.Recordset
rs.Open "select from MyTable", cn, adOpenStatic, adLockReadOnly

And it does not work in multiuser mode. ¿Does someone Knows why?
¿Has SQL server any property which change this mode?

Thanks

 

[Cagliostro]

I think you have a bad function calling order:
With conect
.ConnectionString ="myconectionstring"
.Open
.CursorLocation = adUseClient
.Attributes = adXactCommitRetaining
.BeginTrans
End With Ion Filipski

filipski@excite.com