I am using SQL server and IWS 7.1 on Beckhoff CX1020-0111
When I open Grid Objects or attempt to trend data using a trend sheet, I receive the error "Specified CAST is not Valid"
When I use the Database ERP connection with VBS functions, THe connection succeeds.
Both the Primary database connection(WHich is used by Grid Objects and Trend Worksheets)and the DataBase ERP connections are configured the same.
Why would one work and not the other?
Cast usually indicates a mismatch in data type, but I have already eliminated that possibility. Furthermore, If i do something like delete the table the grid object is attached to, I still get the same error. One would think that the error would change to "Data source doesn;t exist" when the table doesn;t exist.