PRB: Data Environment: Error Setting Lock Type

When trying to use Pessimistic locking and Client Cursors, Visual Basic generates the following error message:
Under Microsoft Data Access Components (MDAC) version 2.5, the error message appears as

Pessimistic locking is not available with Client cursors in ADO or the Data Environment.

Change your cursor to Server-Side or change your lock type.

This behavior is by design.

Note that Pessimistic locking on server-side cursors must be supported by the driver/provider in order to use this functionality in ADO. SQL Server and Access drivers and providers have this functionality whereas Oracle does not.

Under MDAC version 2.5 or later, you cannot set the locktype to Pessimistic when the cursor location is set to aduseclient. The above error will be returned immediately.

Steps to Reproduce Behavior

1. Run Visual Basic 6.0 and open a new Standard EXE Project. Form1 is created by default. Add a DataEnvironment to the project.
2. In the Data Environment Window, right-click the default Connection1 object, choose Properties from the shortcut menu, choose the Connection tab, and then select the Use Connection String option.
3. Enter your Connection String to a valid data source. This example will use SQL Server's pubs database and the authors table, such as:

         CONNECTIONSOURCE="PROVIDER=sqloledb;DATA" & _
                          "SOURCE=<server_name>;" & _
                          "INITIAL CATALOG=pubs;" & _
                          "USER ID=<uid>;PASSWORD=<pwd>;"
   
   					

4. Click OK.
5. Click the Add a Command object to open a table.
6. Set the Command Name to Authors.
7. Change the Database Object to Table.
8. From the list of tables, select Authors.
9. Change the locktype to Pessimistic. The location is aduseclient by default.

Result: