SQL Error "Optional feature not implemented"

BorisK

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?

kriki

[Topic moved from Navision forum to SQL General forum]

ara3n

googling came up with the reason

The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly.

recompile all the objects. Or Export and then import all the objects.