We help IT Professionals succeed at work.
Get Started

MSSQL 2008 R2 Express: Invalid Cursor State error 24000

IT_Architect
IT_Architect asked
on
1,264 Views
Last Modified: 2012-05-09
Situation:  I recently converted a customer from SQLAnywhere to MSSQL 2008 R2 Express.  The app has worked fine for years with SQLAnywhere.  I've made these conversions many times before with 2005 with no issues.  The clients are Windows 7 Home Premium, Windows XP professional, and SBS 2008.  All clients are patched up to the latest.  I also installed the latest MSSQL 2008 R2 client drivers.

Behavior:  When running the app with my development computer, XP, or the SBS 2008 computer, the app runs without error.  However, running it from other XP clients on the network or another development machine running Windows 7, I consistently encounter the Invalid Cursor State 24000 error in the same areas of the app.

Solution required:  Determine how to enable the other computers to be able run the app without error.
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE