I’m trying to get my clarion app to work with a MSSQL database.
It currently works fine with a sybase database but my bosses are keen to eliminate sybase from our system as a lot of stuff is done in MSSQL and we have to have sybase communicating with MSSQL all the time. The clarion app is the only thing that uses the sybase database.
The app will connect to the MSSQL database and some stuff works ok but when trying to open certain screens I get an error: This record was changed by another station. Error: (Invalid character value for cast specification(22005)).
I thought the problem was just to do with data types but I’m pretty certain that they are all good.
Does anyone have any ideas?