Invalid Cursor Position

  • Dear all

    I am using a database application which was developed in Sql server 2000 and VB 6.0. It was working fine there in SQL 2000.

    Now I restore the database in SQL Server 2008 with sql server 2000 compatibility mode, and it is working fine but some for the screens are showing the error "invalid Cursor Position", Is there any setting which i forgot to make in SQL 2008.

    Please help me out.

    Nitin

  • There is no single setting in SQL Server which is responsible for this sort of behaviour.

    There are mulitple reasons for this error to happen. Are you using TEXT datatypes anywere within your database and reading it by GetChunk method?

    You might need to investigate problems case by case.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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