Unable to open connection to SQLCE databases (.SDF files) -- SQL Server Compact made an unsupported request to the host operating system.
Wednesday, December 05, 2012 3:28 PM
Whenever I attempt to open a connection (SqlCeConnection.OPEN) to one of my SQLCE database files--I receive the following error:
Internal error: SQL Server Compact made an unsupported request to the host operating system.
I ensured the file path was valid, however, the connection just will NOT open. This renders the application useless. (And ONCE AGAIN--the time spent "developing" this application, goes down the drain!!!)
Friday, December 07, 2012 1:49 PMModerator
Are you using encryption?
Could you share your connection string?
Please mark as answer, if this was it. Visit my SQL Server Compact blog
Sunday, December 23, 2012 9:43 PMModerator
If you experience any errors with the prefix "Internal error" while you use SQL Server Compact, try the operation again as the error might not reproduce.
Make sure you used correct connect string. SqlCeConnection.Open Method: http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection.open(v=vs.85).aspx.
Refer to Engine Errors: http://msdn.microsoft.com/en-us/library/ms171879.aspx.
TechNet Community Support
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Tuesday, January 08, 2013 10:05 AM