Invalid cursor state

[Former Member]

Hi:

I'm looking forword you could help me!

The software is SAP Business One 2005B PL42

The question is:Storage Process Program could run successfully at SQL Server 2005 but when the query interface transfer it by parametres,the error comes and System massage says that [Microsoft] [ODBC SQL Server Driver] invalid cursor state.

Somebody tells me the reason is that there is at least one cursor isn't closed in time,but why It could run at SQL Server 2005 ?and I have already checked the program serval times,but

I really don't know why!

Thank you!

[antonio_voce · Accepted solution]

Install the latest SQL service pack!

Antonio Voce.

[Former Member · Accepted solution]

Hi:

First thank you for answering me!

My SQL Server 2005 has already installed the newest pack SP2,the problem is it can't run at SAP Bussiness One but

it run well at SQL Server 2005 .