SQL Error "Optional feature not implemented"

BorisKBorisK Member Posts: 45
edited 2007-11-28 in SQL General
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?


  • krikikriki Member, Moderator Posts: 9,086
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • ara3nara3n Member Posts: 9,255
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer

    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.