Browse by Tags

Re: Can't find PInvoke DLL 'SQLite.Interop.059.DLL'.

I'm using SQLite 065 and I had the same problem. Deploying BOTH SQLite.Interop.065.DLL and SQLite.Interop.065.lib along with the main sqlite dll solved the problem and it's working like a charm. One more thing to mention is: SQLite is waaaaaaaaaaaaay much faster than SqlCe and I'm gonna fall...

Posted to General (Forum) by mmsaffari on 01-27-2010
fastest way to insert 100.000 records from one database to another

Hello, I have a mobile application. My client has a large data set ~100.000 records. It's updated frequently. When we sync we need to copy from one database to another. I have attached the second database to the main, and run a insert into table select * from sync.table This is extremely slow, it...

Posted to General (Forum) by pentium10 on 01-23-2010
Re: Newbie question for CF: "Can't find PInvoke DLL 'SQLite.Interop.060.DLL"

After being close to going crazy with the same issue, I finally found the solution. I posted here to spare others the trouble: In VS use the function 'Add existing item' on project level to include the two DLLs ( System.Data.SQLite.dll and SQLite.Interop.060.DLL ). For each of them set the property...

Posted to General (Forum) by zuppi on 11-23-2009
Database file isn't copying over?

I'm playing around a bit with trying to get a sqlite database to open and display in a mobile application, and I'm having some trouble getting it going. From what I can tell, the file isn't being copied like it's supposed to. When I go into file explorer on the simulator, there is a file...

Posted to General (Forum) by andyd273 on 09-14-2009
SQLite an PocketPc Application: SQLiteError no such table

Hi all! I'm writing pocket pc application with vs2008, started two days ago and still sqlite doesn't work. I went through all that stuff described in forum: 1. I created sqlite database with designer, and when i deployed to windows emulator got Interop.dll error, so i add dll to my project as...

Posted to How To (Forum) by Adrian Serafin on 08-07-2009
Connection error

I am using ADO.NET provider installed by "SQLite-1.0.64.0-setup.exe". I am developing client application using VS2008 and compact framework 3.5. Here is the code using System.Data.SQLite; public class GlobalDFinderMethods { private static SQLiteConnection sql_con; private static SQLiteCommand...

Posted to General (Forum) by abhinandan.pm on 07-22-2009
Re: Improving speed on Pocket PC

I ran into a similar situation. I was using parameterized queries to perform inserts/updates/deletes for a desktop application. The initial inserts down onto the client could exceed 400,000 inserts for a given table while after that I just pushed down changes. This works well and is lightning fast on...

Posted to General (Forum) by Nazguy on 02-26-2009
SQLite error: no such table: tblLogin

Dear all, I am coding the SMS Management Application for my Pocket PC Windows Mobile 6.1 and use SQLite. I created db3 file and tables by Visual Studio 2008. I drap and drop tables from Server Explorer to Dataset Designer. I also edited connection string in dataset source code and copy SQLite.Interop...

Posted to General (Forum) by tavu on 02-11-2009
Use SQlite at VS2008 full and compact framework in one Program

I need to write a program wich can running at CE 5.0 and at PC. I have all functions running, but not the SQLite. What must i refernce at VS2008 for using the programm on CE. Which dll must to CE, and wich to PC? Can anybody help? Thanks.

Posted to How To (Forum) by Onelucky2 on 12-10-2008
C#, .NET CF 2.0 - The changes are not saved on database.

The scenario: Application developed with Visual Studio 2005, C#, .NET CF 2.0, SQLite, Windows CE 5. The problem. The user search for a register in database, runs OK, the user change a information in the register and save it. The user make a new search for that register, and the new information is ok...

Posted to General (Forum) by acidbytes on 06-04-2008

Page 1 of 2 (13 items) 1 2 Next >