PRB: Data Environment: Error Setting Lock Type

MORE INFORMATION

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: