Get "Unable to cast object of type..." error when validating where clause in data compare (148241)
Get "Unable to cast object of type..." error when validating where clause in data compare
The below error is being returned when validating the WHERE clause added for a data compare. This only seems to happen for an Oracle connection.
Unable to cast object of type 'Quest.Toad.Oracle.Proxy.OracleProxyConnection' to type 'Devart.Data.Oracle.OracleConnection'.
This issue is caused by using a Oracle 64-bit client. Data Compare does not support the 64-client like the rest of the product.
Connect using a 32-bit Oracle client, instead of a 64-bit Oracle client.
Waiting for enhancement ID 'QAT-4792' to be implemented in a future version of Toad Data Point.
© 2018 Quest Software Inc. ALL RIGHTS RESERVED.