CEQuery, create database error

Question

Hi. Im using Windows 7 Enterprise, SQL Server Compact 4.0 and CEQuery.

When im attempting to create a database in CEQuery, i get this error:

"Unable to load the native components of SQL Server Compact corresponding to the
ADO.NET provider of version 8482. Install the correct version of SQL Server
Compact. Refer to KB article 974247 for more details."

How can i solve this error?

Thanks.

---

pyram

Answer 1

I solved like this:

from this link:

http://cequery.codeplex.com/discussions/287053

go to "C:\Program Files\Microsoft SQL Server Compact Edition\v4.0" [Assuming this is the location for SQL CE4] and copy the following DLLs and paste the same in the CEQuery Installation Directory ["C:\Program Files (x86)\Mayukh's Lab\CEQuery", assuming this is the CEQuery install location].

• sqlceca40.dll
• sqlcecompact40.dll
• sqlceer40EN.dll
• sqlceme40.dll
• sqlceoledb40.dll
• sqlceqp40.dll
• sqlcese40.dll

This worked.

Thanks.

---

pyram