For one of our customers we are trying to upgrade Navision SQL client version from 3.60 to 4SP3. We successfully created a test database for vanilla 4SP3 but they decided that they wanted to go further and take it to 4SP3 Update 6. We restored their live SQL backup into a test database and converted it. On the surface it looks OK but they came across a SQL error which we can't understand. For some Tables when attempting to insert a record (whether in code or manually) an error pops up:
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
State ID: HYC00
When trying again a different one appears:
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect
State ID: 07002
We can't see anything common for the Tables where the error occurs.
Any ideas anyone?