 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server CE / February 2008Sql CE 3.0 Mobile Edition and PPC2003SE
Hello, I have a serious problem while developing CF2.0 .NET application on PPC2003SE. I installed all 3 SQLCE cabs but cannot perform compact database operation - it throws me away from application. Is it possible to use compacting on PPC2003SE (mine is hx4700) - I tested on WM5 and WM6 devices - worked fine. thanks for answer in advance Jacek, I no longer have a PPC2003SE device to test with, but might you be running out of room on that device?  SignatureGinny Caughey Device Application Development MVP www.wasteworks.com Software for Solid Waste Management > Hello, > [quoted text clipped - 6 lines] > worked fine. > thanks for answer in advance It was not memory issue - I have kind of 10MB of free memory before started compact database - this look like some compacting bug. I thought it might be wrong cab file, but I can read and save data to SQL Server CE. This looks like unhandled exception - cannot catch it :-(. As I said this is HP iPAQ hx4700 - I installed the following cab files from this location D:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Device\Mobile\v3.0\wce400\armv4\: - sqlce30.ppc.wce4.armv4.CAB - sqlce30.dev.ENU.ppc.wce4.armv4.CAB - sqlce30.repl.ppc.wce4.armv4.CAB So I think these are all possible cab files. Additionally application folder contains System.Data.Common.dll and System.Data.SqlServerCe.dll. How can I handle this situation? cheers Those look like the right cabs. What is the error message that you get? How large is the database you're attempting to compact? Do you have problems with other aspects of working with that database on the device? SignatureGinny Caughey Device Application Development MVP www.wasteworks.com Software for Solid Waste Management > It was not memory issue - I have kind of 10MB of free memory before > started [quoted text clipped - 16 lines] > > cheers The database has 320K, I get no error message - it just terminates application:( I have only problem with compacting - nothing else - normally I can perform queries, update rows. I remember in SQLCE 2.0 compact operation was possible to be done without need to install dev and repl cabs, but I tested that SQLCE30 needs one of them. I even performed factory reset and installed everything from new, but did not help. It looks like compact database was not possible in CF20 application using SQLCE30 on hx4700 :-) It sounds like you're missing the SQL CE Engine DLL since that's the main thing that would be different about compacting a database compared with ordinary reading and writing to it. What are the SqlCe DLLs that got installed on the device? SignatureGinny Caughey Device Application Development MVP www.wasteworks.com Software for Solid Waste Management > The database has 320K, I get no error message - it just terminates > application:( [quoted text clipped - 7 lines] > not > possible in CF20 application using SQLCE30 on hx4700 :-) Here are the files I found on PDA after those 3 cabs installed: \Program Files\SQL Mobile\EN\isqlw30.exe \Windows\sqlceer30EN.dll \Windows\sqlceoledb30.dll \Windows\sqlceca30.dll \Windows\sqlcecompact30.dll \Windows\sqlceme30.dll \Windows\sqlceqp30.dll \Windows\sqlcese30.dll Well all the DLLs are there. I'm sorry but I really don't know what else to suggest at this point since I don't have a device like yours to try this with. SignatureGinny Caughey Device Application Development MVP www.wasteworks.com Software for Solid Waste Management > Here are the files I found on PDA after those 3 cabs installed: > \Program Files\SQL Mobile\EN\isqlw30.exe [quoted text clipped - 5 lines] > \Windows\sqlceqp30.dll > \Windows\sqlcese30.dll Jacek, Does your app / the part that performs compact database, work on your desktop? Erik > Here are the files I found on PDA after those 3 cabs installed: > \Program Files\SQL Mobile\EN\isqlw30.exe [quoted text clipped - 5 lines] > \Windows\sqlceqp30.dll > \Windows\sqlcese30.dll >Hello, > [quoted text clipped - 4 lines] >worked fine. >thanks for answer in advance Add sqlcecompact30.dll to your project set its properties->build action as content. Run the app and test again. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.