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.