Thursday, December 20, 2012 6:19 PM
I've got a CE 3.5 database file that I can open in Visual Studio but whenever I try to access it from code I get a SqlCeException with the following message.
OS Error: The OS storage system (RAM, CF, SD, or IPSM) is not responding. Retry the operation.
I'm just running on a standard laptop with Windows 8 installed.
Any ideas what might be causing this?
Friday, December 21, 2012 9:46 AMModeratorCould you share your connection string? It must be related to this, as Visual Studio uses the same ADO.NET provider to open the file. Is the file located on a local hard disk?
Please mark as answer, if this was it. Visit my SQL Server Compact blog
- Edited by ErikEJMVP, Moderator Friday, December 21, 2012 9:47 AM
Friday, December 21, 2012 9:48 AMModerator
Did you retry the operation?
When the database file is accessed before the block device driver (that allows you to access the database file) has started up after the device is restored from suspend mode, the issue may happen. You could try to apply the SQL Server Compact 3.5 Service Pack 1.
TechNet Community Support
Friday, December 21, 2012 10:44 AM
Thanks for replying.
@Maggie, I already have Service Pack 2 installed. Yes I did retry the operation, it failed again with the same error.
@Erik The connection string had a max database size setting in it. Removing that seems to have fixed the problem/given me a different error with my Entity Framework model. When I've resolved the issue with the model I'll be able to tell you if this was the issue.
Max Database Size=2047
Friday, December 21, 2012 11:11 PM
Okay, the very simple answer is this... the database file wasn't in the location the connection string was pointing to.
- Marked As Answer by Ben Crinion Friday, December 21, 2012 11:11 PM