Unable to open connection to SQLCE databases (.SDF files) -- SQL Server Compact made an unsupported request to the host operating system.

Question

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!!!)

Answer 1

Are you using encryption?

Could you share your connection string?

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog

Answer 2

Hi Robert,

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.

Thanks.

---

Maggie Luo
TechNet Community Support