'Not an Updatable Set' problem with OOLE

Hi All

We are using the OOLE 1.0.55 data controls in the place of the standard VB data control in many of our applications. We connect to Oracle 7.1.4 on HP server in the backend.
The problem we are having in one of the front applications is that, at random times, a normal SELECT query with some simple join condition (positively, without 'SELECT FOR UPDATE's) comes back with an OLE automation error 4117. This error does not occur when we set the RecordSource property of the data control to the SQL string and Refresh. This error occurs when we do a dbMoveFirst or dbMoveNext after refresh. The 4117 error is supposed to come when we attempt to make an update on a non-updatable set. In our case, we clearly are not attempting to make an update, 'cause we are not trying to change
any fields in the record set. The data control handles simple two table join queries.

I could be missing something here. Any thoughts are welcome.

Thanks in advance

Murthy Jarugumilli
murthy_at_tcs.com
TCSI. Received on Wed Nov 15 1995 - 00:00:00 CET