ODBC function sequence error

  • We are trying to upgrade a SQL server 2000 to a SQL 2008 R2 (SP1) server.

    After migrating, the developer test code, and got an error:

    ERROR [HY010] [Microsoft][ODBC SQL Server Driver]Function sequence error

    What could be wrong?

    I checked online there is a hot fix possibly related with this:

    https://support.microsoft.com/en-us/kb/959796

    But this is a release for 2008, ours is already 2008 R2 SP1, so that hot fix should already be included since it is always cumulative.

    What else should we check?

    Thanks

  • The cumulative update on SQL 2008 should also be available in 2008 R2.

    Can you please provide more information on the error you are getting?

    Do you have any Linked Servers and what sources you are connecting to?

  • The developer got that error when calling from web application,

    We are not using linked server. It works when it is using SQL 2000, after I migrate this database to SQL 2008 R2, it does not work

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply