error the operation is not supported on the object.

Im afraid I dont have much more to offer but please post the resolution when you find it. The Recordset objects State property can have a combination of values.įor example, if a statement is executing, this property will have a combined value of adStateOpen and adStateExecuting. Remarks You can use the State property to determine the current state of a given object at any time. Tivoli Storage Manager operations: Restore VM Transport: SAN, HOTADD, NBD, NDBSSL Explanation/Actions: In some cases, restoring a virtual machine might be difficult because of settings that are placed in the virtual machine's extraConfig attribute.

Return Value Returns a Long value that can be one of the following constants. Message: visdkCreateVM > The operation is not supported on the object. Please post it and also display the connection states as previously posted.ĭescribes for a Recordset object executing an asynchronous method, whether the current state of the object is connecting, executing, or fetching. You keep saying there is nothing wrong with the SQL but there is. It seems that your code is failing to open the RS and the most likely reason for that is failure of the query. You appear to be looping through some cells and taking what is there to build your query when the one cell postings. If it returns x then you are definitely hitting the database properly.įrom your code snippet we dont have a clue what that query might look like. Just for grins right before the open add this: strSql select x as x into Temp Then run it and stop the program, make a break point, go to a SQL session using the same connection as the program. Code That IĮrror The Operation Is Not Supported On The Object. Error The Operation Is Not Supported On The Object.

Error the operation is not supported on the object.