Solved

Getting "The specified module could not be found" error when compacting SQL CE database.

Posted on 2008-06-26
2
1,495 Views
Last Modified: 2013-12-21
Hello,

I'm trying to programatically change a SQL CE Database's password. I found that the only way to do this is by compacting the DB, by calling the Compact() method while passing a new connection string with the new password.
This seems to be working fine when I test it using the Emulator, but I get a "The specified module could not be found" error when I test it on a physical PPC device. The error seems to happen when the Compact method is called.

Any ideas?

Thanks.
System.Data.SqlServerCe.SqlCeException was unhandled
  Message="The specified module could not be found."
  HResult=-2147024770
  NativeError=27777
  Source="SQL Server Compact ADO.NET Data Provider"
  StackTrace:
    at System.Data.SqlServerCe.SqlCeEngine.ProcessResults()
    at System.Data.SqlServerCe.SqlCeEngine.Repair()
    at System.Data.SqlServerCe.SqlCeEngine.Compact()
   InnerException: 

Open in new window

0
Comment
Question by:Mariano77
2 Comments
 
LVL 48

Accepted Solution

by:
Mikal613 earned 250 total points
ID: 21882746
 Do you have the SQL Compact runtime installed, and, do you have the sqlcecompactxx.dll and sqlcesexx.dll in your device?
0
 

Author Comment

by:Mariano77
ID: 21886954
The SQL runtime is installed - if I comment out the Compact() method in my code, the app runs fine.
Where do I check for those 2 dlls?

Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When I was a beginner in Windows Mobile programming, even for small test I used to create a single MFC dialog-based application with one button, and put my test code in the OnLButtonDown method. For Pocket PC it worked fine, on some Windows CE d…
I recently asked a question (http://www.experts-exchange.com/Programming/Smartphones/Android/Q_28684946.html) about Computer Inventory applications for Mobile Devices.  I was specifically interested in an app I could use on my android phone.  The be…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question