Hi,

I'm trying to open a SQL Server database exclusively using ADO. I'm setting the mode property of the connection to adModeShareExclusive as follows:

cn.Mode = adModeShareExclusive
cn.Open strCnn

Unfortunately, other users are still able to connect to the database. Does anyone have a solution to this ?

This property works well with MS Access but not with SQL Server.

Waiting for an early reply.


BSA

A SQL Server connection is made to the database server, unlike Access where a connection is made to a single database, so this connection mode cannot be supported in SQL Server (OK you can specify the initial db in the conn string, but no locks are created at this stage). What you do instead will depend on why you feel you need to shut all other users out of the database entirely. I suggest you start by reading up on transaction support in SQL Server, particularly Isolation Levels.